SQL Server Diagnostic Information Queries for September 2014

I revised a number of the queries this month in all five versions of the script. I have also added several new queries to the SQL Server 2012 and SQL Server 2014 versions of the script. Here are the current query counts for each version: SQL Server 2014         72 Queries SQL Server 2012         69 Queries […]

SQL Server Diagnostic Information Queries for July 2014

I revised several of the queries this month in all five versions of the script. There are also two new queries for SQL Server 2014, and one new query in the SQL Server 2008 through SQL Server 2012 versions of the script. Rather than having a separate blog post for each version, I have just […]

SQL Server Diagnostic Information Queries for June 2014

I added several new queries this month to all five versions of the script. I also spent quite a bit of time getting all five versions back in synch as much as possible, as far as my comments and other minor differences that had cropped up over the last few months. Rather than having a […]

Most Recent Cumulative Updates for SQL Server 2008-2014

Here are the most recent cumulative updates for SQL Server 2014, 2012, 2008 R2 and 2008 (as of June 27, 2014) SQL Server 2014 RTM CU2 (12.0.2370)           released on June 27, 2014 Microsoft has now released the second cumulative update for SQL Server 2014 RTM, which has 48 hotfixes by my count from the KB […]

SQL Server Diagnostic Information Queries for April 2014

I made some small improvements to a few of the queries this month. I plan to add several more SQL Server 2014 specific queries over the next couple of months, along with a lot more comments on how to interpret the results of each query in the entire set. Rather than having a separate blog […]

SQL Server Diagnostic Information Queries for March 2014

I made a couple of changes in the order of the queries this month and made some other small improvements to a few queries. Rather than having a separate blog post for each version, I’ll just put the links for all five major versions in this single post. There are two separate links for each […]

SQL Server Diagnostic Information Queries for February 2014

I improved the file-level latency query this month and made some other small improvements to a few other queries. Rather than having a separate blog post for each version, I’ll just put the links for all five major versions in this single post. There are two separate links for each version. The first one on […]

Final Service Packs for SQL Server 2008 and SQL Server 2008 R2

As we get ever closer to the end of mainstream support for both SQL Server 2008 and SQL Server 2008 R2 on July 8, 2014, I am very curious whether Microsoft is planning on releasing a SQL Server 2008 R2 Service Pack 3 or a SQL Server 2008 Service Pack 4 ? SQL Server 2008 […]

SQL Server Diagnostic Information Queries for January 2014

I spent some time this month to true up the SQL Server 2005 version, with the other versions for the queries that are common between all of these versions, since some small differences had cropped up over time across those versions. I also added the drive-level latency query to the 2005 version. Rather than having […]

Creating SQL Server Agent Alerts for Critical Errors

One necessary part of being a responsible DBA is to try to configure your SQL Server instances in such a manner so they will be as reliable as possible. This begins with how you initially install and configure the operating system and SQL Server, and what you do over time to maintain and monitor your […]

Performance Related Fixes in Post-SQL Server 2008 R2 Service Pack 2 Builds

As you may be aware if you have been reading my blogs or books over the years, I am a pretty strong advocate of staying current with both SQL Server Service Packs and SQL Server Cumulative Updates. This is also something that SQLskills recommends on our customer engagements. Despite this, it is still quite common […]

Most Recent Cumulative Updates for SQL Server

Here are the most recent cumulative updates for SQL Server 2012, 2008 R2 and 2008. SQL Server 2012 RTM CU10 (11.0.2420)          released on October 21, 2013 SQL Server 2012 SP1 CU6 (11.0.3381)            released on September 16, 2013 If you are on SQL Server 2012, both RTM and Service Pack 1 are still a “supported service […]

SQL Server 2008 R2 SP2 CU9

Microsoft has released SQL Server 2008 R2 SP2 CU9, which is Build 10.50.4295. This CU has eighteen hotfixes in the public fix list. Some of the more important ones are listed below: FIX: Poor performance when SQL Server 2008 or SQL Server 2008 R2 requires memory from a local node in a NUMA environment FIX: […]

Scaling SQL Server 2012 Pre-Conference Session

In just a couple of weeks, I will be giving a full day pre-conference session at the SQLPASS 2013 Conference in Charlotte, North Carolina. My pre-conference session will be on Monday, October 14, 2013. This pre-con’s going to be a lot of fun, and it will be a great way to kick off the SQLPASS […]

SQL Server Diagnostic Information Queries for September 2013

I have made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this month. I have also added a new version for SQL Server 2014. Rather than having a separate blog post for each version, I’ll just put the links for all five versions here. SQL Server 2005 […]

