SQL Server “Denali”: Details on the next version of SSIS
CTP3 of SQL Server Code Name “Denali” was made available recently, and it offers a lot of new features for...
2011-07-18
1,257 reads
Blog Posts
SQL Server Backup – Inadvertent Striping
When I started working with SQL Server I got bit in the rear one day while I was testing backups....
2011-07-18
1,706 reads
SQLServerCentral.com Track at SQL Server Connections This Fall in Las Vegas
As has now become a regular tradition, SQLServerCentral.com is providing an educational track at SQL Server Connections (part of DevConnections)...
2011-07-18
2,250 reads
Starting and Stopping a Remote Service with PowerShell
A recent project I was working on required me to move folders from a staging location to a processing location....
2011-07-18
1,984 reads
Custom folders SSMS Add-In slightly delayed
I am desperately trying to finalize this add-in and it is very very close. I was performing another testing on...
2011-07-17
562 reads
End Of Month Function in Denali CTP 3
While playing around with Denali, I came across a function that I believe should have been included in SQL for...
2011-07-17
1,677 reads
SQL Injection is still actual :)
Here are two samples showing that SQL Injection is still here and dangerous !!!
source:xkcd.com
This use case is especially insidious
2011-07-16
673 reads
Android Game: Slice-It
The eternal challenge with games, and free/cheap software in general, is knowing what’s out there, especially since you don’t always...
2011-07-15
667 reads
My first PowerShell Script to Move Folders
I just had my first encounter with having to write a PowerShell script. The request seemed pretty harmless when I...
2011-07-15
2,088 reads
Re-blog – July 8-July 14
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-07-15
758 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