PASS Virtual Chapter Events : November 2013
Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters...
2013-11-02
938 reads
Windows Azure SQL Reporting discontinued
Windows Azure SQL Reporting was the new name of the reporting services component (which was formerly known as SQL Azure...
2013-11-01
6,487 reads
Reblog: October 25 to October 31
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-11-01
822 reads
PowerShell: Delete Unneeded Rows/Columns In Excel
I had a project to automate the import of a large number of excel files via SSIS into SQL 2012....
2013-11-08 (first published: 2013-11-01)
7,028 reads
Removing HTML formatting tag - BR - from XML using XQuery
This is a personal pet hate of mine.. Mixing HTML formatting tags directly with XML that aren’t escaped or contained...
2013-11-07 (first published: 2013-10-31)
3,978 reads
One day in the office
I got back from SQL Intersection on Wednesday afternoon. I did work a bit, but not too much after traveling...
2013-10-31
1,201 reads
Scaring a Database Near you
Something I have a hard time by-passing is a good R2 unit. I have R2 units in so many different forms, including a standing R2 cake one year for...
2013-10-31
12 reads
Scaring a Database Near you
Something I have a hard time by-passing is a good R2 unit. I have R2 units in so many different...
2013-10-31
1,282 reads
SQL Server Data Tools for SQL Server 2014 CTP2 now available
From Microsoft, SSDT is now available for SQL Server 2014:
We’d like to announce the availability of SSDT that supports SQL...
2013-10-31
1,586 reads
Tales from the Query Processor: II
Hello Dear Reader! Today is Halloween, October 31st. My Daughter turns a big 15 today! Happy Birthday Ches!!!!!
To celebrate two...
2013-10-31
1,387 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
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