I now  have a red, P85 Tesla Model S. I picked it up at the Denver Tesla Service Center on May 3, 2013.  After slightly more than a week of ownership, I am still extremely happy. It is incredibly quick (0-60 in 4.0 seconds), it handles well, and it… Read more

Here is the May 2013 version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries.

To go with it is an updated, blank 2005 results spreadsheet, where the tabs in the spreadsheet are labeled and in the…

Read more

Here is the May 2013 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have decided to split off this into a separate version just for SQL Server 2008.

To go with it is an updated,…

Read more

Here is the May 2013 version of my SQL Server 2008 R2 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have decided to split off this into a separate version just for SQL Server 2008 R2.

To go with it is…

Read more

Here is the May 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have improved the formatting of the results to make many of the queries easier to read and interpret, especially for the missing…

Read more

Here is the April 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have added some new columns to several of the queries, and improved the formatting of the results to make many of the…

Read more

Microsoft has released three new Cumulative Updates for SQL Server today, two for SQL Server 2008 R2 and one for SQL Server 2012.

The first one is SQL Server 2008 R2 SP1 CU12, which is Build 10.50.2874. This CU has seven fixes in the public fix list.

The second… Read more

I will be speaking on both Friday and Saturday (April 5-6) at SQLSaturday #197 in Omaha, Nebraska. I will be delivering a full day pre-con on Friday, and then doing Hardware 201 on Saturday. Here is the abstract for my pre-con:

Scaling SQL Server 2012

How can you scale SQL…

Read more

I had the opportunity to present a full-day preconference session on Friday, March 15, 2013 for SQLSaturday #188 in Lisbon, Portugal. This was the first time I have spoken at a SQLSaturday outside of the United States, and I really enjoyed it! This never would have happened without the enthusiasm…

Read more

Here is the March 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have added some new columns to several of the queries, and improved the formatting of the results to make many of the…

Read more

I had the opportunity to present the latest version of Hardware 301: Diving Deeper into Database Server Hardware two times in one day yesterday! First was a virtual presentation for the PASS Virtual DBA chapter at 12PM, and then I got to do it again at the Rocky Mountain Oracle… Read more

I will be speaking at the PASS Database Administration Virtual Chapter on February 13, 2013 at 12PM MST. I will be presenting the latest version of my Hardware 301: Diving Deeper into Database Hardware deck.

The LiveMeeting link is here. If you want a chance to win a $50.00… Read more

Here is the February 2013 version of my SQL Server 2008 R2 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have decided to split off this into a separate version just for SQL Server 2008 R2. There are also two new…

Read more

Here is the February 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. There is also one new query that looks for missing indexes for all databases on the instance.

To go with it is an…

Read more

Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update 9, which is build 10.00.5829. As you might expect from the build number (which is only one number higher than SQL Server 2008 Service Pack 3 Cumulative Update 8), there are very few fixes in the public fix… Read more

Here is the January 2013 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries mainly focusing on collecting some information about whether Change Data Capture (CDC) is enabled. There is also one new query that breaks down…

Read more

Here is the January 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries mainly focusing on collecting some information about whether Change Data Capture (CDC) is enabled. There is also one new query that breaks down…

Read more

The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog.

Here’s an excerpt:

About 55,000 tourists visit Liechtenstein every year. This blog was viewed about 400,000 times in 2012. If it were Liechtenstein, it would take about 7 years for that many people to see it. Your…

Read more

As you might be aware, SQL Server 2012 Standard Edition has some hardware-related licensing limits that I think should be adjusted in light of the capabilities of modern, commodity server hardware.

As a DBA and consultant, I would like to see everyone running SQL Server 2012 Enterprise Edition. It has… Read more

Here is the December 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to a couple of the existing queries. There is also one new query at the very end, adapted from my colleague, Erin Stellato.

To go with it is…

Read more