SQL Saturday Advice - PhotoJournalism
I try to carry a camera, and a video camera, most of the time when I’m traveling. I have a...
2010-09-02
372 reads
Getting Drive Info Part 3, CLR
In the first two parts, (Part 1, Part 2), of the Getting Drive Info series the techniques to gather drive info with methods that will work on SQL Server...
2010-09-02
17 reads
Getting Drive Info Part 3, CLR
In the first two parts, (Part 1, Part 2), of the Getting Drive Info series the techniques to gather drive...
2010-09-02
1,556 reads
For SQL Server 2005/2008, Consider SecurityAdmin = SysAdmin
Note: Republishing because the article covering the issue and a workaround has been published here on SSC.
In a recent thread...
2010-09-01
4,312 reads
As a PASS Member, Don’t Forget to Vote in the 2010 PASS Board Elections
I just received my e-mail from PASS, which says, “As a PASS Member in Good Standing, you are entitled to...
2010-09-01
592 reads
Retrieving Report Names for SSRS Subscription Jobs
The way Reporting Services creates subscriptions is through generating a SQL Server Agent job. This is apparent when you look...
2010-09-01
796 reads
Naming Keys & Constraints
G'day,
This is pretty much my first blog post - at least on sqlservercentral.com - so to get started I thought that I'd...
2010-09-01
450 reads
A Stored Procedure to Move SSIS Packages Between Servers
This post provides the code for a stored procedure to move SSIS packages between SQL 2005 SSIS servers. Continue reading ?
The post A Stored Procedure to Move SSIS Packages...
2010-09-01
4 reads
A Stored Procedure to Move SSIS Packages Between Servers
This post provides the code for a stored procedure to move SSIS packages between SQL 2005 SSIS servers. Continue reading ?
2010-09-01
25 reads
A Stored Procedure to Move SSIS Packages Between Servers
Today’s post is one that I have been debating on whether to publish for a while. The purpose of the...
2010-09-01
986 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
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
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
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