T-SQL Tuesday #70 - SQL Server In the Enterprise
PearlKnows WeB log, Stardate 2015.9.8: This week’s topic is strategies for
managing an enterprise, brought to us by one half of...
2015-09-08
3,124 reads
Enterprise Strategies – A #TSQL2sDay post
This months TSQL2sDay blog post party is hosted by Jen McCown and is about Enterprise Strategy.
Adam Mechanic started TSQL Tuesdays...
2015-09-08
599 reads
Webinar – SSIS Best Practices and Tuning Tips
I’ll be giving an SSIS webinar for MSSQLTips.com on Tuesday 15th September 2015.
The title is SQL Server Integration Services Best...
2015-09-14 (first published: 2015-09-08)
2,665 reads
Setting Up Alerts in Azure SQL Database
Setting Up Alerts in Azure SQL Database
SEPTEMBER 8, 2015
IntroductionIf I've learned one thing with my on premise versions of SQL Server, it is to automate as much as possible....
2015-09-08
82 reads
Setting Up Alerts in Azure SQL Database
Setting Up Alerts in Azure SQL DatabaseSEPTEMBER 8, 2015
Introduction
If I've learned one thing with my on premise versions of SQL...
2015-09-14 (first published: 2015-09-08)
3,850 reads
Hekaton Part 6:- Hash Indexes - Intro
With SQL Server 2014, new type of Index called the hash index was introduced. Little introduction to hash function would...
2015-09-11 (first published: 2015-09-08)
2,612 reads
Azure Data Catalog
Azure Data Catalog
Now available in public preview is the Azure Data Catalog. The Data catalog provides an enterprise data repository...
2015-09-08
682 reads
SQL Server – Using Window ranking function with UPDATE statement
Hi friends, I was working on a scenario in which I need to assign a unique values to a column....
2015-09-08
628 reads
House Price Predictions @ PASS 2015
The PASS speakers were announced a quite a number of weeks ago now for PASS 2015 in October – and I felt pretty damn honored to be one of the 160 or...
2015-09-07
8 reads
House Price Predictions @ PASS 2015
The PASS speakers were announced a quite a number of weeks ago now for PASS 2015 in October – and I felt pretty damn honored to be one of the 160 or...
2015-09-07
18 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