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

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

Computed Columns and CASE

I wrote about computed columns recently, but I didn’t realize that a logical expression could be used here, such as...

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

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