Microsoft has released SQL Server 2012 Service Pack 1 Cumulative Update 7, which is Build 11.0.3393.0. This CU has 47 fixes in the public hotfix list, a number of which seem to be quite significant for performance and stability.
Here are fourteen database engine-related fixes that are in SQL… Read more
I have made a number updates and bug fixes, including some additional columns in some of the queries for all of the versions of my SQL Server Diagnostic Information Queries for this month. I have also added more comments and links about how to interpret the results.
Rather than having…
I have made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this month.
Rather than having a separate blog post for each version, I’ll just put the links for all five versions here.
I have gone through and 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…
Intel has finally released the 22nm Xeon E5-2600 v2 Family (Ivy Bridge-EP) of processors that will be used in two-socket servers. These processors have slightly better single-threaded performance than the previous 32nm Xeon E5-2600 Family (Sandy Bridge-EP) processors, along with higher physical core counts and lower power usage.
They are… Read more
Two new TPC-E benchmark results have shown up for two-socket database servers using the brand new, 22nm Intel Xeon E5-2697 v2 (Ivy Bridge-EP) processor. The first result is for an IBM System x3650 M4 with 512GB of RAM, that has a score of 2590.93. The second result is for a… Read more
Fellow MVP Paul Randal just blogged about an issue he has discovered with how the master and model databases are created in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012. I just checked, and the same issue is present in SQL Server 2014 CTP1… Read more
On August 20, Microsoft released SQL Server 2012 RTM Cumulative Update 9, which is Build 11.0.2419. I count seven fixes in the public fix list. This a very low number of hotfixes compared to all previous SQL Server 2012 Cumulative Updates, which is probably a good sign about the…
I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this month. I also added two new queries at the end of the script, to collect some information about the SQL Server Agent jobs and about the SQL…
I found out last week that I will be presenting three sessions at the PASS Summit 2013 in Charlotte, NC. The first one will be a full-day pre-conference session on Scaling SQL Server 2012. This will be an updated and reorganized version of the preconference session that I have…
The latest 24 Hours of PASS (24HOP) event will start at 12:00 GMT on July 31, with 24 back-to-back one hour live virtual sessions, ending exactly 24 hours later. I have the honor of presenting the final session of the event, so if you are up and about at 11:00… Read more
Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance
The foundation of database performance is the underlying server hardware and storage subsystem. Even the…
On July 15, Microsoft released SQL Server 2008 Service Pack 3 Cumulative Update 12, which is Build 10.0.5844. I count six fixes in the public fix list.
If you are still running SQL Server 2008 (and I know many people are), you should be aware that only Service Pack… Read more
On July 15, Microsoft released SQL Server 2012 Service Pack 1 Cumulative Update 5. This is Build 11.0.3373, and I count 30 fixes in the public fix list. This CU is only for SQL Server 2012 Service Pack 1.
If you are running SQL Server 2012, I think you… Read more
This is a pretty long story…
My wife and I had an interesting road trip to Salida, CO this past weekend, going to the Colorado Brewer’s Rendezvous. We drove down from Parker, CO on US-285, which was 151 miles. I had a range-charge in my P85 before we left,… Read more
I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this month. Rather than having a separate blog post for each version, I’ll just put the links for all four versions here.
Microsoft has released two new Cumulative Updates for SQL Server 2008 R2. One is for SQL Server 2008 R2 Service Pack 1 and the other one is for SQL Server 2008 R2 Service Pack 2.
I will be speaking at the Boulder SQL Server User’s Group on June 18, 2013 and at the Denver SQL Server User’s Group on June 20, 2013. In both cases, I will be presenting an updated version of Hardware 201. Here is the abstract:
Hardware 201: Selecting and Sizing Database… Read more
There are three new upcoming Immersion Event classes from SQLskills, including one that I will be teaching, which is the two-day IEHW class on September 18-19.
I am really excited to get the chance to teach the IEHW class, and I think it will be a lot of fun! … Read more
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