High Performance T-SQL using Code Patterns
What exactly does this mean? We’ve heard of “code patterns” in other programming languages, but what does it mean to...
2015-06-04 (first published: 2015-05-27)
9,335 reads
Speaking at ITPROceed 2015
This year I have the opportunity again to speak at ITPROceed, the biggest (Microsoft-related) conference in Belgium for the IT...
2015-05-27
434 reads
Maintaining Parallel Power Pivot and SSAS Tabular Models–Tales from the Trenches
This post is really a collection of field notes and some lessons learned from recent project experience. I’ve done plenty...
2015-05-27
279 reads
Maintaining Parallel Power Pivot and SSAS Tabular Models–Tales from the Trenches
This post is really a collection of field notes and some lessons learned from recent project experience. I’ve done plenty...
2015-05-27
487 reads
Native Client Aliases don’t like Trailing Spaces
I usually don’t post small things like this, but today I fought with this obnoxious problem long enough to convince me that...
2015-06-02 (first published: 2015-05-26)
1,576 reads
New Articles About Datazen, Microsoft’s Mobile Dashboard Platform
I’m pleased to share the first two articles in a series for SQL Server Pro Magazine. Here’s a short excerpt...
2015-05-26
227 reads
New Articles About Datazen, Microsoft’s Mobile Dashboard Platform
I’m pleased to share the first two articles in a series for SQL Server Pro Magazine. Here’s a short excerpt...
2015-05-26
435 reads
Full Domain Trust and Natively Compiled Stored Procedures – In Memory OLTP
Recently one of my developers brought this specific problem to my attention. He was trying to create a natively compiled stored...
2015-06-03 (first published: 2015-05-26)
1,374 reads
Migrating SQL Agent Jobs with Schedules using T-SQL
I’ve seen many a blog post about migrating SQL Agent jobs across instances using PowerShell, SMO, T-SQL, and the like....
2015-05-26
2,474 reads
Tuesday Morning SQL Break – May 26, 2015
It’s Tuesday (Monday was a holiday for me this week) and time for this week’s weekly blog and twitter round-up for...
2015-05-26
549 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