SQL Saturday 467 – Precon – Query processing and internals
Im not doing a tremendous amount of public speaking this year and concentrating on more professional matters, however im pleased...
2015-10-04
300 reads
Dave Ballantyne
Getting out of the ground with TSQL Smells.
At SQLBits I had a number of conversations with a number of people over TSQL Smells, my open source project...
2015-03-23
684 reads
Increasing ColumnStore compression ratio for archival and “Cold storage”
At my present client, part of the task I have to under take is to re-engineer the “Cold Storage”. This...
2015-03-17
359 reads
SQLBits, Incremental Statistics and Demo Fail
So another great SQLBits is done and dusted, many thanks to the team, helpers and sponsors for putting on such...
2015-03-08
481 reads
Non use of persisted data – Part Three
A long time ago I looked at some reasons as to why persisted computed columns ( and therefore indexes on those...
2014-11-02
363 reads
Please please tell me now…
.. Is there something I should know, sang Duran Duran many moons ago when I was young and before I knew...
2014-08-15
398 reads
Reasons why your plans suck : No 56,536
I have been working with SQL server for more years than I really care to mention and like to think...
2014-04-12
388 reads
T4 Support in SSDT
Sometimes a piece of technology passes you by completely, T4 templating happens to have done that for me. On tuesday night,...
2014-03-29
1,149 reads
Whats This Command Bar ?
One of the challenges I faced while creating my TSQL Smells visual studio (SSDT) add in, was trying to find out...
2014-03-13
320 reads
On the move
Its been a fair few years since I started blogging on SQLBlogCasts and the time has now come to find...
2013-04-14
621 reads
Blogs
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers