Off to SQLSaturday #14
I leave this afternoon for Pensacola and SQLSaturday #14. My daughter is traveling with me, for a short vacation with...
2009-06-04
331 reads
Blog Posts
SQL Saturday 14 Pensacola
I will be speaking this Saturday at the SQL Saturday in Pensacola. The topic will be SSIS Best Practices and Performance Tuning. ...
2009-06-04
769 reads
SQLServerCentral.Com to Offer SQL Server Track at SQL Server Connections
I have spoken at many conferences over the years, including the PASS Community Summit and SQL Server Connections, and one...
2009-06-04
709 reads
The SQLServerCentral Track at SQL Connections
I'm happy to announce that SQLServerCentral is sponsoring a track at this year's SQL Connections conference in Las Vegas, Nov...
2009-06-04
777 reads
Tool Review: Bosch PS-40 10.8 Volt Impact Driver
A little further off topic than usual, but this is one of the few tools that I've purchased that I...
2009-06-04
446 reads
I Learned a New Word
Do you know what a Geoid is?
I’ve been working my way through Beginning Spatial with SQL Server 2008, actually “through”...
2009-06-03
660 reads
Scripting Our Daily (Professional) Lives
I talk a lot about scripting tasks on our servers to automate our regular processes, but in this case I'm...
2009-06-03
350 reads
Seatguru - Getting a Good Seat on the Plane
Ran across this a while back and just getting to it, Seatguru is a site that lets you figure out...
2009-06-03
393 reads
Speaking at SQLSaturday #14 in Pensacola on June 6, 2009
I'm driving over tonight to spend a long weekend in Pensacola (6-7 hour drive from Orlando) for their first SQLSaturday,...
2009-06-03
470 reads
SQLServerCentral Article on Backup Monitoring and Reporting
The article, Backup Monitoring and Reporting, demonstrates a SQL Server backup reporting solution I use in my production environment. Some highlights of...
2009-06-03
1,330 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
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
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
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