Implement explicit installation and uninstallation options for xp_cmdshell

Implement explicit installation and uninstallation options for xp_cmdshell Up-vote this Connect item if you would like to be able to control the availability of xp_cmdshell on your instances more than simply enabling or disabling it via sp_configure.

Tagged with: ,
Posted in Uncategorized

SQL Training

I had the pleasure of attending a 5 day SQL Server 2012 Internals and Query Tuning class led by Kalen Delaney the week before last. I had a head start going into the class because I had already read SQL

Tagged with: ,
Posted in Uncategorized

Article Published on SQL Server Central

My sixth article was published on SQLServerCentral.com yesterday: Loginless Database Users and Dynamic SQL

Posted in Uncategorized

Article Published on SQL Server Central

My fifth article was published on SQLServerCentral.com yesterday: Loginless In Seattle

Posted in Database Security, SQL Server

Iterate Over Databases Using SSIS – Part 2

In Part 1 of 2 I showed how to iterate over the databases in any given SQL Server Instance using SSIS. In Part 2 I’ll show how to extend the SSIS Package created in Part 1 to iterate over all

Tagged with: ,
Posted in SQL Server, SSIS

Iterate Over Databases Using SSIS – Part 1

In Part 1 of 2 I’ll show how to iterate over the databases in any given SQL Server Instance using SSIS. In Part 2 I’ll show how to extend the SSIS Package created in Part 1 to iterate over all

Tagged with: ,
Posted in SQL Server, SSIS

You gave them dbo?

Quite often I hear ┬ápeople say “I made them dbo” or “I gave them dbo” when announcing they granted someone full control of a database. It is quite rare in my experience that anyone would make a Server Login the

Tagged with: ,
Posted in Database Security, SQL Server
Follow

Get every new post delivered to your Inbox.