Save the date: SQLSaturday Iowa City
Q: True or False – Iowa has one of the world’s longest-running SQL Server conferences?
A: True! SQLSaturday #19 was held in the fall of...
2016-01-28
1,021 reads
Where in the world are Jen and Sean?
Updated with more SQL Saturdays! Well hi there, folks. A month slips by so very fast. Here is your January...
2016-01-28
1,044 reads
Reblog: Building the Script Component
SQLKover update: For some reason, this was my most popular blog post on the old LTD site. Over 110,000 views. People...
2016-01-28
868 reads
Encrypting AlwaysOn Availability Group Transport- Some thoughts!
Transport security for AlwaysOn Availability Group is an interesting topic, and any day it’s a topic which is debatable. The transport security involves encryption of packets exchanged between the...
2016-01-28
19 reads
Encrypting AlwaysOn Availability Group Transport- Some thoughts!
Transport security for AlwaysOn Availability Group is an interesting topic, and any day it’s a topic which is debatable.
The transport...
2016-01-28
2,206 reads
Migrate from on-prem SQL server to Azure SQL Database
This blog describes the various approaches you can use to migrate an on-premises SQL Server database to Azure SQL Database.
In...
2016-01-27
1,168 reads
The Importance of a Full Backup in SQL Server
This is the first of 12 posts this year in support of Tim Ford’s #iwanttohelp initiative. These will be completely...
2016-01-27
508 reads
The CONNECT permission
The CONNECT permission exists at the instance and database levels. Note: as of SQL 2012 it is CONNECT SQL at...
2016-02-03 (first published: 2016-01-27)
3,429 reads
Goodness-of-Fit Testing with SQL Server Part 4.2: The Hosmer–Lemeshow Test with Logistic Regression
By Steve Bolton
…………The last installment of this amateur series of self-tutorials was the beginning of a short detour into using...
2016-02-02 (first published: 2016-01-26)
1,545 reads
Webcast: Upgrading and Migrating SQL Server 2005 BI Features to SQL Server 2014 and 2016
Please join me on February 3rd at 10 Pacific Time for this presentation brought to you by Microsoft and SolidQ...
2016-01-26
536 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