Monday Morning SQL Break – September 19, 2016
It’s Monday and time for this week’s blog and twitter round-up. It’s been a few weeks since the last recap, apparently vacation a month and a half ago slowed...
2016-09-19
23 reads
Monday Morning SQL Break – September 19, 2016
It’s Monday and time for this week’s blog and twitter round-up. It’s been a few weeks since the last recap,...
2016-09-19
954 reads
Be a good administrator
Below are the topics every Administrator has to keep up with.
Backup / Restore:
Understand the backup / restore options SQL Server provides for...
2016-09-19
192 reads
Query Store and Plan Forcing: What Do You Use It For
If you’re working with Azure SQL Database or you’ve moved into SQL Server 2016, one of the biggest new tools...
2016-09-28 (first published: 2016-09-19)
1,257 reads
Power BI Custom Visuals Class (Module 17 – Sunburst)
In this module you will learn how to use the Sunburst chart Power BI Custom Visual. The Sunburst chart is...
2016-09-27 (first published: 2016-09-19)
1,907 reads
Using an ORDER BY in a view
For many years it’s been a best practice to never put an ORDER BY in a view. The idea is...
2016-09-26 (first published: 2016-09-19)
3,900 reads
Speaking at Suburban Chicago SQL Server Users Group Tomorrow
I will be presenting a technical session entitled ‘Virtual SQL Servers. Actual Performance‘ tomorrow evening for the Suburban Chicago SQL Server Users...
2016-09-19
364 reads
Building Oracle 12c on Linux 7 on Hyper-V
David has written a white paper, or short ebook titled building oracle 12C on Linux 7 VM residing on Hyper-V....
2016-09-19
461 reads
Books VS Internet
It’s is very easy to be
confused between investing in books or we should use the power of internet. If
you ask...
2016-09-19
239 reads
Distributed AG
going though Allan Hirt’s 24 SQLPASS recording, he has explained the new feature of SQL Server Availability group you can get...
2016-09-19
386 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