SQL Server 2014 CTP1 is here!

As I mentioned in my blog post describing the new features in the next version of SQL Server (see SQL Server...

SQL Server 2014 CTP1 Released

It is here! the first CTP for SQL 2014 is available for download from the Technet evaluation centre... Just downloaded...

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