SQLRelay UK

With the Olympics coming to the UK next year what better way to get into the spirit of things than...

Running totals in “Denali” CTP3

One of the things that I’m the most excited about in “Denali” CTP3 is the enhancements to the OVER clause....

TSQL Sudoku II

Learn how to solve Sudoku puzzles quickly with a TSQL Script.
Related Posts:

Puzzles and Daily Trivia May 14, 2019

Summiting that Technical Challenge Part II July 6, 2018

Passion, Challenges,...

TSQL Sudoku II

As luck would have it, today I came across this TSQL Challenge.  It just so happens that I had already...

Defining Your Culture

Imagine that you take over a team, department, maybe even a whole company, and as you look around at how...

Disk IO performance and SQLIO

Performance testing  a new disk subsystem  from a SQL Server perspective is one of the fun aspects of DBA work....

Autogrow bug – fixed with Denali

Recently I ran into a bug related to autogrow of the log file. Because this was the second time I...

SQLMCM Training – Day 15

The whole last 3 days I've spent almost every minute with reviewing the material from
the last 2 weeks (around 38...

Outstanding DBAs Make Relationships a Priority

In our open all hours global working world, do you ever wonder if perhaps the technology that is supposed to...

SQL Server – sys.dm_db_persisted_sku_features tells you about edition-specific features

sys.dm_db_persisted_sku_features lists all features which are utilized by the database. Features specific to Enterprise/Developer edition are:

- Compression,
- Partitioning,
- TDE and...