Protected: TSQL Tuesday 108 – Community Rituals

This post is password protected. You must visit the website and enter the password to continue reading.
Advertisements

Identifying delays between SQL calls using SQL profiler

One of the common goto methods for query specific slowness which can be replicated via an application can be to...

DBCC CLONEDATABASE issue: Duplicate key row in sys.sysschobjs

I ran into this error recently while trying to clone a production database:
Msg 2601, Level 14, State 1, LineNumber

Cannot insert duplicate...

Create a slipstream installer for SQL Server on Windows

Since the release of SQL Server 2008 Service Pack 1 in April 2009, it has been possible to install SQL...

Data Classification in SQL Server 2019

One of the areas that Redgate is working on is making data classification easier. Microsoft added some capabilities to SSMS...

Exceeding My Own Expectations in Life!

Wow! The last five years of my career have been amazing. I went from attending a SQLSaturday a couple of...

Keeping Large Table Statistics Current -TF2371

Statistics are the magic ingredient that helps the query optimizer create its best guess for generating an execution plan. Keeping...

I’m in a book! Data Professionals at Work

A while back a friend of mine, Malathi Mahadevan (b/t), asked me if I’d like to do an interview for...

Three ways a virtual Database Administrator (vDBA) could be just what your business needs

How often have you felt like you need an extra pair of hands? When you’re planning a party? Maybe. When...

Whirlwind Tour of Azure SQL Database

I have finally uploaded my Azure SQL Database presentation, apologies for the delay. I am already working on an improved...