T-SQL: CASE Statement
This is a companion piece to the MidnightDBA video T-SQL: CASE Statement.
In short, a CASE statement is a simplified set...
2010-12-28
2,728 reads
Jen McCown
PASS Summit Speaker Evals – THE ANALYSIS
Rule: No Sushi with Adam within 24 hours of session
I’m inspired by Brent Ozar‘s and Andy Leonard‘s sharing of their PASS...
2010-12-23
788 reads
RTFM365, Week 2 (AND week in review)
Hooboy…the super-structured format of the first two RTFM365 posts just isn’t sustainable for me. I’m going to have to go...
2010-12-20
665 reads
T-SQL Tuesday #13–A Business Walks Into a Bar….
Hello and welcome to the December 2010 edition of T-SQL Tuesday. This month’s host is Steve Jones (blog|twitter) of SQLServerCentral,...
2010-12-14
552 reads
All Things Awesome and MidnightDBA-y – 12/9/2010
Here’s the rundown of what we were up to last week
Friday night at 11pm CST we present another wildly appealing...
2010-12-13
811 reads
RTFM365, Week 1
Big lessons learned this week: 1, its’ always worthwhile to go back and reread the basics. 2, sys.sp_trace_create option 4 doesn’t...
2010-12-10
516 reads
Spotlight: Jes Borland
It’s been a few months…time for another Spotlight!
Just to catch you up, occasionally someone in the SQL community – usually someone...
2010-12-09
1,420 reads
24HOP Needs Women!
“Next 24 Hours of PASS on March 15-16 2011, celebrating Women’s History Month with 24 female speakers!”
Thus goes the announcement on...
2010-12-08
1,206 reads
24HOP Needs Women!
“Next 24 Hours of PASS on March 15-16 2011, celebrating Women’s History Month with 24 female speakers!”
Thus goes the announcement on...
2010-12-07
814 reads
Tip: Schema Qualify Objects in SPs
“Eat your broccoli.”
“Wear your gloves.”
“Schema qualify your objects.”
Your Mom wasn’t kidding, and she always gave the best advice. We’ve already...
2010-12-06
1,720 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