Protesting government web surveillance: Feb 11 Blackout
We at the MidnightDBA compound* believe firmly in the right to privacy, and so have watched with dismay over the...
2014-01-13
448 reads
SQL Awesomesauce
Applied SQL: Find and replace using regular expressions in SSMS
Regular expressions are searches on steroids, the wildcats of the wildcard world*. Even if you never ever write CLR, regex...
2014-01-10
1,240 reads
Clarity in T-SQL: Adjoining Socks
One of my children is very literal, a true pedantic. “Is there any homework you need to do?” “No.” “Really?...
2014-01-04
579 reads
Parameterization – A quick note on a CSS SQL article
I just finished reading an excellent CSS article, How Simple Parameterization works, which is well written and well worth a...
2013-12-18
529 reads
Scalzi’s Law of Cleverness, as applied to resumes
John Scalzi (blog, Twitter) – science fiction writer, Hugo award winner, philosopher, and blogger extraordinaire – has an adage that I wish...
2013-12-16
936 reads
What a DBA wants for Christmas
In the first few years of ITBookworm.com, we made sure to make up holiday lists of the most awesome gadgets...
2013-12-12
663 reads
Be a Brilliant DBA
John Sanson (b|t) recently asked a bunch of us, “If you could give a DBA just one piece of advice,...
2013-12-10
516 reads
#TribalAwards with RedGate!
You know what? You’re doing a good job. You’re reading blogs, and that’s generally the sign of a person wanting...
2013-12-09
566 reads
It sure would be grand to have interesting interviews
Coincidentally, in a week of debate and thinking and writing on IT interviews and candidates, XKCD has gifted us with...
2013-11-22
536 reads
What should a candidate know about your company?
I had a great comment (Ryan McCauley’s) on yesterday’s post that led to a great conversation on Twitter. The comment mentioned...
2013-11-27 (first published: 2013-11-19)
2,062 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