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....

Get All SESSIONPROPERTY Values for Your Session

As a follow-up to my SERVERPROPERTY() post, this is a quick script to grab all the SESSIONPROPERTY() values from your current session in a table. Useful when you forget...

Get All SESSIONPROPERTY Values for Your Session

As a follow-up to my SERVERPROPERTY() post, this is a quick script to grab all the SESSIONPROPERTY() values from your...

Help with testing Denali, SQL Server 11

Earlier this week, Dan Jones, one of the Microsoft employees on the SQL Server team, wrote a blog post asking...

Interview with SQL Server MVP Grant Fritchey

Grant Fritchey will be speaking at the SQLServerCentral.com track at SQL Server Connections, October 31-November 3, 2011, in Las Vegas,...

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....

SQL Server – Hide an Instance of SQL Server

You can browse available SQL Instances on network by choosing "<Browse for More..>" from Server Name drop-down list in "Connect...

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...

SQLRelay UK

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

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,...