Seeking Full Day Seminars For The Friday Before SQLSaturday Orlando 2015
We’re planning to run one or two (or maybe even three) seminars (aka pre-cons) in conjunction with SQLSaturday Orlando 2015....
2015-06-24
499 reads
Why does sqlpackage.exe not compare after the pre deployment script has run?
It isn't a Pre compare script
When you use SSDT to deploy your dacpac, a pre deployment script lets you run...
2015-06-24
865 reads
Why does sqlpackage.exe not compare after the pre deployment script has run?
It isn’t a Pre compare script
When you use SSDT to deploy your dacpac, a pre deployment script lets you run...
2015-06-24
45 reads
Why does sqlpackage.exe not compare after the pre deployment script has run?
It isn’t a Pre compare script
When you use SSDT to deploy your dacpac, a pre deployment script lets you run...
2015-06-24
79 reads
Adding Extended Properties to a Table
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2015-07-03 (first published: 2015-06-24)
6,408 reads
Why does sqlpackage.exe not compare after the pre deployment script has run?
It isn't a Pre compare script
When you use SSDT to deploy your dacpac, a pre deployment script lets you run some T-SQL scripts before the script which brings your...
2015-06-24
20 reads
Some simple examples of querying xml with sql
XML is a beast if you've never tackled it. Here are some simple examples of what I discovered as I...
2015-06-30 (first published: 2015-06-24)
2,917 reads
Use 100% Fill Factor on Insert Only Tables
SQL Server has the concept of fill factor for leaving extra space in pages to reduce the number of page...
2015-06-24
807 reads
SQL Cruise Mediterranean+
This is a post that is looooong overdue. I have intended to write some of this at least since the first SQL Cruise I attended back in 2013 (in...
2015-06-24
20 reads
SQL Cruise Mediterranean+
This is a post that is looooong overdue. I have intended to write some of this at least since the...
2015-06-24
667 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