How do you secure the SQL Server instance after enabling xp_cmdshell ?

OR
How do you allow non-administrator to use xp_cmdshell ?

From the day I started working with SQL server, I have heard
about...

SQL Server Crossword #4

To mark my 31st Birthday today(gifts are of course most welcome) here’s a SQL Server Crossword for you to enjoy. You...

Microsoft DreamSpark Program

Back in 2008, Microsoft rolled out the DreamSpark program as a means to get Microsoft software design and development tools...

SQL Tribal Knowledge needs editors!

A while back I invited the unpublished masses to submit abstracts for a new-author-written SQL book – called Tribal SQL – and the...

SQL Server 2012 AlwaysOn Availability Groups – Part 1

In the last weeks and months I have prepared tons of SQL Server 2012 content for my
own SQL Server 2012...

SQL Server Database Mirroring Tips and Tricks, Part 2

If you ever find yourself having to setup database mirroring between different, untrusted Windows Domains, one of the most common...

SQL Lunch - SQL Reporting Services

Tomorrow at 11:30 CST Pam Shaw will be talking SQL Reporting Services (SSRS).  If you have time, join us for...

SQL Lunch–SQL Reporting Services

Tomorrow at 11:30 CST Pam Shaw will be talking SQL Reporting Services (SSRS).  If you have time, join us for...

Fast Track for SQL Server 2012

When the Fast Track Data Warehouse 3.0 Reference Guide was published, it was based off of SQL Server 2008 R2....

SQL Server 2012 Special Ops Tour - NYC

Tomorrow, Thursday, March 22, 2012, the official Microsoft SQL Server 2012 Special Ops Tour continues its 12-city trek around  the...