2018-06-12 (first published: 2018-01-03)
1,986 reads
Scripts
2018-06-11 (first published: 2018-01-03)
2,678 reads
2018-06-08 (first published: 2018-01-03)
2,544 reads
2018-06-07 (first published: 2018-01-13)
2,385 reads
2018-06-05 (first published: 2018-01-11)
2,195 reads
SQL Server Backup, Integrity Check, Index and Statistics Maintenance
Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017.
2018-06-04 (first published: 2008-02-23)
48,282 reads
Generate scripts for SQL Server Management Studio diagrams
The procedure generates an import script of diagrams.
2018-05-31 (first published: 2017-03-22)
6,739 reads
2018-05-30 (first published: 2018-01-03)
2,527 reads
2018-05-02 (first published: 2018-04-17)
1,049 reads
2018-05-01 (first published: 2018-04-20)
1,209 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