Cloud Security

In case you hadn’t noticed I’ve recently started looking at the cloud and what it entails. Well one of those...

Temper, Temper

Possibly the single most influential event in my career happened over 25 years ago. I lost my temper at a...

Write-Only permissions

Yep, that’s right, you heard me. Write-Only not Read-Only. I was presenting SQL Server Security Basics at NTSSUG the other...

Azure: What’s the difference between SQL Database and SQL Server?

If you want to blog T-SQL Tuesday is a great way to get started. On the first Tuesday of each...

Lots of inserts? Part II

Using impersonation to allow a task without granting the required permission.

I use impersonation on a regular basis for a number of different tasks. This one is pretty basic but can...

What’s the difference between LEFT and RIGHT OUTER JOINs?

A DBA walked into a bar, saw a couple of tables, and asked “Can I JOIN you?”
There are several different...

When was this database restored?

I frequently need to know where backups went and I restore those backups for operational recovery on a regular basis....

Lots of inserts? Part I

Blogger Questions: What should I blog about?

Over the last four years I’ve blogged almost 400 times. It’s become a refuge, a resource, a source of pride,...