Advanced Persistent Threats and Us
In a blog post from last year, Richard Bejtlich (blog | twitter) talked about a concept called an Advanced Persistent Threat...
2011-10-07
1,326 reads
Blog Posts
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
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
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
Microsoft Releases SQL Server 2008 SP3 RTM
Microsoft has released the final, RTM version of SQL Server 2008 Service Pack 3. This is build 10.00.5500. It includes...
2011-10-07
1,650 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
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
PASS Summit is almost here
This is my second trip to Seattle for the annual bash. Last year I was a newbie. I did not...
2011-10-07
1,475 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
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