Last Weeks Top “Reading” Links #40
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-07-08
1,184 reads
Blog Posts
My 1st Blog – out of memory exceptions in SSDT… yes its technical
When unit testing a stored procedure in visual studio 2012 (SSDT); sometimes you can get a out of memory exception...
2013-07-08
977 reads
My 1st Blog – out of memory exceptions in SSDT… yes its technical
When unit testing a stored procedure in visual studio 2012 (SSDT); sometimes you can get a out of memory exception...
2013-07-08
442 reads
Run real-time SQL tracing at application level with a ORM….
If you ever need to know exactly what dml your application is running as you have an ORM as your...
2013-07-08
461 reads
Run real-time SQL tracing at application level with a ORM….
If you ever need to know exactly what dml your application is running as you have an ORM as your...
2013-07-08
473 reads
SQL Server: Part 5 : All About SQL Server Statistics : How to Detect outdated Statistics ?
In the last post, we have discussed about the auto update statistics threshold and concluded that auto updated statistics threshold are good...
2013-07-08
1,636 reads
Unlocking “Lock Pages in Memory” Option
Consider this scenario; Your production database server is new and with super configuration of 32 CPUs, 64G RAM, SAN Storage,...
2013-07-08
346 reads
Ready, Set, Go! Upcoming Speaking Events
Huge sandwich from recent trip to downtown Chicago
First, I want to acknowledge that I’ve been pretty quiet on here lately....
2013-07-07
735 reads
So how was your weekend?
It’s Sunday night now, weekend is almost over and was it just a few moments ago that it was Friday?...
2013-07-07
328 reads
SQL Server Quickie #6 – THREADPOOL Starvation
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Today I have...
2013-07-07
1,552 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