Stairway to XML: Level 9 - Creating XML-Based Functions
In this Level, we’ll look at how to use XML methods within user-defined functions to return XML fragments and values from your target XML instance.
The Knowledge Graph
Google has a new project to use a "database of everything" to help you learn more.
SQL Server Performance Tuning – Index Tuning
In earlier installments of this series we looked at T-SQL Performance optimizations along with different T-SQL practices, we can now turn our attention to the second part of this series which is index Tuning
Acing an Audit
Audits for technology groups can be time consuming and stress employees out. An article Steve Jones finds says an insurance company only needed 30 minutes to ace their audit.
My SQL Server Database is Corrupt - Now What?!
How do you recover from corruption if your organization doesn't have a disaster recovery handbook? And how can you prevent the same corruption from recurring?
Providing SQL Agent Job Log Data for Developers
As a production Database Administrator, I do not want to give Developers direct access to the SQL Server Agent job log especially for servers in the DMZ. Another problem we have is that when there is a lot of log data for a job, the default job log doesn't contain the full log detail and that makes it harder to troubleshoot. Most of all, we are trying not to use a different code set for deployment based on the environment. Basically we want to use the same methods to deploy our jobs to Development, Test and Production.
Not Pulling the Plug Out
Phil Factor on his renewed appreciation for the "customer-focused" culture of the Data Platform Group at Microsoft
Still 32
There is likely still a lot of 32-bit software out there, even as the x86 platform appears to be dying away. Steve Jones notes that you'll likely be dealing with 32/64 bit issues in your career.
Update statistics in parallel
This articles shows a technique that generates and launches an SSIS package to update statistics in parallel.
Blogs
Ten Years of PowerShell
Ten years ago, I published a post about filming a Pluralsight Play by Play...
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...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
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