Writing A Question Of the Day–More Notes
One of the things I’m trying to do now is include a link to a blog(ger) in the explanation. That...
2014-05-22
491 reads
An Sp_addrolemember Gotcha
Over the past few months there have been a handful of times when I had to fix a security problem...
2014-05-22
834 reads
Avoiding a split brain in database mirroring
You’re utilizing the database mirroring high-availability feature, configured to be in the High Safety mode with automatic failover, which means...
2014-05-28 (first published: 2014-05-22)
6,163 reads
Getting Started with the Modern.ie VMs on VirtualBox with IIS Express
Microsoft has made pre-packaged Virtual Machine images available for purposes of testing different versions of IE via the modern.ie web...
2014-05-22
2,387 reads
Two things you probably shouldn’t say in an interview
If you look online you can find thousands of pages of advice on interviews as well as people asking for...
2014-05-22
899 reads
Advanced Google Analytics for SSIS
Update: There is a new 1.7 Version of Google Analytics Source for SSIS
This post is a continuation of the SSIS...
2014-05-22
428 reads
Setting Up Your Custom Data Collector Set
Problem: From my previous post, we learned how to set up Data Collection in SQL Server. This is most suitable...
2014-05-21
606 reads
Supported Compatibility Levels in SQL Server
It has been well documented and is well known that SQL Server supports certain older versions of SQL Server in a compatibility mode. This setting is something that can...
2014-05-21
21 reads
Supported Compatibility Levels in SQL Server
It has been well documented and is well known that SQL Server supports certain older versions of SQL Server in...
2014-05-21
17,411 reads
Submitted My Application For the 2014 PASS Nominating Committee
I just finished up the short and not very painful application to be a candidate for the NomCom this year. ...
2014-05-21
496 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
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') AND BusinessEntityID IN (7,8)See possible answers