The SSIS Data Flow is Like... an Automotive Assembly Line
When I describe (or rather, attempt to describe) technical subjects to people that aren't familiar with them, I tend to...
2010-05-27
470 reads
Follow Up On My Keynote Survey
Here are the results of the survey, 75% in favor of a non-technical keynote, with a less than stellar sampling...
2010-05-27
623 reads
Becoming a Part of the SQL Server Twitter Community
There have been tens of thousands of blog posts and articles written about Twitter, and because of this, I have...
2010-05-27
752 reads
IndyTechFest 2010 a Big Hit
Jesse Liberty,a Developer Community Program Manager for Microsoft, starts off IndyTechFest 2010 with the keynote presentation.
On Saturday, May 22, 2010,...
2010-05-27
473 reads
North Texas SQL Server User Group Offers Innovative Educational Series
On Thursday, May 20, 2010, I had the opportunity to speak at the North Texas SQL Server Users Group, which...
2010-05-27
483 reads
Kalen Delaney Speaking In Denver on June 9, 2010
Well-known SQL Server MVP and author Kalen Delaney (blog) will be speaking about SQL Server Plan Cache and Recompilation on...
2010-05-26
948 reads
Connecting to DB2 using SSIS
To start, first download and install the Microsoft OLE DB Provider for DB2. Click here to download. After it is...
2010-05-26
21,864 reads
Reporting Services – Building the first report
One of my goals this year was to spend some time learning Reporting Services. Not necessarily do the 10,000 hours...
2010-05-26
2,123 reads
SQL Saturday #35 Notes and Observations
First of all, I want to congratulate all the volunteers that made this happen. It was a very well organized...
2010-05-25
1,176 reads
The Power of Regex in PowerShell
PowerShell is probably banned in MLB as a performance enhancing substance. You won’t find red-blooded American baseball player admitting to...
2010-05-25
719 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