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...

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...

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...

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...

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...

The Kind of DBA I Want to Be

The Kind of DBA I Want to Be
Rokusaburo Michiba (Iron Chef Japanese)

I was a big fan of the original Iron...

SQL server the timeout period elapsed prior to completion of the operation

AdvertisementsSQL server clustering the timeout period elapsed prior to completion of the operation
Recently I faced one of our application could...

How to set the default replication agent profile

Over the last couple of years I've come to the conclusion that the default replication agent profiles just don't cut...