Fix the SQL Server error Msg 4214 and Msg 3013, where BACKUP LOG fails because no current database backup exists. Here is why it happens.
SQL SERVER – 2005 – SSMS – View/Send Query Results to Text/Grid/Files
Three ways to send query results to text, grid or file in SSMS: the shortcuts CTRL+T, CTRL+D and CTRL+SHIFT+F, the toolbar, or the menu bar.
SQL SERVER – SPACE Function Example
Does SQL Server have a SPACE function? Yes. SELECT SPACE(100) returns 100 spaces, and a short example uses it to join last and first names.
SQL SERVER – Restore Database Without or With Backup – Everything About Restore and Backup
Everything about restore and backup readers ask: can you restore without a backup? No. Here is the right restore order and a plan to stay safe.
SQL SERVER – CASE Statement in ORDER BY Clause – ORDER BY using Variable
Stop building ORDER BY strings and running them with EXEC in a stored procedure. I show how a CASE statement in ORDER BY sorts by a variable without dynamic SQL.
CHECKSUM: A Matching Result Does Not Prove Text Identity
CHECKSUM matches do not establish unchanged text. Preserve complete values and compare hyphen and trailing-space differences explicitly.
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.