Few of my regular readers may have noticed I am not actively blogging @ SSC at frequent interval. There is a reason behind...  Read more...

All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...  Read more...

When I started using SQL Server the company I was working for at the time had no skill in this...  Read more...

This month’s TSQL-Tuesday is hosted by Rob Farley (blog | twitter), who became a Microsoft Certified Master this past December (congrats!)....  Read more...

A while back I put together a blog post on the side effect of NOLOCK.  Today I thought I’d push...  Read more...

As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...  Read more...

The Big 5 IT consulting companies (Accenture, Deloitte Consulting, PwC (formerly PricewaterhouseCoopers LLP), KPMG, Ernst & Young) have various titles given to consultants along...  Read more...

I recently had the opportunity to review a pre-published copy of the “Instant” series book “Creating Data Models with PowerPivot...  Read more...

But, it still works FINE… A good many companies still have servers chugging along on SQL Server 2000 (or even, as...  Read more...

I was working with an auditor today who is working through a system with an external audit agency. The external...  Read more...

Welcome to the Virtual SQL Playground Adventure! Why Adventure? What’s an Adventure? An adventure is an exciting or unusual experience; it may...  Read more...

Note this is not “Best Practices when USING Dynamic SQL”. These are just good habits I’ve come up with over...  Read more...

With the release of SQL Server 2012, Microsoft introduced a new type of nonclustered index called xVelocity columnstore index in...  Read more...

SQL Server Agent Jobs are crucial to any SQL Server environment as they are created and scheduled to perform critical business...  Read more...

Checkout the part-2 of my two part article series on SQL Server Transactions and Lockinghere, in which you will learn...  Read more...

The scripting variables can be defined explicitly by using the setvar command or implicitly by using the sqlcmd -v option....  Read more...

Whether caused by hardware failure, software errors or malicious actions, there is always a possibility of data loss. You should...  Read more...

SQL Server is able to service requests from a large number of concurrent users. When SQL Server is servicing requests...  Read more...

Almost everytime when I’m doing SQL Server consulting engagements, DBAs are showing me queries and their Execution Plans, where SQL...  Read more...

As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...  Read more...