31 Days of SSIS for SQL Server 2014 Update Question
A few years back, I put together a blog series on SQL Server Integration Services (SSIS) titled 31 Days of SSIS....
2014-02-24
1,304 reads
Why I Developed SQL Code Guard: A Fairy Tale from a DBA
A long time ago, in a galaxy far, far away….
About ten years ago, I realized I was spending more than...
2014-02-24
833 reads
Last Weeks Top “Reading” Links #72
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-02-24
1,052 reads
Accenture and DataStax Establish Big Data Alliance #bigdata
Accenture and DataStax have signed an alliance agreement, formalizing their longstanding collaboration in helping clients manage and drive insights from...
2014-02-24
596 reads
Expiration dates: SQL Server 2008 and 2008 R2
SQL Server is a software product, right? And software has a history of having bugs, getting updates, and having support...
2014-02-24
580 reads
Free Presentation Software
Here’s a list of free presentation software I ran across, maybe worth a few minutes to get out of the...
2014-02-24
736 reads
What’s the difference between a temp table and a table variable?
I recently saw an answer to this question on dba.stackexchange.com written by Martin Smith. It was probably one of the...
2014-02-24
1,109 reads
Modern Retail Architectures Built with Hadoop | Hortonworks
We’ve probably all heard the famous quote by John Wanamaker, the father of modern advertising: “Half the money I spend...
2014-02-24
1,038 reads
HealthySQL 2.0 for SQLSaturday#268
Over the last year, I was presenting and touring the SQL Saturday circuit with my HealthySQL 2.0 presentation. HealthySQL is...
2014-02-24
1,195 reads
Challenges with Downgrading TFS 2010 from SQL Enterprise to SQL Standard Edition
I recently had the challenge of migrating an installation of Microsoft Team Foundation Server 2010 from a shared SQL Server...
2014-02-27 (first published: 2014-02-24)
2,902 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