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,099 reads
Blog Posts
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
713 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
906 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
527 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,051 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,233 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
680 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
351 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
306 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
430 reads
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Forums
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Spring Connections and Learning at PASS On Tour
Comments posted to this topic are about the item Spring Connections and Learning at...
Multiple Sequence Values
Comments posted to this topic are about the item Multiple Sequence Values
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers