Lyrics for “SQL and I Know It”
I hadn’t planned to post the lyrics for yesterday’s song, but Mark Vaillancourt (Blog | @markvsql) thought that I should. Since he’s...
2011-10-07
590 reads
My PASS Summit 2011 Schedule
The annual PASS Summit is upon us once again! Here's where I'll be next week:
Monday
Arriving in Seattle mid-afternoonMonday Night Networking...
2011-10-07
685 reads
Denormalizing dimension tables
When building a SSAS cube, you typically have a star schema containing dimension tables and fact tables. For dimension tables,...
2011-10-07
2,257 reads
The Khan Academy
It’s completely unrelated to work, though there is a computer science section.
I can’t take credit for this, that goes to...
2011-10-07
2,225 reads
SQL Server – SQL Server 2008 Service Pack 3 RTM Released
Microsoft has released Service Pack 3 for SQL Server 2008 yesterday. You can read this blog post from SQL Server...
2011-10-07
887 reads
What I Learned at #SPC11
This week, I attended the Microsoft SharePoint Conference 2011 (#SPC11) in Anaheim. Not my usual beat, to be sure, but our company is starting to use SharePoint more, and...
2011-10-07
13 reads
What I Learned at #SPC11
This week, I attended the Microsoft SharePoint Conference 2011 (#SPC11) in Anaheim. Not my usual beat, to be sure, but our company is starting to use SharePoint more, and...
2011-10-07
19 reads
NYC MSBI NYC Event - Evolved BI with SQL Server “Denali”
While many of us SQL Server enthusiasts in the community will be at PASS Summit 2011, all next week, the...
2011-10-07
1,055 reads
Follow PASS Keynote Live Feeds via Blog & Twitter
Not going to be there? No Worries
The PASS Global Summit starts next Wednesday, October 12th in Seattle. PASS is the...
2011-10-07
608 reads
Follow PASS Keynotes Live Feeds via Blog & Twitter
Not going to be there? No Worries
The PASS Global Summit starts next Wednesday, October 12th in Seattle. PASS is the...
2011-10-07
682 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Split Large Queries in Athena with a Simple Modulo Trick
Comments posted to this topic are about the item Split Large Queries in Athena...
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers