Category Archives: Uncategorized

Republish: Common Mistakes

Posted on June 22, 2018 by

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

Posted in Uncategorized | Leave a comment

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

T-SQL Tuesday #85–Cross Version Restores

Posted on December 13, 2016 by

It’s T-SQL Tuesday time, and this month Ken Fisher hosts. His topic is backups, and while I’m sure there will be plenty of views on backups, I wanted to touch base on a relatively simple item. This is the monthly … Continue reading →

Posted in Uncategorized | Tagged , , | 1 Comment

The Biggest Data Breech (For Now)

Posted on November 24, 2015 by

I keep reading the words “the largest data breach in history” in a variety of stories. In fact, given the tremendous growth of data acquisition, I’m guessing that this headline will continue to repeat itself over and over. I think … Continue reading →

Posted in Editorial, Uncategorized | Tagged