Powershell Fundamentals
I’ve had the opportunity this week to take class with Don Jones (blog | twitter), PowerShell guru and author of PowerShell...
2010-06-25
2,107 reads
How much memory is each SQL Server database using?
Whilst perusing the forums over at SQL Server Central today I stumbled across an interesting question regarding how to identify...
2010-06-25
570 reads
What Has Jack Been Up to?
It has been awhile since my last post mainly because I was on a working vacation in northern New England...
2010-06-25
459 reads
Lock Pages in Memory
It is generally recommended that 'lock pages in memory' be enabled for your SQL Servers to prevent the OS paging...
2010-06-25
9,655 reads
Speaking and Presenting Tips - Bullets
I’ve heard this before, it came up in the Tufte seminar I took, and it also was something that grated...
2010-06-25
1,104 reads
The Exceptional DBA of 2010
I’ve been a judge in this contest for the last 3 years, and each years we’ve had really good finalists,...
2010-06-25
822 reads
Growing the SQL Community – Carefully
If you’re a blogger or a twitterer or a SQL speaker or PASS volunteer, you do it because you have...
2010-06-25
560 reads
My SELECT statement has hung!
One of the first roadblocks many developers run into when using SQL Server for the first time is firing off...
2010-06-24
2,610 reads
PowerShell Script to Remove Old Backups
A Twitter user asked for a script to remove old backups, and I had one I built back in February,...
2010-06-24
1,129 reads
MDX webinar
Today I did a webinar on MDX solutions. For those of you interested you can grab the slides here and...
2010-06-24
1,213 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