Answer the Question Asked
“Bill, are you running SQL R2 on your desktop?”
This seems like a simple enough question, yet I usually cannot get...
2012-01-13
846 reads
Jen McCown
DBAs@Midnight 6 week roundup
We’ve been awfully busy these last few weeks, what with holidays and work and whatnot. But that hasn’t stopped us...
2012-01-12
693 reads
SELECT GetDate() – 30 AS [This actually works??];
I just ran across this in a piece of code (that I didn’t write):
… WHERE Thing >GETDATE()- 30
Aaaand it works....
2011-12-19
1,233 reads
PASS Board of Directors – Who I’m Voting For
I was inspired by fellow blogger and all around good guy Nic Cain (Twitter, blog) to write about the PASS BoD...
2011-12-15
673 reads
#SQLLove for my Mentor
In 1986, my big brother Jim accidentally encouraged me on my road to geekdom by purchasing an Apple][e, and later...
2011-12-14
746 reads
SQL Server is Smarter Than You
I had a brief email discussion recently, which could be effectively be boiled down to:
Them: “Are foreign key constraints more...
2011-12-08
847 reads
How to Build a Resume (that doesn’t suck)
Resumes are like opinions, which are like something else: everybody’s got one. And if you don’t have one, then certain...
2011-12-06
3,162 reads
Convince me to read books (WHERE LEN(argument)
While you wait for my awesome upcoming blog on data exception notification with SSRS, let’s pursue a whim of mine.
I...
2011-11-30
1,676 reads
Stop SOPA…it already happened in Denmark #StopSOPA
I put out the call to stop SOPA, and one Twitter friend wrote back:
Good luck! We have it in Denmark....
2011-11-16
553 reads
Un-SQL Friday: Stop SOPA!
This will be an unusually political Un-SQL Friday – and it’s two days early, to boot – but I’m making an exception...
2011-11-15
1,060 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