How To Avoid Orphaned Database Users with SQL Server Authentication

One common issue that database administrators often run into is the old, familiar “orphaned” user problem. This happens when you use SQL Server Authentication to create a SQL Server login on your database server. When you do this, SQL Server generates a unique SID for that SQL Server login. After you create the SQL Server […]

A SQL Server Hardware Tidbit a Day – Day 15

For Day 15 of this series, I will be covering a few tools that can be used for hardware identification. Since quite a few database professionals do not have direct access to their database servers (i.e. they cannot login to their database server via RDP), I will talk about what you can learn about your […]

Estimating Data Compression Savings in SQL Server 2012

SQL Server Data Compression (which was first introduced in SQL Server 2008, and is an Enterprise Edition only feature) lets you compress individual indexes with either ROW or PAGE compression. It can be a huge win for many SQL Server workloads, by letting you reduce both your required disk I/O and your memory usage at […]

How to Find Out About the Latest SQL Server Service Packs and Cumulative Updates

Since someone asked me about this today, I thought I would write about it.  Aaron Bertrand (blog|twitter) and I sort of have a friendly competition to be the first to blog when a new SQL Server CU is released.  I don’t know of any e-mail notification service for Service Packs and Cumulative Updates from Microsoft. […]

SQL Server 2008 R2 Service Pack 1 Cumulative Update 11

On February 18, 2013, Microsoft released SQL Server 2008 R2 Service Pack 1 Cumulative Update 11, which is Build 10.50.2869. There are only four fixes in the public fix list for this cumulative update. This cumulative update is only for SQL Server 2008 R2 Service Pack 1. If you have a different version and/or service […]

SQL Server 2008 R2 Service Pack 2 Cumulative Update 5

On February 18, 2013, Microsoft released SQL Server 2008 R2 Service Pack 2 Cumulative Update 5, which is Build 10.50.4276. There are 21 fixes in the public fix list for this cumulative update, which is a pretty decent amount of fixes. This cumulative update is only for SQL Server 2008 R2 Service Pack 2. If […]

Important Hotfix for SQL Server 2008 and Newer

Microsoft recently released a hotfix for a memory leak leak issue that affects SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012. This memory leak only occurs if the have the AUTO_UPDATE_STATISTICS_ASYNC database level setting enabled for any of your databases. Here is how Microsoft describes the issue in the hotfix KB article: […]

Performance Related Fixes in Post-SQL Server 2008 R2 Service Pack 1 Builds

As you may be aware if you have been reading my blogs or books over the years, I am a pretty strong advocate of staying current with both SQL Server Service Packs and SQL Server Cumulative Updates. This is also something that SQLskills recommends on our customer engagements. Despite this, it is still quite common […]

Top 10 Learning Resources for Accidental DBAs

So what should you do if you are an “accidental DBA”, who ends up dealing with SQL Server in some capacity on a regular basis without the benefit of any training or experience?  What if you are what I like to call a “captive DBA”, because you must install, maintain, and support some other Microsoft […]

How to Create SQL Server Agent Alerts for Critical Errors

One necessary part of being a responsible DBA is to try to configure your SQL Server instances in such a manner so they will be as reliable as possible. This begins with how you initially install and configure the operating system and SQL Server, and what you do over time to maintain and monitor your […]

Hardware 101 Presentation in Bellevue, WA – August 14, 2012

I recently had the opportunity to give a one hour presentation called Hardware 101: An Introduction to Database Hardware during the evening, after a full day of SQLskills Immersion Event 2 (IE2) training. Even though it was an evening event, after almost 10 hours of intense training that day, nearly all of the students stayed […]

How to Obtain and Install SQL Server Service Packs and Cumulative Updates

If you are in charge of one or more SQL Server instances, whether they are on your laptop, or a large Production data center, you should be aware of how SQL Server updates and fixes are released, and how you can obtain them from Microsoft. First, a few definitions: RTM means Release to Manufacturing. It […]

How to Perform a Rolling Edition Upgrade While Using Database Mirroring

Imagine that you are using synchronous database mirroring with SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012 Standard Edition, but you want to upgrade the instances on both sides of the mirroring partnership to SQL Server Enterprise Edition so that you can take advantage of some of the valuable […]

Recommended Intel Processors For SQL Server 2012 OLTP Workloads

If you are in the process of evaluating and selecting the components for a new database server to run an OLTP workload on SQL Server 2012 Enterprise Edition, you have several initial choices that you have to make as a part of the decision process. First you have to decide whether you want to go […]