A Tale of Two Utility Companies
I live in Parker, Colorado, which is a suburb of Denver, about 25 miles southeast of downtown Denver. I have...
2009-10-05
606 reads
Blog Posts
Ad Hoc Queries Don’t Reuse Execution Plans: Myth or Fact
Another frequently heard story is that stored procedures get and reuse execution plans, but ad hoc queries do not. A...
2009-10-05
3,199 reads
DRP for SQL Server in French - traduction en français du plan de relève – part 3
Here is Part 3 of the translation for the French version of the Disaster Recovery for SQL Server Databases - comments...
2009-10-05
1,047 reads
How to Diagnose and Correct a “Runaway” Transaction Log
This shows you how to diagnose and correct a "runaway" transaction log. This is a very common issue that I...
2009-10-05
8,554 reads
My Journey - Part I
I've actually been meaning to write about my journey as a SQL Server professional, but kept putting it off. I...
2009-10-05
1,108 reads
My Top 10 SQL Saturday Tips
Top 10 SQL Saturday Coordination Tips
1. First and probably the most important thing is to assemble a very responsible and...
2009-10-05
1,338 reads
NY/NJ SQL Saturday Event Details - October 24, 2009
NJSQL/NYCSQL Saturday Event on October, 24th (Registration Required)
Here are the details, of my previously announced SQL Saturday event hosted by...
2009-10-05
1,263 reads
Spaces in Object Names Revisited
I think in general the SQL Server DBA’s of the world prefer that object names not have spaces embedded, and...
2009-10-05
810 reads
Speaking Engagements This Week
I'll be doing three talks this week, starting tomorrow (Tuesday).
Tuesday, October 6th, Midlands PASS Chapter - Trigger Happy Database Security(PASS Summit...
2009-10-05
980 reads
SQL Lunch Starting at 11:30 AM CST 10/5/2009
TOPIC: SQL Lunch - Memory Management in SQL Server Analysis Services
If you haven’t already, go out and register for today’s SQL...
2009-10-05
728 reads
Blogs
SQL Saturday Boston Slides and Code
By Steve Jones
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve...
Scaling SQL Server 2025 Vector Search with Load-Balanced Ollama Embeddings
SQL Server 2025 introduces native support for vector data types and external AI models....
Advice I Like: Fear and Imagination
By Steve Jones
Fear is fueled by a lack of imagination. The antidote to fear is not...
Forums
how to use a variable in a CASE statement?
hi everyone I am getting an error when I add a variable to a...
How to Use SQL Server Features to Cut Web App Latency in Half
Comments posted to this topic are about the item How to Use SQL Server...
Choosing an AI in Sept 2025
Comments posted to this topic are about the item Choosing an AI in Sept...
Question of the Day
The New SQL Server 2025 Data type
In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?
See possible answers