Truncating the Log and Database Mirroring
I saw someone post recently that they wanted to run this code on their principal server in database mirroring to...
2010-06-30
2,129 reads
MS Access Annoyance: Doesn’t Link Synonyms
I use Access when I don’t have dedicated admin tools for editing data, frequently the case for infrequently changed data...
2010-06-30
3,147 reads
Does Your Company Have a SQL Server DR Plan?
This past month I ran a poll asking this question: “Does your company have a formal, tested, disaster recovery plan...
2010-06-30
1,554 reads
The Trade Deadline Must be Drawing Near
The Trade Deadline Must be Drawing Near
Okay, so there is no trade deadline in SQL Server like there is in...
2010-06-29
2,139 reads
Does a missing data file send a database suspect?
Short answer: No
I keep seeing this come up on various forums when people ask what makes a database go suspect...
2010-06-29
2,039 reads
Partition Alignment and Late Night Infomericals
Late night infomercials make some amazing claims. “If you order now you too can cut through a cinderblock wall and...
2010-06-29
1,509 reads
‘Tis the Season for SQL Leaving
With the announcement of Brent Ozar (Blog | Twitter ) leaving Quest for SQL Skills, Exceptional DBA finalist Jorge Segarra (blog | twitter)...
2010-06-29
1,609 reads
SQL Saturday #28 (Baton Rouge) – All about User Groups
This year at SQL Saturday #28 we will be featuring a User Group Booth alongside the Sponsor booths. The User Group...
2010-06-29
1,567 reads
The Breakfast Plan Goes Awry
Here’s the editorial for SSC today and while it’s a humorous story about asking for donuts and getting a free...
2010-06-29
1,426 reads
Conference Calls Are Hard
Conference calls are a fact of life for most of us. Remote offices, remote workers, clients – lots of reasons to...
2010-06-29
1,428 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Escaping Strings
Comments posted to this topic are about the item Escaping Strings
Imagine the Physical World
Comments posted to this topic are about the item Imagine the Physical World
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers