T-SQL Tuesday 108 Invitation- Non SQL Server Technologies

I am proud and honored to be hosting T-SQL Tuesday again. This monthly blog party started by SQL Guru Adam...

PASS Summit 2018 - Let's Hang Out! Where to Find Me

In addition to being an amazing opportunity for both technical and professional development, PASS Summit is a #sqlfamily reunion and a huge networking event. Catching up with old friends,...

A lack of foreign keys – a bad culture example.

G’day,
One of the things that I’ve been seeing more often than I would like to lately is large databases with...

Step-by-Step: How to Trigger an Email Alert from a Windows Event that Includes the Event Details using Windows Server 2016

Introduction
Setting up an email alert is as simple as creating a Windows Task that is triggered by an Event. You...

Here Comes the New Blog. Same as the Old Blog.

Welcome to the new home of my blog! I’ve had this domain for over a year but with PASS Summit 2018 coming up soon I decided it was time...

Overview of the SQL Insert statement

This article on the SQL Insert statement is part of a series on string manipulation functions, operators and techniques. The...

I have a broken leg

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...

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