News in the Category: SQL Subscribe to the rss of this category.

Total posts: 7775 | Sort by Views | Sort by Hits

SQL SERVER Errors When Disk Space is the Reason

Journey to SQL Authority with Pinal Dave, December 5, 2016
Views: 74 | Hits 3

In the past, I have written a number of blogs when it comes to working with errors pertinent to disk space running out. In this blog, I try to consolidate the common messages you are going to see in t...

DMV to Replace DBCC INPUTBUFFER Command Interview Question of the Week #100

Journey to SQL Authority with Pinal Dave, December 4, 2016
Views: 81 | Hits

Question: Is there any way to replace DBCC INPUTBUFFER Command?First appeared on DMV to Replace DBCC INPUTBUFFER Command – Interview Question of the Week #100...

SQL SERVER FIX Error Cluster Network Name showing NETBIOS status as The system cannot find the file specified

Journey to SQL Authority with Pinal Dave, December 3, 2016
Views: 106 | Hits

Over a period, I have learned that fixing an issue is easier if we know which log we should look at and what we should search on google. Here is the situation which I was into few days back. In this ...

SQL SERVER Fix Connection Error [Microsoft][ODBC SQL Server Driver][DBNETLIB][ConnectionOpen(Connect())

Journey to SQL Authority with Pinal Dave, December 2, 2016
Views: 113 | Hits 2

As a part of my quick consultancy, I was contacted by a client who was having trouble where the application was not able to connect to SQL Server. We all joined the call and desktop sharing to learn m...

Lists With, or Without, Ranges in both T-SQL and PowerShell

Simple Talk, December 1, 2016
Views: 119 | Hits 7

Whether you are working in a procedural language like PowerShell or in T-SQL, there is something slightly bothersome about having to deal with parameters that are lists, or worse with ranges amongst t...

Reconciling Data Across Systems Using a Reconciliation Hub

Simple Talk, December 1, 2016
Views: 97 | Hits 1

In many enterprises, where there are a number of separate systems engaged in processing data, there arises the daunting task of checking and reconciling data as it flows between systems. Discrepancie...

How to Build Your First SQL Server Virtual Lab in Windows Azure

Simple Talk, December 1, 2016
Views: 99 | Hits 3

If you are a DBA who hasn't so far dived in head-first into using Azure, it is worth setting up an Azure 'Virtual Lab' environment the easy way, using a template. This will then allow you to experim...

SQL SERVER Log Shipping Copy Job Failure The Password for This Account Has Expired

Journey to SQL Authority with Pinal Dave, December 1, 2016
Views: 109 | Hits

Working as freelancer gives an opportunity to see various kinds of error and having fun to fix them. Recently, one of my blog readers sent an email and asked assistance on the log shipping issue. He s...

SQL SERVER How to Find the In-Memory OLTP Tables Memory Usage on the Server

Journey to SQL Authority with Pinal Dave, November 30, 2016
Views: 133 | Hits 2

When I presented at the SQLPASS this year there were several learning that I found it interesting. Every year, this presentation preparation is something I take it seriously. I know many them turn up ...

Planning for Successful Data Management

Simple Talk, November 29, 2016
Views: 127 | Hits 1

It is the data, in particular, that sets Database Lifecycle Management apart from the mainstream of application delivery. Data entities, and the way that organisations understand and deal with them,...

Determining What Happens When You Force an Execution Plan via the Query Store

Simple Talk, November 29, 2016
Views: 130 | Hits 3

When you force a query plan via the Query Store, you will need to track what happens: Sometimes the request to force a plan will fail, and you will want to know when and why. There are several ways ...

SQL SERVER Error Disallowing page allocations for database DB due to insufficient memory in the resource pool

Journey to SQL Authority with Pinal Dave, November 29, 2016
Views: 106 | Hits

Keeping SQL Server up-to-date is something I recommend my customers from time to time. One of the tasks I undertake is to check the current SQL Server version information as soon as I get started to w...

SQL SERVER Playing with Backups and Compression

Journey to SQL Authority with Pinal Dave, November 28, 2016
Views: 138 | Hits 6

The era of innovation with SQL Server administration side of things keep happening, it is strange that a lot of us miss these capabilities getting added into the system. I have seen processes define t...

How to Downgrade Database from SQL Server 2014 to SQL Server 2012 Interview Question of the Week #099

Journey to SQL Authority with Pinal Dave, November 27, 2016
Views: 137 | Hits 4

Question: How to downgrade from SQL Server 2014 to SQL Server 2012?Answer: Not possible.First appeared on How to Downgrade Database from SQL Server 2014 to SQL Server 2012 – Interview Question of the ...

SQL SERVER System Function @@IDLE to Find System Ideal Time

Journey to SQL Authority with Pinal Dave, November 26, 2016
Views: 203 | Hits 3

Just the other day I got an email with user asking how do the @@idle function work with SQL Server as when he runs them it gives him some number but the number is not easy to interpret. I totally agre...

SQL SERVER Stop Growing MSDB Database by Removing sysmail_mailitems History

Journey to SQL Authority with Pinal Dave, November 25, 2016
Views: 110 | Hits

Received an email "Need your urgent help On Demand, our MSDB Database has grown too big and we need help to check our sysmail_mailitems table. We are also facing performance issues." I have been an ...

SQL SERVER Rule Windows Management Instrumentation (WMI) Service failed

Journey to SQL Authority with Pinal Dave, November 24, 2016
Views: 134 | Hits 1

When I visit my client site for doing performance tuning consulting, I sometimes get trapped with some unrelated issue. Here is one of the situation where they were upgrading from SQL 2008 R2 to SQL 2...

SQL SERVER Msg 19062, Level 16, State 1. Could Not Create a Trace File. Error = 0x80070005

Journey to SQL Authority with Pinal Dave, November 23, 2016
Views: 128 | Hits 1

One of my clients reported a strange problem and I learned something new from it. Here is the conversation where we discussed how to fix error 19062 - could not create a trace file. First appeared on ...

LLBLGen Pro v5.1 RTM has been released!

Frans Boumas blog, November 22, 2016
Views: 131 | Hits 4

After 2 successful EAPs and a beta, were happy to release the RTM version of LLBLGen Pro v5.1! To see whats new in detail please see the blogposts about EAP1, EAP2, and the Beta. In short: Entity Fr...

SQL SERVER Database Mirroring Error -The Specified Network Name is No Longer Available

Journey to SQL Authority with Pinal Dave, November 22, 2016
Views: 121 | Hits 1

Have you ever seen a situation where SQL Server mirroring is impacted because of external factors? One of my customers reported several of the following errors in the SQL Server ERRORLOG SQL SERVER W...

Virtue in the Virtual

Simple Talk, November 21, 2016
Views: 123 | Hits 4

Are we now seeing just a frisson of excitement amongst database professionals at the potential of virtualization, and containerization technologies? I read with interest Andrew Pruski’s recent post on...

SQL SERVER Best Practices About SQL Server Service Account and Password Management

Journey to SQL Authority with Pinal Dave, November 21, 2016
Views: 116 | Hits 5

One of my clients posted a question to me about management of SQL Server service account. Since it was a nice learning for me, I am sharing my discussion via this blog post. Let us see the Best Practi...

How to Find Longest Running Query With Execution Plan Interview Question of the Week #098

Journey to SQL Authority with Pinal Dave, November 20, 2016
Views: 113 | Hits 9

Question: How to find the longest running query in SQL Server with Execution Plan? First appeared on How to Find Longest Running Query With Execution Plan – Interview Question of the Week #098...

SQL SERVER 2016 DBCC Command Enhancement with MAXDOP

Journey to SQL Authority with Pinal Dave, November 19, 2016
Views: 120 | Hits 1

When you want to be successful, you need to run alone and fast. But if you want to run longer, you want to run together. I have personally seen multiple instances where this statement holds true to ev...

DevOps and Data Lifecycle Management

Simple Talk, November 18, 2016
Views: 117 | Hits 3

Database Lifecycle Management (DLM) aims to provide a roadmap of of what is required, and when, to deliver and maintain effective databases that can respond quickly to business change. How does the...

SQL SERVER Back to Basics What is Azure?

Journey to SQL Authority with Pinal Dave, November 18, 2016
Views: 109 | Hits 1

Recently I was at a community session talking to a bunch of computer science students about databases and the type of work I have been doing lately in consulting. I wanted to talk about Performance tu...

SQL SERVER SQLPASS 2016 Feedback and Rating Kick Start! SQL Server 2016 Performance Tips and Tricks

Journey to SQL Authority with Pinal Dave, November 17, 2016
Views: 113 | Hits 3

Earlier this year, I presented at SQLPASS 2016, Seattle on SQL Server 2016 and I am very happy to see the feedback of my sessions. I have presented two sessions and I will write feedback of one sessio...

SQL Authority News Download SQL Server 2016 Service Pack 1 (SP1)

Journey to SQL Authority with Pinal Dave, November 16, 2016
Views: 118 | Hits 4

Microsoft has earlier released SQL Server 2016 Service Pack 1 (SP1). This particular SP1 is one of the kind service pack and I will say it is a milestone move by Microsoft.Now with this SQL Server 201...

Using Power BI Desktop to Visualize SQL Server Metadata

Simple Talk, November 16, 2016
Views: 110 | Hits 10

You can easily use PowerBI Desktop to show graphically how your database is growing, which tables are taking the most space, how various parts of SQL Server is consuming memory, its use of indexes an...

SQL SERVER Unable to Bring Resource Online Error Could Not Find Any IP Address that this SQL Server Instance Depends Upon

Journey to SQL Authority with Pinal Dave, November 16, 2016
Views: 94 | Hits

When it rains, it pours. In the last few days last few contacts from my customers were for cluster related issues. Once again, the SQL Server resource was not coming online in failover cluster manager...

SQL SERVER Analysis Services and the Network Performance

Journey to SQL Authority with Pinal Dave, November 15, 2016
Views: 106 | Hits 5

SQL Server Analysis Services (SSAS) is becoming increasingly popular as an OLAP platform for business analysts. There are many tools available for enhancing the analysts ability to process data and ge...

.NET Core On Mac - Building An ASP.NET Core App With Web API, EF, PostgreSQL And Running It On Docker

The Code Project Latest Articles, November 14, 2016
Views: 116 | Hits 6

A quick demo tutorial on how to setup .NET Core on Mac and creating a simple ASP.NET Core app that talks to PostgreSQL database, and running it on Docker....

SQL SERVER FIX: Incorrect Syntax Near the Keyword PROCEDURE

Journey to SQL Authority with Pinal Dave, November 14, 2016
Views: 87 | Hits 4

Along with freelancing, consulting, I also spend time in replying to my blog comments to learn something new. Few such conversations end up in business deals, few in emails and few in the blog. This b...

How to Find Size of All the Indexes on the Database Interview Question of the Week #097

Journey to SQL Authority with Pinal Dave, November 13, 2016
Views: 92 | Hits 5

Question: How to Find Size of All the Indexes on the Database?First appeared on How to Find Size of All the Indexes on the Database – Interview Question of the Week #097...

SQL SERVER How to Get List of SQL Server Instances Installed on a Machine?

Journey to SQL Authority with Pinal Dave, November 12, 2016
Views: 100 | Hits 4

There are multiple ways by which we can find a list of SQL Server instances name instances on a machine. In this blog, I would show a few ways to do it.First appeared on SQL SERVER – How to Get List o...

Understanding Database Scalability Horizontal and Vertical Scalability Better Together

Journey to SQL Authority with Pinal Dave, November 11, 2016
Views: 113 | Hits 7

When I wrote the blog around Understanding Database Scalability Vertical and Horizontal, I saw few have conversations with me on if it is this or that. And these discussions could take a course all b...

SQL SERVER Unable to bring resource online. Error Data source name not found and no default driver specified

Journey to SQL Authority with Pinal Dave, November 10, 2016
Views: 108 | Hits 1

One of my blog readers reported a strange issue to me. As per the issue described, they were unable to bring SQL Server resource in cluster online, only on one node of the cluster. I always use for er...

Cloud Consulting Pre-Engagement Questionnaire A Bookmark

Journey to SQL Authority with Pinal Dave, November 9, 2016
Views: 119 | Hits 1

The cloud phenomenon is no more a dream for many, but a reality for several customers I have been working with. Many of my customers are looking for guidance and from time to time I get an opportunity...

SQL SERVER Added New Node in Windows Cluster and AlwaysOn Availability Databases Stopped Working

Journey to SQL Authority with Pinal Dave, November 8, 2016
Views: 128 | Hits 1

Almost all the time, whenever there is a wizard, its a human habit to go with the defaults and finally click finish. Once of my client sent below email to me. In this blog post we are going to learn a...

SQL SERVER Fix Error Msg 10794, Level 16 The operation CREATE INDEX is not supported with memory optimized tables.

Journey to SQL Authority with Pinal Dave, November 7, 2016
Views: 135 | Hits 1

Whenever I write something as a new concept, I do see people reading the blog do give it a try. Many a times I get queries that the script didnt work for them after they learnt the concepts about memo...

How Many Foreign Key Can You Have on A Single Table? Interview Question of the Week #096

Journey to SQL Authority with Pinal Dave, November 6, 2016
Views: 140 | Hits 10

Question: How Many Foreign Key Can You Have on A Single Table?I was asked above question in my recent SQLPASS presentations. I quickly answered that it is 253. However, after I returned home when I se...

SQL SERVER Cannot Show Requested Dialog Property Size is Not Available for Database

Journey to SQL Authority with Pinal Dave, November 5, 2016
Views: 129 | Hits 2

Freelancing gives me a lot of opportunity to see issues which I have not seen earlier. Learning never stops for me and I love sharing what I learn every day. Let us learn about how to fix the error Pr...

SQL Server Database Provisioning

Simple Talk, November 4, 2016
Views: 139 | Hits 4

Database provisioning for development work isn't always easy. The better that development teams meet business demands for rapid delivery and high quality, the more complex become the requirements fo...

When Stored Procedures Go Bad

Simple Talk, November 4, 2016
Views: 127 | Hits 10

It is far easier to work out what is wrong with a slow-running SQL query than one that shows erratic performance. DBAs will groan when a process occasionally performs terribly without apparent reason....

SQL SERVER Unable to Attach Database File Activation Failure The Log Cannot be Rebuilt

Journey to SQL Authority with Pinal Dave, November 4, 2016
Views: 128 | Hits 1

Once I was in a situation where there was a disaster faced by my client. They lost the drive which was having transaction log file. Since they did not have effective monitoring, they realized that the...

Using SQLite with PowerShell and SQL Server.

Simple Talk, November 3, 2016
Views: 129 | Hits 6

When you combine PowerShell and SQLite, you can perform powerful magic. Phil Factor is in awe of SQLite and gives a brief demonstration of how easy it is to use. Just to encourage anyone who is unfam...

The time I was top link on Hacker News and Azure killed my site: lessons learned

Code Climber, November 3, 2016
Views: 120 | Hits 8

Monday morning (USA time) 31st October 2016, at a certain point my post about Surface Book vs MacBook Pro got the first position on Hacker News. It triggered a good amount of discussion, and luckly th...

SQL SERVER Creating Clustered ColumnStore with InMemory OLTP Tables

Journey to SQL Authority with Pinal Dave, November 3, 2016
Views: 111 | Hits 1

When SQL Server 2016 was released, there were a number of enhancements that were discussed around how InMemory OLTP removed which were as limitations. I personally saw some real boot to some of the ca...

Personal Technology Expanding to Open Folder Working with Windows 10

Journey to SQL Authority with Pinal Dave, November 2, 2016
Views: 124 | Hits 5

We are all hard wired when it comes to doing certain tasks. I have attended tons of sessions at the local SQL Server user group meets and it amazes me every time to what I didnt know about the tools t...

10th Anniversary of SQL Authority Thank YOU!

Journey to SQL Authority with Pinal Dave, November 1, 2016
Views: 129 | Hits 2

10 years ago, today I started to blog, at http://blog.sqlauthority.com - I had no idea where this journey will bring me. I honestly had no idea. Lots of people ask me so many questions about blog so t...