June Midlands PASS Meeting Canceled
We are canceling the June Midlands PASS meeting because the speaker (me) is still under the weather. I'll post in...
2007-06-07
1,299 reads
Blog Posts
Katmai Manageability
The database manages itself. Not totally, but close to it. It was an
analogy made by Dan Jones with cars. Auto...
2007-06-06
1,344 reads
Southern BBQ
Last night I went out with Tony Davis of Simple Talk and Alan White, a
longtime author for both here and...
2007-06-06
1,389 reads
SQL Server 2005 Security
It's a similar theme, off by default if it makes sense, minimize surface area.
Recommendations: for new installs, leave stuff off...
2007-06-06
1,464 reads
Beyond Relational
I missed this yesterday, but I saw it on the schedule again, and I knew
I had to make this one....
2007-06-05
2,005 reads
DBCC Internals
CHECKDB
- needs consistent view of the db. Needs to do this without locking. In
SQL Server 2000 log analysis is used....
2007-06-05
1,850 reads
Maintenance in SS2K5
Andrew Kelley from Solid Quality Learning did this one, which was good.
I was worried it would be about maintenance plans,...
2007-06-05
1,555 reads
Reunion
We're not partners anymore in SQLServerCentral.com, but Andy, Brian,
and myself got together last night for dinner. We haven't seen each
other...
2007-06-05
617 reads
SQL Server 2005 Tools
A good talk on the tools from the guy that's responsible for SSMS,
Configuration Manager, Maintenance plans, Surface Area Configuration
Wizard, and...
2007-06-05
613 reads
SQL Server Always On
Everyone wants 5 9's of uptime, 24x7 support, and instant fixes for
issues with their database server. Never mind that I'd...
2007-06-05
2,183 reads
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
Forums
SQL Server 2025 Jobs
Hello SQL Server 2022 16.0.4212.1 running on a Windows Server 2025 Std,V 24H2, SO...
how to optimise whole database full of table and sp in one go using githubcopilo
i have subscription of github copilot which i can access in vs 2022 comunity...
Password Guidance
Comments posted to this topic are about the item Password Guidance
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers