Category Archives: Uncategorized

The Trigger Roundup–T-SQL Tuesday #106

Posted on September 18, 2018 by

This month was my turn to host T-SQL Tuesday. I chose Trigger Headaches or Happiness as the topic, and I am glad that there have been quite a few responses. I started the review almost immediately,and here are a few … Continue reading →

Posted in Uncategorized | Tagged , | 1 Comment

Republish: Managerial Moneyball

Posted on July 26, 2018 by

Still on vacation, hopefully hiking. Republishing Managerial Moneyball.

Posted in Uncategorized | Tagged | Leave a comment

Republish: Common Mistakes

Posted on June 22, 2018 by

Back across the pond, so a re-run of Common Mistakes.

Posted in Uncategorized

Predictions for the Future

Posted on March 6, 2018 by

There is no shortage of predictions that we all make every day. Long before PREDICT and the popularity of Machine Learning/R/Python and more, each and every one of us has regularly made guesses about what will happen in our world. Some of … Continue reading →

Posted in Uncategorized | Tagged

Table Internal Sync Rule–Substituting the Sync Column

Posted on March 6, 2018 by

I’ve been playing with Data Masker for SQL Server v6 and it’s an interesting product. I like the way it works, but I do find it a little challenging sometimes to figure out how to mask values. I’ve written a … Continue reading →

Posted in Uncategorized | Tagged , ,

We Have a Date

Posted on September 28, 2017 by

For nearly half of my life, I’ve looked forward to new versions of SQL Server. At first I was just hoping to see SQL Server run on a stable OS, as the OS/2 1v.3 was my original installation. That system … Continue reading →

Posted in Uncategorized | Tagged

Database Mirroring Needs FQDNs

Posted on July 3, 2017 by

A quick basic post, and one that I’ve forgotten. Since blogging is a good way to remind myself of things, here goes. I was testing Database Mirroring (DBM) recently for an upgrade situation. I’ve set up it up in the … Continue reading →

Posted in Uncategorized | Tagged , , ,

A Bad First Day

Posted on June 14, 2017 by

I’ve started quite a few jobs throughout my career. In college, I worked in a variety of restaurants, changing employers at the start of every summer and again at the start of the school year. At some of those positions, … Continue reading →

Posted in Uncategorized | Tagged

How Can I Get Accepted to Speak at the PASS Summit?

Posted on May 1, 2017 by

There has been some discussion and concern over the changes to the speaker selection process for the PASS Summit. I’ve written some thoughts, as have others (Joey, Andy), but I was struck a bit by Eugene Meidiner’s post. In it, … Continue reading →

Posted in Uncategorized | Tagged , , | 2 Comments

Getting the tSQLt Run Adapter working in Visual Studio 2017

Posted on March 13, 2017 by

Last year I heard about the tSQLt test Adapter for Visual Studio from Ed Elliot. I’ve been wanting to try it, but various items got in the way. Finally I had the chance to play and it worked well in … Continue reading →

Posted in Uncategorized | Tagged , | 2 Comments