SSIS 2012 - Catalog Encryption

Updated Thoughts on Antivirus on SQL Servers

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

Who are the sysadmins in this sql server?

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

Grant Execute to all SQL Server Stored Procedures

With SQL Server 2000 no default server, database or application role was available to be able to execute all stored procedures. With SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2 has this changed with all of the new security features? If not, what options do I have to grant execute rights to the needed database roles?

Certificates Everywhere

Today Steve Jones talks about security and his desire to have certificates be the primary means of securing communications and verifying authenticity.

Remove Logins Script

Generates a script to remove logins from a SQL Instance. Handles cases where logins own schemas.

SQL Server Agent Roles

CREATE ROLE

How to Secure your SQL Azure Application

Developers targeting the SQL Azure platform should make sure their applications are secure. This article walks through the considerations developers need to keep in mind when designing SQL Azure applications.

Three Attack Vectors in SQL Server 2005

This article outlines three different tried and tested methods of obtaining access to databases in SQL Server 2005 where no database-level administrative access exists.