Locked out of SQL Server.

This is a very cool and useful tip if you find yourself locked out of the sysadmin role in sql...

SQL Server – Four-part object names

Generally it is considered good practice using two-part names for objects. It make the code more readable and avoids confusion...

SQL Saturday 130 Deck & Scripts Live

Hello Dear Reader, greetings from SQL Saturday 130 in Jacksonville.  This is just a quick post to say that the...

Always use Configuration Manager for changing service account

When your service account is expired/disabled or is not having access than sql service could not able to start and you may...

Exposing OData Endpoints using the ASP.Net MVC Web API

The new Web API that comes with ASP.Net MVC 4 has been getting a lot of posts on creating RESTful...

SSIS Data Flow Tuning

During my SSWUG webcast I was asked to give some examples on how to tune the DefaultBufferMaxRows and DefaultBufferSize, so here goes.
When a source is pulling in data, it...

SSIS Data Flow Tuning

 During my SSWUG webcast I was asked to give some examples on how to tune
the DefaultBufferMaxRows and DefaultBufferSize, so here goes.

When a source is pulling in data, it places them into...

SSIS Data Flow Tuning

During my SSWUG webcast I was asked to give some examples on how to tune the DefaultBufferMaxRows and DefaultBufferSize, so...

SQL Saturday Houston #107 Recap

I enjoyed a long weekend in Houston starting with Kalen Delaney’s Pre-con on Query Tuning. I have learned over the...

Cool Data Visualization

I attended a course from Edward Tufte a few years ago on Data Visualization, and while I learned some neat...