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

The Public Role – a potential high risk security concern for DBAs

The public role is a special fixed-database role, which exists in every SQL Server database. The public role is different from all other database-level...

SQL Server index related dynamic management views and functions (Part 2)

SQL Server uses indexes to sort and organize table data. It creates indexes based on ordering values from one or...