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

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

SQL Server – Modifying Production Data Good Practise

Q. “I need to modify Production Data directly on a Production database. What are some steps I can follow to...

Database uplevel Restores Follow On

Today's post is a follow on from one earlier this month Database uplevel Restores.  I got round to testing restoring...

DBAs and the Career-Life Balance

Reprinted from my editorial in Database Weekly.
I know a lot of DBAs who make SQL Server the focus of their...