Looking for a job or a candidate? Here are my links to SQL Server interview questions and answers, SQL Server related jobs and a DBA job description.
Least Privilege for Application Logins
Design least privilege for SQL Server application logins with roles, schema permissions, and stored procedures, then test real workflows.
SQLAuthority News – SQL SERVER Database Administrator Job Description
An updated SQL Server Database Administrator Job Description: support for the database environment, new technology, reliability and long-term planning.
Untested Backup: The Joke That Ends With a Resignation Letter
An untested backup is the darkest joke in the DBA world. Here’s how the story usually ends, and the simple restore drill that keeps you out of it.
SQL Server – Good Articles on Database Collation
Database Collation defines default character comparison rules for a database. I also inspect the columns and expressions involved.
SQLAuthority News – 500th Post – An Interesting Journey with SQL Server
I am very pleased to write my 500th post on SQLAuthority. Thank you to my family and to all of you, plus a look at the blog’s milestones so far.
Planning a Move Off an Old SQL Server Version
Plan a move off an old SQL Server version with a complete inventory, compatibility testing, a supported target, and a dated exit plan.