Aliases in SQL Server 2008
Recently I set up replication and as the target server was not on our domain I initially used an IP...
2010-09-20
994 reads
SQL Saturday 46 (#sqlsat46) Recap
I was privileged to be able to attend and present at SQL Saturday 46 in Raleigh, NC, this last weekend....
2010-09-20
835 reads
Kimball University: Microsoft Data Warehouse in Depth
Several years ago, late 2006, I decided to focus my career on Data Warehousing and Business Intelligence (DW/BI). I was...
2010-09-20
1,177 reads
Review: Choosing to Cheat
Cross-posted from The Goal Keeping DBA blog.
I first heard about this book at SQL Saturday #51 when I was talking...
2010-09-20
869 reads
Roadtrip! SQL Saturday #53 - Kansas City
After speaking this coming weekend in Denver at SQL Saturday #52, I’m heading to SQL Saturday #53 in Kansas City...
2010-09-20
829 reads
SQLSaturday #49 – Orlando is Closing In
We are less than an month from SQLSaturday #49 – Orlando at Seminole State College – Sanford/Lake Mary campus on October 16th. ...
2010-09-20
499 reads
Free SQL Server Training for the Week of September 20, 2010
Monday
PASS Data Warehousing/BI Virtual Chapter - Adaptive BI: Engineering a BI Solution - Davide Mauri
Tuesday
SQL Lunch - Restartability in SSIS - Kyle Walker
Pragmatic Works...
2010-09-20
664 reads
SQLSaturday Event Leaders – Reserve Your Date for H1 2011
We’ll try to push this out through multiple channels, we’re trying to forecast dates to give those thinking about events...
2010-09-20
572 reads
September PASSMN Meeting This Week
Enjoying the fall here in Minnesota? The leafs are changing a bit and temp has been dropping. Has that left...
2010-09-20
514 reads
Home Theater Upgrades
Back in late 2003, I had my basement finished,and as part of that effort, I put in a dedicated home...
2010-09-20
624 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...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
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