SQLSaturday #40 is Almost Here – July 31, 2010
I’ll be leaving Friday morning with my family to go to Miramar, Fla, for the 2nd annual SQLSaturday there. I’m...
2010-07-29
529 reads
Blog Posts
The Dangers of Sub-queries!!!!
Ok, now that I have your attention this really should be titled the danger of not qualifying all objects, but...
2010-07-29
743 reads
The Killer Backslash in TSQL
--it is
quite startling to see that this, in TSQL, executes.
Select \
/*
---------------------
0.00
(1
row(s) affected)
so does
this....
*/
Select null /\/\/\/\/\/\/\/\/\/\/\/\
/*
---------------------
NULL
(1
row(s) affected)...
2010-07-29
5,822 reads
What Indexes are on My Table!
In this quick blog, I want to show you one way of how to find out what indexes you have on a table...
2010-07-29
493 reads
2010 3rd Quarter Goals
Now that we are into the third quarter of 2010 I decided to post an update of my 2nd quarter...
2010-07-28
1,013 reads
Interviewed by Andy Leonard
Andy Leonard is posting interviews of all the candidates PASS Board of Directors on his blog and mine is up...
2010-07-28
389 reads
Interviewing for the PASS Board of Directors
My nomination application made it through the committee. I got an email yesterday telling me that I needed to schedule...
2010-07-28
802 reads
MDX Puzzle #4
This puzzle is rather simple, but it does introduce a few new things. Using T-SQL you typically filter queries with...
2010-07-28
556 reads
PASS 2010 Summit on LinkedIn Event Calendar – Have You RSVP’d?
Happened to notice in my weekly LinkedIn update today that Todd McDermid had signed up for the 2010 Summit event...
2010-07-28
793 reads
PASS Update #38 (SQLSaturday Wiki)
For the past couple years we’ve had a few different documents that covered how to run a SQLSaturday, but as...
2010-07-28
645 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