New Azure SQL Database Service Tiers

Microsoft’s Eron Kelly has recently blogged about Azure SQL Database introduces new service tiers, where the existing Web and Business service tiers will be replaced in twelve months, as they are gradually replaced by six new service tiers, including Basic, Standard 1, Standard 2, Premium 1, Premium 2, and Premium 3. There will be differences […]

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 […]

Learn About SQL Server Hardware in Chicago

On May 5-6, 2014, I will be teaching IEHW: Immersion Event on SQL Server Hardware in Chicago, IL. This is a great opportunity for you to learn how to properly select and configure your server hardware and storage subsystem to get the best performance and scalability for the lowest SQL Server 2012/2014 licensing costs. Now […]

Recommended Intel Processors For SQL Server 2014 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 2014 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 […]

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 […]

Windows Server 2012 R2 Update

Microsoft has released an update for Windows 8.1 and Windows Server 2012 R2 that is somewhat of a cross between a Cumulative Update and a Service Pack. Microsoft is calling this update “Windows Server 2012 R2 Update” which is sort of a silly name. I would have preferred something like “Windows Server 2012 R2 Update […]