SQL Server Encryption keeps stolen data unreadable. Learn the three level encryption hierarchy, then follow a symmetric key encryption tutorial with the script.
SQL SERVER – List All the Tables for All Databases Using System Tables
A one line script with sp_msforeachdb and sys.tables to list all the tables for all databases on a server, updated with ideas from reader comments.
SQL SERVER – Leading Zero to Number
Readers keep asking how to add a leading zero to a number. Here are my two earlier articles that pad a number with zeros for a fixed width display.
LAG IGNORE NULLS: Read the Previous Available Value
LAG IGNORE NULLS reads the previous non-NULL value within an ordered partition. These examples distinguish skipped rows, missing previous values and the supplied default.
Decimal Division: Inspect Precision Before the Final Cast
Decimal division derives its own precision and scale before your final cast. Compare wide and bounded inputs, then test rounding and valid numeric ranges.
SQL SERVER – FIX : Error: 18486 Login failed for user ‘sa’ because the account is currently locked out. The system administrator can unlock it. – Unlock SA Login
Error 18486 means the sa account is locked out, often after brute force attempts by hackers. Here is why it happens and how to unlock SA login.
SPACE: Keep Blank Text, Empty Text and NULL Distinct
SPACE builds a present blank string from a count. Keep empty text and NULL separate, and choose a measurement that retains supplied spaces.