Jump on the SQLExpress – Useful info, ways to schedule and run maintenance jobs
Jump on the SQLExpress – Useful info, ways to schedule and run maintenance jobs
Sometimes, folks come to me, and ask for...
2011-03-04
5,052 reads
Blog Posts
March PASSMN Meeting Announced
Come one, come all to the March PASSMN meeting – that’s the Minnesota SQL Server User Group. This month we’re going...
2011-03-04
661 reads
Oh Yes It’s Ladies Ni…errr…Month
Making WIT awesome since 1993
It’s March and this month sees a lot of celebration, amongst the parties are Mardi Gras...
2011-03-04
444 reads
Presenting in West Palm Beach on March 22, 2011
I’m pleased to be joining the West Palm Beach .Net group on March 22 to do a presentation on SQL...
2011-03-04
892 reads
Resource database
Today learned new thing about Resource database, as everybody knows resource database is the system database introduced in sql server...
2011-03-04
1,048 reads
The Power And Pain of Process–Part 1
Part of why I love IT is finding patterns and creating new ones. Patterns by themselves are interesting, but when...
2011-03-04
1,154 reads
Women in Technology PPT Template
Well hey-howdy-hey (as we don’t say in Texas), it’s Women’s History Month! And by all accounts, it’s going to be a...
2011-03-04
1,031 reads
Differences between Merge and Union All transformations in SSIS
What are the differences between Merge and Union All transformations in SSIS ?
The first and most obvious difference is that Merge...
2011-03-03
1,589 reads
Re-purpose my TableSize Script
Last Year I introduced a couple of scripts that I worked on. Those scripts developed into a series covering the comparison of some methods and MS provided stored procs...
2011-03-03
17 reads
Re-purpose my TableSize Script
Last Year I introduced a couple of scripts that I worked on. Those scripts developed into a series covering the...
2011-03-03
463 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