Prepare Windows 7 to create Hyper-V Virtual lab to implement SQL Server 2008 R2 SP1 Active/Active Cluster

Prepare Windows 7 to create Hyper-V Virtual lab to implement SQL Server 2008 R2 SP1 Active/Active Cluster

This series of Videos will walk through how to prepare existing windows 7 machine to test and validate active/active node...

SQLMCM Training – Day 16

Today Bob spoke the whole day about securing SQL Server, security itself, and encrypting
data. It was really hard content, and...

A Couple of Data Compression Tricks in SQL Server 2008

As I have said several times before, I am a big fan of data compression in SQL Server 2008 and...

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

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

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