New Article: How to audit sysadmin members on multiple servers using PowerShell

My first article of 2012 has published over at MSSQLTips.com. This one covers the basic technique for using PowerShell to audit...

Notes from the January 2012 oPASS Meeting

It’s been quite a while – where did the time go? – since I had done a presentation for oPASS, so when...

Revamping SUG 2nd Meeting

Friends,
Last Saturday, 21st we have 2nd meeting of SUG members and this time we made progress – I, Vinay and Matang...

S3OLV February 2012

Do you recognize this person?   If you are from the Colorado Springs area, you probably do.  This is:       Troy Ketsdever (twitter) Troy will be presenting...

S3OLV February 2012

Do you recognize this person?

 
If you are from the Colorado Springs area, you probably do.  This is:
 
 
 

Troy Ketsdever (twitter)
Troy will...

Security - SQL vs Windows

Security is a very important part of every DBA’s role.   If you are not clued up on security best practices...

Sorting a String as a Number with T-SQL and SSIS

I was working on a Cube in Analysis Services for a client recently and needed to sort on a field...

Want to recruit me? Please follow these rules

I get 15-30 calls/emails a week from recruiters (not counting the dozens of auto-generated emails I get).  Being a contractor...

SQL Server - BACKUP LOG WITH NO_LOG

The BACKUP LOG WITH NO_LOG and WITH TRUNCATE_ONLY options are discontinued in SQL Server 2008.
There is no replacement for this...

SQL Server- Output clause

Output Clause:- The SQL SERVER 2005 gives us an Output Clause which gives us the information about each row affected by the...