SQL Server Encryption keeps stolen data unreadable. Learn the three level encryption hierarchy, then follow a symmetric key encryption tutorial with the script.
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.
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.
Giving an Application Account Only What It Needs
Apply least privilege SQL Server access with separate runtime and deployment roles, narrow permissions, and tests of allowed and denied actions.
SQL SERVER – Fix : SQL Server 2008 Developer Edition Install fail due to .NET Framework 3.5 missing
SQL Server 2008 Developer Edition setup failed with .NET Framework 3.5 missing, even though Visual Studio 2008 ran fine. Here is the link that explained why.
What Is the Transaction Log and Why Does It Keep Growing?
The transaction log records every change before it reaches the data file. Why it grows, what log_reuse_wait_desc is telling you, how the recovery model decides everything, and the one fair reason to shrink it.
FOR XML PATH: Choose Attributes and Nested Elements With Aliases
FOR XML PATH interprets column aliases as directions for the output’s attributes and element hierarchy. I use three aliases to shape two rows. The source columns stay ordinary relational values.