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
453 reads
Jen McCown
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,249 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
590 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
550 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
943 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
668 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
525 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
574 reads
How to Fail a Phone Screen
It’s funny to me how easy it is to fail a phone screen – both as the interviewer, and as the...
2013-11-29 (first published: 2013-11-18)
4,160 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,067 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers