SQL Saturday 89 Pre-Con
Why am I attending Kevin Kline’s pre-con on “Troubleshooting & Performance Tuning Microsoft SQL Server 2008 R2” at SQL Saturday #89...
2011-07-14
616 reads
Blog Posts
SQL Server 2008 R2 Service Pack 1 Released
Microsoft has released the final build of SQL Server 2008 R2 SP1. It includes fixes from SQL Server 2008 R2 RTM Cumulative Updates 1 through...
2011-07-14
1,354 reads
Backup and Restore SharePoint 2010 Site Collection with PowerShell
One of the most annoying processes with SharePoint is backing up a site collection. There is a build in tool...
2011-07-13
1,886 reads
Bad Admins: Attacking via Group Membership
This is a series of blog posts about how administrators can gain access to SQL Server, even if you try...
2011-07-13
1,878 reads
BI Documenter: Impact Analysis and Object Lineage
Are you considering making a change to your view or stored procedure? Or possibly you are considering moving your database...
2011-07-13
2,684 reads
Denali on TechNet Radio
A quick plug for my friend Blain Barton from Microsoft, he’s got a series of three broadcasts that are video,...
2011-07-13
741 reads
Do you use T-SQL debugging?
T-SQL debugging is not 100% in SQL Server. It has few bad drawbacks starting from difficulties when setting it up...
2011-07-13
1,220 reads
How to move the MSDB database
First we need to know the name and file location of the MSDB database files. When you change the location, make...
2011-07-13
967 reads
Make It Simple With Policy-Based Management
At work recently, I explained to a coworker the reasons and benefits of having databases in Simple mode in your...
2011-07-13
958 reads
Simple Database User-Access Security Validation & Granting Elevated Access Temporarily Using the Execute As Statement
If you ever want to validate what level of access a user has within a database OR wish to temporarily...
2011-07-13
1,127 reads
Blogs
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...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
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