The one thing all DBA must know is to backup database fully. I also answer reader questions on the best time for a backup and how often to take one.
SQLAuthority News – Author Visit – Database Architecture and Implementation Discussion – New York, New Jersey
I am traveling to New York and New Jersey for a Database Architecture and Implementation discussion, so replies to comments and emails will wait two days.
SQL SERVER – Two Different Ways to Comment Code – Explanation and Example
SQL Server has two different ways to comment code. Let us learn all of them here in this blog post. Various the options in the blog posts.
Orphaned Users After a Restore, and How to Fix Them
Find orphaned users after a SQL Server restore, compare user and login SIDs, and repair the intended mapping with ALTER USER.
SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – 15 Signs to Identify Bad DBA
A bit of SQL humor: 15 signs of a bad DBA, from reinstalling SQL Server when the sa password is lost to indexing every field to make it faster.
SQLAuthority News – SQL Blog SQLAuthority.com Comment by Mr. Ben Forta
Ben Forta, author of Sams Teach Yourself SQL Server T-SQL in 10 Minutes, wrote about SQLAuthority.com on his blog. Here is what he said and why it means a lot to me.
Explaining a Database to Non-Programmers (It Won’t Play Your Flash Movie)
Explaining a database to non-programmers is a real skill. Here’s my old flash movie story and the plain comparisons that work in any meeting.