Windows Home Server – Setup and Installation
I wrote an editorial last summer asking people what type of protection they had for their home setup. I got...
2009-12-09
706 reads
Blog Posts
Age calculation with SQL Server
There seem to be many different methods being suggested to calculate an age in SQLServer. Some are quite complex but...
2009-12-08
1,130 reads
Are trivial plans cached?
It is sometimes said that trivial execution plans are not cached and queries that have such plans are compiled on...
2009-12-08
1,232 reads
ASK SQLServerCentral
We've had the ASK SQLServerCentral site up for a couple months now and while I see traffic continuing over there,...
2009-12-08
593 reads
Database Books
Well my theory on posting every week has been tested to the limit somewhat and I didn’t get anything written...
2009-12-08
450 reads
December Patches
I note these for Database Weekly, but I haven’t blogged about them. A mistake on my part.
The December patches from...
2009-12-08
499 reads
Fundamentals of Storage Systems – RAID and Hard Disk Reliability, Under the Covers
In the last RAID article we covered the basics. This is a little deeper dive into the underlying mechanics of...
2009-12-08
1,522 reads
Handling Inconvenient Requests
"You can have everything in life that you want if you will just help enough other people get what they...
2009-12-08
738 reads
Locking & Blocking
On the gridiron, two opposing teams are contending for one very limited resource, the football. One team has it; the...
2009-12-08
521 reads
Microsoft Certified Master: SQL Server 2008 Pre-reading List
Via Twitter, I stumbled upon a link to this newly updated pdf from Joseph Sack and David Ikeda who are...
2009-12-08
1,067 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
Warning: Could not open global shared memory to communicate with performance DLL
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers