SSIS Web Service Task
The Web Service task in SSIS can be used to call a web service command to perform a needed operation...
2014-03-31
956 reads
SSIS Web Service Task
The Web Service task in SSIS can be used to call a web service command to perform a needed operation...
2014-03-31
4,689 reads
2014-03-31
1,566 reads
SQL 2014 Release Date, April 1st
I'm not a fan of anything releasing on April Fool’s Day, but that's not for me to decide. I personally...
2014-03-31
1,791 reads
SQL Server 2014 RTM
The new version of SQL Server will be here on Tuesday.
(Someone at Microsoft has a sense of humour in releasing...
2014-03-30
1,514 reads
Calendar Tables in T-SQL
In an earlier blog, we covered a type of auxiliary table (the Tally Table) that can provide a lot of...
2014-03-30
32,871 reads
South Alabama Day of .NET Presentations Downloads
I have been running into longtime SQL Saturday friend Ryan Duclos at SQL Saturday events in Baton Rouge and Pensacola...
2014-03-29
1,196 reads
Houston SQL Saturday #308 – Presenting
Saturday May 10th – Houston SQL Saturday #308
I will be presenting at the upcoming SQL Saturday in Houston on May10th. For...
2014-03-29
1,219 reads
T4 Support in SSDT
Sometimes a piece of technology passes you by completely, T4 templating happens to have done that for me. On tuesday night,...
2014-03-29
1,158 reads
All in Fun
My first commercial!
Steve on a HorseThis comes from our DBA Team promotion, which is ongoing this year.
Filed under: Blog Tagged:...
2014-03-28
1,442 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