T-SQL Tuesday #56: Assumptions
Well, here it is again. The second Tuesday of the month, which means that it’s T-SQL Tuesday. This month, Dev...
2014-07-08
804 reads
Is your Team Willing to Take Control?
The calendar tells us that once again we have reached the second tuesday of the month. In the SQL Community, this means a little party as many of you...
2014-07-08
16 reads
Is your Team Willing to Take Control?
The calendar tells us that once again we have reached the second tuesday of the month. In the SQL Community,...
2014-07-08
567 reads
Worst Day of a DBAs Life
Red Gate Software is running a campaign around coping with the worst day of a DBAs life. We’ve been posting...
2014-07-08
872 reads
Which One’s Better?
During a recent webcast, someone asked if, in an EXISTS query, it is better to use “SELECT *”, “SELECT ‘1’”, or...
2014-07-08
515 reads
T-SQL Tuesday #56: Assumptions
I assume that since it’s the second Tuesday of the month that it’s time for T-SQL Tuesday. And you can...
2014-07-08
853 reads
Columnstore Table Analyzer
As I’ve discussed in some of my previous posts, there are quite a few data types that cannot be part...
2014-07-08
766 reads
How to Generate a Fiddler SAZ File
Fiddler is a free program that will log HTTP and HTTPS requests on Windows. These instructions demonstrate how to use...
2014-07-08
2,856 reads
Upcoming Free PASS VC Webcasts
Here is a list of upcoming webcast presented by various PASS Virtual Chapters that are always free. Some are recorded...
2014-07-08
600 reads
SSRS reports in SharePoint mode, Saga #2: PowerShell generates email subscriptions
Life is full of opportunities, it only takes to notice and use them. About 3 months ago I wrote a...
2014-07-07
2,797 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