Interviews with Great SQL People – Authors, MVPs, many more
I’m trying really hard to write a blog that goes over all the great #sqlpass interviews we’ve done, but work...
2013-09-27
1,273 reads
Reblog: September 20 to September 26
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-09-27
1,360 reads
Azure Offerings Continue to Expand
We just received word of a bunch of new functionality over at Scott Guthrie’s blog. Not a lot of stuff...
2013-09-27
1,326 reads
Understanding Microsoft Self-Service BI Recording and Q&A
I hope you were able to attend my free webinar on Understanding Microsoft Self-Service BI on September 26, 2013. If...
2013-09-26
1,358 reads
Webcast Follow-Up: Recognizing the Parallel Data Warehouse (PDW) Workload
Last Monday, I presented a session for Pragmatic WorksTraining on the T’s on the Microsoft’s Parallel Data Warehouse. In the session,...
2013-09-26
1,594 reads
Microsoft Hyper-V 2012 R2 Enhancements That DBAs Should Care About
The last couple of months have shown that the hypervisor battles for bigger, faster, and smoother are still heated and...
2013-10-02 (first published: 2013-09-26)
2,446 reads
SQL Server 2014: Partition Improvements
SQL Server 2014 has enhancements to two common database maintenance operations:Partition Switching and Online Index Rebuild. This will greatly increase...
2013-09-26
1,237 reads
PASS Votes
I’ve already made my own intentions clear. I’m casting one of my votes for Allen Kinsel. But, I get three...
2013-09-26
755 reads
Images, charts, indicators and sparklines in a tablix stretch and degrade report performance
This fact is probably not documented very well but this is an important factor in SSRS visual report design… The...
2013-09-26
377 reads
Images, charts, indicators and sparklines in a tablix stretch and degrade report performance
This fact is probably not documented very well but this is an important factor in SSRS visual report design… The...
2013-09-26
742 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