Whitepaper Wednesday - Introducing Microsoft StreamInsight
Hey folks,
It's whitepaper Wednesday again and this week we're talking about "Introducing Microsoft StreamInsight" by: Torsten Grabs, Roman Schindlauer, Ramkumar...
2010-09-06
856 reads
An impossible case
In a previous blog entry (Inconsistent NullIf behaviour), Jeff Moden and Dan Halliday(twitter) both made a very similar observation.
When executing...
2010-09-06
552 reads
Idera SQL Tools – An evaluation (Part 2)
This is the 2nd in the series of evaluations I have carried out on Idera’s SQL Server Toolbox. The first...
2010-09-06
1,327 reads
SQL Saturday #48 - Columbia, SC Schedule Posted
The sessions have been selected and we have posted the schedule for SQL Saturday #48 - Columbia, SC. A huge thank...
2010-09-06
625 reads
Parallelism in SSIS - Multiple Lookups
This question just came up in the forums, and it highlights how difficult it can be to try to optimize...
2010-09-06
2,160 reads
Thoughts about the PASS BoD Nomination Process
I know I was one of the more vocal ones these past two years when the set of nominees were...
2010-09-06
881 reads
Renaming a column in Sql Server
We often need to change the name of a column of a table to a new name. We can do...
2010-09-06
724 reads
Labor Day Bloopers
Happy Labor day to everyone. A day off for me, but I’m posting a few bloopers from the past couple...
2010-09-06
1,102 reads
In the Interest of Disclosure
Yesterday I attended an internal training course on social networking. The class was targeted toward the 100 level, but like...
2010-09-03
426 reads
Re-learning how to think
Cross-posted from The Goal Keeping DBA:
Re-learning how to think is always a difficult process. My oldest son is starting the...
2010-09-03
1,497 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