DROP INDEX and CREATE INDEX vs ALTER INDEX REBUILD

I saw someone ask a few weeks ago if it was faster to drop and re-create an index or do...

Rebuilding and Reorganizing Clustered Columnstore Indexes

Clustered Columnstore Indexes, as well as “regular” indexes, support the Rebuild and Reorganize operations. However, the meaning of those operations...

Converting Dates

I ran across a post recently where someone had dates stored as characters (never good), but also in this format:...

Sequence feature TIP #76

Although it is a old feature for those who knows ORACLE but for SQL server developers it is a new...

SQL Saturday NYC Update #2

Just over 2 weeks now since SQL Saturday NYC went live and planning is in full force.  An update on...

SQL Server Bugs That Might Bite You

I’m on my way to give a presentation at the PASS Database Administration Virtual Chapter about SQL Server bugs. All the materials...

Getting Your Worth the Struggles with Moving Ahead

I often get asked for advice on how to get started in a career as a DBA or in IT...

Runbooks in SQL Azure

Runbooks in SQL Azure
DECEMBER 2, 2014

SQL Azure Runbooks promise to be your “SQL Server Agent in the cloud”. They enable you to use PowerShell Scripts inside of SQL Azure...

Runbooks in SQL Azure

Runbooks in SQL AzureDECEMBER 2, 2014SQL Azure Runbooks promise to be your “SQL Server Agent in the cloud”. They enable...

TSQL Tuesday #61: How I plan on Giving Back

A little over 5 years ago, Adam Machanic (B|T) had this great idea of getting everyone in the SQL Community...