Using the ScriptDom without losing comments
The ScriptDom is cool, it lets you parse T-SQL, play around with the AST (tree of statements) and then generate...
2015-11-24
1,093 reads
Using the ScriptDom without losing comments
The ScriptDom is cool, it lets you parse T-SQL, play around with the AST (tree of statements) and then generate T-SQL again (probably in a different format etc). This...
2015-11-24
31 reads
Using the ScriptDom without losing comments
The ScriptDom is cool, it lets you parse T-SQL, play around with the AST (tree of statements) and then generate...
2015-11-24
56 reads
Using the ScriptDom without losing comments
The ScriptDom is cool, it lets you parse T-SQL, play around with the AST (tree of statements) and then generate...
2015-11-24
46 reads
Calculating Table Partition Sizes in Advance
[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 7. The partitioning includes several major components of work (and can be linked...
2015-11-23
14 reads
Calculating Table Partition Sizes in Advance
[read this post on Mr. Fox SQL blog]
Continuing on with my Partitioning post series, this is part 7.
The partitioning includes several major...
2015-11-30 (first published: 2015-11-23)
1,511 reads
Using multiple log files
The transaction log is made up of one or more files that are used sequentially. So in other words if...
2015-11-27 (first published: 2015-11-23)
1,560 reads
Cumulative update package 9 for SQL Server 2012 SP2
Microsoft just announced Cumulative update package 9 for SQL Server 2012 SP2
Microsoft reference: [Click Here]
For more updates:
Subscribe for Blog posts [Click Here]
Follow...
2015-11-23
143 reads
Steps to install SQL Server CTP 3 on Windows Azure
Hi friends, SQL Server 2016 CTP 3 is available now and it can be downloaded on Azure. So I tried...
2015-11-23
504 reads
SSDT DevPack - Highlight expensive queries
When developing stored procedures in SSDT it is important to know when you have written a query that is potentially...
2015-11-27 (first published: 2015-11-22)
1,729 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