SQL Server: Part1 : All About SQL Server Statistics :Density Vector

In our daily life, we use the statistics to take the decision. In the same way SQL server optimizer  use...

Terminate a SSIS package after specific time interval.

Terminate a SSIS package after specific time interval.
 
There are several ways you can execute scheduled SSIS package/job they are: 

A)     SQL...

The Secret to Keeping Your Cool Like an Experienced Production DBA

Your actions as a Database Administrator can make the difference between a disaster being a minor nuisance or a major problem.

In this post I share with you what I...

VMware vSphere Storage Performance - Thick vs Thin Provisioning

Industry experts will tell you that virtualization of your environment is not done to improve performance, it's done to make...

Baseline SQL Server with SQL Sentry Performance Advisor

Baselines can be any set of metrics that have been recorded to give you an understanding of what is the...

Comparing Previous Rows in SQL

I had a client recently that needed me to get the direction a student’s GPA was headed on a regular...

Don’t Use MD5

“The hashing alone being MD5 tells me that they really don’t care about their passwords too much, so it’s probably...

Dynamic calculations of running totals

 Dynamic calculations of running totals
A few weeks back, a friend from South Africa wrote to
me asking if I knew of a...

I Don’t Care

It’s funny how certain sentences can both accurately reflect a situation and communicate entirely the wrong message.
When thinking about cloud-based...

Last Weeks Top “Reading” Links #38

For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...