Category Archives: Uncategorized

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 , , , | Leave a comment

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

Cloud Security Issues

Posted on August 4, 2015 by

Bruce Schneier wrote a three part series (part 1, part 2, part 3) on cloud computing recently, part of a debate at the Economist. It’s a general look at the cloud from a few perspectives, and I think the thoughts are interesting. Whether … Continue reading →

Posted in Uncategorized

Normalizing Performance

Posted on November 2, 2014 by

This week I ran across a post from Glenn Berry on hardware performance that I thought framed the concept of performance value well. In the post, Glenn talks about the latest TPC-E benchmark and the SQL Server performance values that … Continue reading →

Posted in Uncategorized | Tagged , ,

Better Presentations–Hide those Windows

Posted on August 26, 2014 by

This is part of a series of tips for speakers to make your presentations better. I wanted to give some specific SQL Server presentation items that have bothered me recently. These aren’t big things, but they do cause problems for attendees, … Continue reading →

Posted in Blog, Uncategorized | Tagged , | 8 Comments

Fixing CREATE TABLE

Posted on February 27, 2014 by

I’ve always wondered about this. When I create a stored procedure I do this: CREATE PROCEDURE MyProc @param1 int as BEGIN   — add code here END; As is often the case, I realize that I’ve made some mistake and need … Continue reading →

Posted in Uncategorized | Tagged ,