So I was studying for the 70-451 and ended up reading the BOL entry for CREATE SCHEMA. I honestly can’t...  Read more...

If you can establish a connection to a SQL Server, but are having problems logging in to it, you will...  Read more...

There was an interesting conversation on Twitter today about security awareness and why the training so often fails. From my perspective, here's...  Read more...

This is an uncommon task but one that does turn up every once in awhile. A SQL login has to...  Read more...

I was scanning http://dba.stackexchange.com and ran across the following question: http://dba.stackexchange.com/questions/31478/sql-server-script-to-delete-accounts-no-longer-in-active-directory Basically the OP wanted to know how to get rid of...  Read more...

I’ve never felt the need to allow this, but I saw someone ask the questions recently. Suppose you had a...  Read more...

One of the tenets of good security is that no person or process is granted more rights than it needs...  Read more...

I saw a note this week from CNet about a system built to crack passwords (also on ArsTechnica). It reminded...  Read more...

Logins are not Users. It’s a pretty easy concept but one that seems to give a lot of people problems....  Read more...

Today is black Tuesday for October 2012. One security bulletin is specifically for a component of the SQL Server stack:...  Read more...

More stuff you may find interesting. Prepare for your first security breach. Sobering. As data professionals we’re going to get pulled...  Read more...

One of the security recommendation inside SQL Server Security Best Practice white paper for guest user is that, to disable...  Read more...

It's been a while since I was in the day-to-day business of security patches. However, I still keep up with...  Read more...

I was called over today by a person doing application support to help troubleshoot a database connectivity issue. This isn't a...  Read more...

In a blog post F-Secure's Chief Research Officer, Mikko Hypponen (blog | twitter), indicated that with the US participating in cyberattacks...  Read more...

I hate running antivirus on SQL Servers. I agree antivirus is a necessary evil on most systems, but I don't...  Read more...

Here’s a quick query that you can run to find out the users with sysadmin fixed server role. Sysadmins have a...  Read more...

Gone are the days when remote drives were easy to detect because there was some size to them. Nowadays USB...  Read more...

Slammer By now you must have heard of the SQL Slammer worm.  It was quite an infectious little nuisance.  The harm...  Read more...

Having flown a fair amount lately, I was thinking about the various levels of security within an airport.  Part of...  Read more...