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.
Which Sample Database to Use for Which Demo
Which sample database fits your lesson? Compare AdventureWorks, WideWorldImporters, and Stack Overflow data before choosing a demo.
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 – FIX : Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details
Error 945 means the database cannot be opened due to inaccessible files or low disk space. My four checks: disk space, autogrow, permissions and read only files.
MSSQL or MySQL? Clearing Up the Name Mix-Up
MSSQL or MySQL? The names are one letter apart and the products are not. Here’s who makes each, and the syntax differences that trip people up.
Why SQL Server Has Cumulative Updates, Not Service Packs
Understand why SQL Server uses Cumulative Updates instead of service packs, what each CU contains, and how to plan a reliable patch cycle.