Monday Morning SQL Break – April 4, 2016
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-04-04
464 reads
Complex/Conditional ORDER BYs
Typically it’s considered best to run your queries without an ORDER BY and let the application do any sorting needed....
2016-04-04
485 reads
Use PowerShell to script existing Availability Group creation scripts!
Scripts that write scripts! One of my favorites!
So last night I was up working on an issue with an Availability...
2016-04-07 (first published: 2016-04-04)
7,637 reads
SSC Editorial: Is Powershell Intimidating?
Is Powershell intimidating? It’s an interesting question, though perhaps unfair – TSQL can be intimidating when you first start out too....
2016-04-04
528 reads
Use PowerShell to script existing Availability Group creation scripts!
Scripts that write scripts! One of my favorites!
So last night I was up working on an issue with an Availability...
2016-04-04
221 reads
How to Load XML Data Files using the SSIS Script Component.
One of the common source data files that every ETL Developer/Architect will have to grapple with every now and then...
2016-04-03
17,855 reads
Speaking at SQL Saturday #487 in Ottawa on April 16, 2016
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2016-04-03
475 reads
SQL Server 2014 - Cardinality Estimator - Part 1
It has been a while since I blogged. Just moved to few other mediums like speaking at user group and...
2016-04-03
708 reads
Speaking at SQL Saturday 487 in Ottawa on April 16, 2016
<img alt=’’ class=’alignright size-full wp-image-1238 ‘src=’/img/2016/04/img_570152b22dc45.png’>
If you are a SQL Server professional and are interested in spending a day...
2016-04-03
75 reads
Reporting Services 2016 – Back in the game: the new capabilities & features // Zurück im Spiel: die neuen Möglichkeiten und Features
(DE)
Meine letzten Veröffentlichungen und Vorträge zu Reporting Services sind schon Jahre her. Kein Wunder, denn seit dem 2008 R2-Release...
2016-04-03
878 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