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.
SET_BIT: Return a Changed Value Without Updating Data
SET_BIT returns a value with one bit set or cleared. Compare the default one with explicit zero, and keep scalar calculation separate from updates.