Tales, Travels and Travails of the NYC DBA....
So, finally, I got my SQLServerCentral.com Blog, that Mr. Jones was kind enough to set up. Many thanks SJ!
My very...
2009-08-07
543 reads
Blog Posts
Use SQL Compare by Red Gate to Find a Missing Index
A couple of weeks ago one of our developers sent me an email saying, “I have a query that returns...
2009-08-07
4,374 reads
User Group Presentation: Essential Database Management - Top Ten Recommendations
In the August 13th 2009 meeting of the Ohio North SQL Server Users Group (ONSSUG), Paul Randal and his wife...
2009-08-07
330 reads
Book Review: Magnificent Desolation
Magnificent Desolation by Buzz Aldrin ($18 @Amazon) is his second autobiography (haven’t read the first one Return To Earth). I...
2009-08-06
356 reads
Scripting in SSIS
Tim Mitchell presented at SQLSaturday #17 on Scripting in SSIS. I thought it was a really interesting presentation, and I’m...
2009-08-06
2,242 reads
The effects UNION in a SQL query
In a recent blog, I shared some of the natural but sometimes unanticipated consequences of adding DISTINCT to a SELECT...
2009-08-06
595 reads
August 2009 Baton Rouge SQL Server User Group – Near Real-time Data Warehousing 1.0
Fresh off of my presentation of the SQL Profiler at SQL Saturday #17 in Baton Rouge this past Saturday, I...
2009-08-05
415 reads
Call For Speakers – SQL Lunch Live Meeting
The Baton Rouge Area SQL Server User Group hosts Bi-Monthly Live Meetings that are 15-30 minutes long the consist of...
2009-08-05
1,477 reads
Review of Bluetooth Speakerphone
I was visiting Compusa recently looking for a couple small things and noticed the Samsung Bluetooth Speakerphone for $24.99 (can...
2009-08-05
398 reads
SQL Saturday #17 – Baton Rouge Wrapup
My presentation went well at the Baton Rouge SQL Saturday with about 30 people attending. It was the early morning...
2009-08-05
363 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