Cumulative updates are not to be feared; the cautionary text accompanying them will soon be a thing of the past.
Yearly Archive: 2015
I reveal details about the changes to Availability Groups that will ship in the next major version: SQL Server 2016.
I highlight a handful of Connect items aimed at improving SQL Server showplan diagnostics and query tuning in general.
I walk through a solution that allows you to achieve some of the benefits of partitioning, without the Enterprise Edition price tag.
I share a few of the queries I use to quickly hone in on changes that have been implemented between SQL Server CTPs.
I list out the changes to In-Memory OLTP ("Hekaton") that will make the feature even more appealing in SQL Server 2016.
SQL Server has released SQL Server 2012 Service Pack 3. You can download here and see some other details here. Build number is 11.0.6020.0 37 fixes (see the full list in KB #3072779) SP3...
Tip : Phase out CONTEXT_INFO() in SQL Server 2016 with SESSION_CONTEXT()
I highlight three Connect items that will address some pretty important shortcomings in SQL Server statistics.
For this T-SQL Tuesday, I treat some of the most memorable data modeling sins from over the years.
Tip : Advanced JSON Techniques in SQL Server 2016 – Part 2
Tip : SQL Server 2016 Advanced JSON Techniques – Part 1
I show some interesting maintenance opportunities for Service Broker queues available in the next version of SQL Server.
I talk about new arguments to SERVERPROPERTY() that make @@VERSION even more obsolete (and changes that make @@VERSION problematic).
Tip : Build a cheat sheet for SQL Server date and time formats
I show the most efficient way to return a running MAX or MIN aggregate in a grouped SQL Server query.
Tip : Cleanly Uninstalling Stubborn SQL Server Components
I explain how SQL Server 2016 improves tempdb configuration and performance.
Tip : Search all string columns in all SQL Server databases
I share my deck and sample code from my most recent SQLSaturday appearance.
Microsoft has released Cumulative Update #8 for SQL Server 2012 Service Pack 2. KB Article: KB #3082561 24 fixes total (23 fixes listed publicly at time of publication) Build number is 11.0.5634 Relevant for...