A Proper Response
That sounds like a very British title, so maybe the Red Gate folks are rubbing off on me. I had...
2009-04-20
584 reads
Blog Posts
Four new SSIS Videos on JumpstartTV.com
I've got four new SSIS videos published on JumpstartTV.com:
Expression Language Basics
Secure FTP File Transfer in SSIS
SSIS Lookup Transformation Basics
SSIS...
2009-04-20
2,209 reads
Interviewed by Tom Larock
Tom has been doing a series of interviews on his blog lately and I ended up on the list. Interviewing...
2009-04-20
523 reads
Prius Update – Smells Like New
We got the Prius back yesterday. I dropped Kyle off and he drove it home. Today was my first time...
2009-04-20
525 reads
Revisiting the Task List
I've written a few posts in the past about time management, and thought I'd post an update with some lessons...
2009-04-20
591 reads
Security Basics - The C-I-A Triad
In the course of giving my security presentations over the past year, I've learned that quite a few folks have...
2009-04-20
9,104 reads
Simply Dumb Founded - A Non SQL Blog
Blogging is both more fun and harder than it looks, so when someone is getting started I try to offer...
2009-04-20
548 reads
The Death of Email Questions
One of my policies is not to answer questions from people about SQL Server in email. That includes emails to...
2009-04-20
1,060 reads
Use SQL 2008 Express As A Central Management Server
I had the chance to catch Brent Ozar's webcast last week on creating a poor man's CMDB. In it he...
2009-04-20
897 reads
Database Administration Literature Criticism
What is literature? I find this definition is pretty intuitive at http://classiclit.about.com/od/literaryterms/g/aa_whatisliter.htm and also this one is more comprehensive at...
2009-04-19
1,015 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