Free Webinar: Turn Your Backups Into Live Databases with SQL Virtual Restore
Steve Jones, SQL Server MVP and editor of SQLServerCentral.com, will be hosting a free webinar with Jeff Aven, the head...
2010-09-09
715 reads
More On Overlapping Statistics
In my last post I provided a script to identify overlapping statistics but realized afterwards that I left out a...
2010-09-09
912 reads
Voting Theory
I was enjoyed the Sunday newspaper (on Sunday!) and ran across this column about various voting systems and that made...
2010-09-09
431 reads
Connection String Settings: Timeouts and Pooling
If you are having SQL Server Database connection issues, I reckon they could be due to one of two connection...
2010-09-09
26,617 reads
PASS SQLRally – Session/Speaker Selection
Hopefully by now you’ve heard about the PASS SQLRally event that will be held in Orlando, May 11-13. Andy Warren,...
2010-09-09
530 reads
Retiree Association Firmly Onboard with My Repetitive Criticism of Quebec’s Deposit and Investment Fund: Mille fois Bravo l’AQRP ! :)
Just a bit of follow up here, to start closing the loop, regarding my multiple written outbursts regarding the institutionalised...
2010-09-09
2,054 reads
The Perfect SQL Server DBA / Developer Role
Whilst enjoying my coffee fix this morning, along with today’s SQL Server Central Email, my attention was caught by Steve...
2010-09-09
358 reads
SQL Server - Dedicated Administrator Connection (DAC)
This a short post looking at the Dedicated Administrator Connection or DAC for short. In extreme circumstances, when there is...
2010-09-09
8,237 reads
SQLRally Meeting Minutes
The starting point for a good meeting is an agenda and minutes. It took us a bit to catch up,...
2010-09-09
681 reads
T-SQL - Is Saving Space Worth It?
I ran across this blog post on Joe Celko’s Restaurant Seat Assignment Problem that found a way to implement the...
2010-09-09
308 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
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
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...
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