MockingJay – a review
After a long wait, I have finally read the final installment in the “Hunger Games” trilogy. I read the other two books earlier in the year in 2010 and...
2011-01-04
9 reads
MockingJay – a review
After a long wait, I have finally read the final installment in the “Hunger Games” trilogy. I read the other...
2011-01-04
582 reads
MCM Prep – Sliding the test
If you can’t cram enough for the test, what’s the thing to do? Slide the test. I realized last night...
2011-01-04
650 reads
Microsoft DreamSpark for Students
If you are a college or high school student, you can get a very valuable assortment of free software from...
2011-01-04
1,315 reads
Finding last database growth date and time
A file growth operation on a database server is a extremely expensive operation. Many Performance problems correlate to a Data...
2011-01-04
492 reads
Which Process ID is SQL Server running on?
There was an interesting question posted on a forum recently, asking how can you tell which sqlservr.exe process (shown in...
2011-01-04
5,988 reads
Filling in Data Potholes Redux: Tally Tables vs CTEs
In A Previous Installment
Re-Ducks
… our heroine (that’s me) rediscovered CTEs, specifically in the recursive style. That was in my post...
2011-01-04
1,119 reads
Capturing the Execution Plan
One last post on execution plans and Profiler (at least for now)
When trying to check a query’s execution plan, the...
2011-01-04
1,396 reads
PASS SQLRally Update–Voting Pushed Back
In our original plan for PASS SQLRally we had set this week as the week to start voting for sessions. ...
2011-01-04
374 reads
XQuery for the Non-Expert – Binary Values
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In the...
2011-01-04
705 reads
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
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