Build Dynamic Backup Locations with Minion Backup
See how Minionware Backup gives you the ability to customize backup files and locations.
2017-05-03
266 reads
Sean McCown
- Interests: Kenpo, French cooking, computers, chess.
Get Away From Confusing Code
Most time we probably think that lots of our code is confusing, but when working with data values that need or contain quotes, it can get especially confusing. Sean McCown looks at a method for making this code easier to read.
2005-11-15
8,799 reads
How To Mess Up An Interview
We started a trend with our Worst Practices, looking at things you should not do instead of those you should. Sean McCown has taken that to a new level looking at some things that you can do to ensure you don't get your next job. Read about a few things that you might avoid in your next interview.
2005-10-17
20,644 reads
Interviews Part 2
In a followup to the recent articles and discussions on interviewing and DBA skills, Sean McCown brings us a new article that looks at one situation that resulted in a rejection. Learn what you might want to work on before your next interview.
2005-09-19
12,119 reads
Calling All Editing Buffs
Author Sean McCown would like to see some improvements in the editing tools that are available. He's proposed some changes and ideas to make a better tool. Join the discussion and see if you can get the SQL Server vendors to build something to make every DBA's job easier.
2005-09-02
4,136 reads
How do you spell S-Q-L?
We've spent quite some time investigating career issues for SQL Server DBAs lately. I've received quite a few emails from friends on their adventures in interviewing and now Sean McCown shares an experience he had interviewing a few prospective DBAs.
2005-08-18
14,717 reads
Disappearing DBAs
In response to an article the Brian Knight write on the death of the production DBA, Sean McCown writes about the role that DBAs may play in shops that upgrade to Yukon (SQL Server 2005).
2005-06-02
9,729 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers