Category Archives: Uncategorized

Database Mirroring Needs FQDNs

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

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?

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

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

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)

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

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

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

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

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 ,