Does SQL Server do a CHECKDB during an instance restart?

When you start up an instance do you rely on the CHECKDB entry in the error log of SQL Server...

SQL Server Debugging with WinDbg – an Introduction

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...

The 3 Factors That Will Get You a Job You’ll Love

It’s T-SQL Tuesday time, and this month’s host, Boris Hristov (blog|twitter) chose the topic of interviews.
Over the time as a...

T-SQL Tuesday #54: An Interview Invitation

It’s time for another T-SQL Tuesday! This month’s blog party is hosted by Boris Hristov (blog | twitter) and the subject...

T-SQL Tuesday #54–Interviews and Hiring

It’s the May T-SQL Tuesday, and this time it’s a great one. This month the host is Boris Hristov (@BorisHristov)...

Verizon PCI and Data Breach Investigation Reports

If you deal with security and especially credit cards it’s worth spending an hour or two to read the 2014...

Add Node to Windows Server 2008 Cluster

Steps : Add Node to Windows Server 2008 Cluster
1) Open Cluster Administration wizard > Right click on Windows Cluster & select Add Node

2)...

Boost the performance of the VMware vSphere Web Client

Ever since it was released, the vSphere Web Client is not the most responsive of web GUIs. After some digging,...

Filetable–Nesting folders and files

In previous posts I showed how to create a folder in a Filetable and also how to the create (and...

Hadoop and Data Warehouses

I see a lot of confusion when it comes to Hadoop and its role in a data warehouse solution.  Hadoop should...