SQLIntersection conference wrapup

Two weeks ago was a busy one. I helped coordinate and spoke at our second SQL Saturday Omaha on April...

5 SQL Server White Papers Every DBA Should Read

There are countless sources for information on SQL Server available today.  There are books, webcasts, conferences, and blogs.  With all...

Consultants – Why pay more?

As an independent consultant who has a higher bill rate than average, I would hope it is obvious to clients that the...

SQL Lunch – GeoFlow: 3D Geospatial Visualization

Join me next month to learn about a new Geospatial visualization feature of Excel 2013 on the SQL Lunch.

Lunch Details

#75-GeoFlow:...

Adding Data to Filestream with T-SQL

I’ve written on how to enable Filestream and how to add a filegroup, but I haven’t touched the Filestream impact...

Database Administration KPIs – 1/2

 
As a DBA, we may all have this question: How should my work be evaluated objectively? or in another way,...

Database Administration KPIs – 1/2

 
As a DBA, we may all have this question: How should my work be evaluated objectively? or in another way,...

How to backup a SQL 2012 database directly to Windows Azure

It has been a little while since I posted something and I’ve been meaning to finish off this blog for...

PowerSQL – Generate Only Index Script of All Tables or Specific Tables

Background of this implementation-As a part of Performance tuning, We noticed huge avg_disk_queue_length on F drive after analysis, we’ve recommended to...

Identify the cause of SQL Server blocking

In my previous article (Different techniques to identify blocking in SQL Server) on MSSQLTips.com, I discussed about locks and blocks,...