Off to the Center of the Universe
“New York City…center of the universe..” – Rent
I’m off to New York this morning for the start of the 2012 SQL...
2012-09-27
1,698 reads
Blog Posts
SQL in the City US tour begins tomorrow #sqlcity
The Red Gate SQL in the City US tour begins tomorrow in New York City. If you have not registered...
2012-09-27
1,435 reads
SQL Saturday 151 Interview: Stacia Misner
Hello Dear Reader SQL Saturday 151 is just around the corner. If you haven't registerd there is still time to...
2012-09-27
1,725 reads
SQL SERVER : How to List All Email Subscription configured in SSRS ?
Often I used to get request from my business managers to get a list of all subscriptions configured in SSRS...
2012-09-27
14,787 reads
SQL Server 2012 AlwaysOn now officially supported by VMware
I read yesterday that VMware has updated the “Microsoft Clustering on VMware vSphere: Guidelines for Supported Configurations” KB article linked...
2012-09-27
3,092 reads
The State of Microsoft Self-Service Reporting
(article published on the MVP Award Program Blog) I really enjoy this topic. One of the reasons, I suppose, it’s...
2012-09-27 (first published: 2012-09-25)
2,751 reads
Come See Us at SQL Saturday #165 in Lincoln!
I will be speaking with several of my House of Brick Technologies colleagues at SQL Saturday #165 in Lincoln in...
2012-09-26
591 reads
DBMail on a cluster
I’ve always found clusters a pain in the neck. For my latest pain I just spent the last 2 days...
2012-09-26
635 reads
Excel 2013 – Trouble Installing Silverlight for Power View
Last week during my 24 Hours of PASS session on Choosing a Reporting Platform I fielded a question that appeared...
2012-09-26
1,299 reads
How BETWEEN is inclusive
This is a old and simple one, but an important subtlety that TSQL developers must be aware of.
Using the BETWEEN...
2012-09-26
2,758 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
Question of the Day
RegEx Functions II
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') AND BusinessEntityID IN (7,8)See possible answers