Pepper, a SharePoint consultant, asked why her database is in restoring mode after taking a backup. Here is the story and the answer.
SQL SERVER – How to Flip Value of Bit Field in SQL Server? – Part 2
Five expressions flip a bit value in SQL Server without a CASE statement. This post runs Vinod Kumar’s four methods and the readers’ answers on SQL Server 2025, shows what each one returns for 0, 1 and NULL, and explains how to flip value of bit field data stored in an integer column.
SQL SERVER – How to Flip Value of Bit Field in SQL Server?
How do you flip bit field values from 0 to 1 and back? My favorite method is the ~ operator. Here is a short script that shows it.
Find Rows With Single Quotes in SQL Server: SQL in Sixty Seconds #075
To find rows with single quotes, write the quote twice inside the search string. This post tests four search patterns on one million rows on SQL Server 2025, shows which two are the same query and which one costs more, and covers the curly quote that a straight quote search misses.
SQL SERVER – Search Records with Single Quotes – Part 2
Readers sent more ways to find records with single quotes: CHAR(39), CHARINDEX and REPLACE. Here are their suggestions, and all of them perform well.
SQL SERVER – Search Records with Single Quotes
A reader asked how to search records with single quotes in a table column. A simple LIKE query with doubled quotes finds them.
SQL SERVER – Beginning Reading Transaction Log File
What is the SQL Server transaction log, why do we need it and how does it work? A beginner’s first step toward reading transaction log file content.