ETL Data Lineage
Before I began my technical career over a decade and a half ago, I spent several years working in law...
2016-05-06
1,273 reads
SQL Server 2016 - Launch Get Ready
You've been waiting, you've been asking, some begging to know the magic date of when Microsoft's SQL Server 2016 will...
2016-05-06
1,151 reads
ALTERNATIVE TO DISABLING A SQL JOB STEP (FOR SSIS PACKAGES)
For relational data-warehouses where you have the data load scheduled during off hours, timing of different steps in a sql...
2016-05-06
1,303 reads
SQLCover v 0.2 - Bug fixes and Azure V12 Support
I have released a new version of SQLCover which is a code coverage tool for T-SQL (let's you identify where...
2016-05-05
601 reads
SQLCover v 0.2 - Bug fixes and Azure V12 Support
I have released a new version of SQLCover which is a code coverage tool for T-SQL (let’s you identify where...
2016-05-05
27 reads
SQLCover v 0.2 - Bug fixes and Azure V12 Support
I have released a new version of SQLCover which is a code coverage tool for T-SQL (let’s you identify where...
2016-05-05
46 reads
SQLCover v 0.2 - Bug fixes and Azure V12 Support
I have released a new version of SQLCover which is a code coverage tool for T-SQL (let’s you identify where...
2016-05-05
46 reads
SQLCover v 0.2 - Bug fixes and Azure V12 Support
I have released a new version of SQLCover which is a code coverage tool for T-SQL (let's you identify where you need to focus when writing tests).
This includes a...
2016-05-05
7 reads
Optimization with temp tables – Example
The code optimization is a mandatory task for the programmable objects in SQL Server. During time some code can start working “badly” i.e. become slow. In that case a...
2016-05-05
11 reads
Optimization with temp tables – Example
The code optimization is a mandatory task for the programmable objects in SQL Server. During time some code can start working “badly” i.e. become slow. In that case a...
2016-05-05
8 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Split Large Queries in Athena with a Simple Modulo Trick
Comments posted to this topic are about the item Split Large Queries in Athena...
Question of the Day
RegEx Functions IV
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', 'i') AND BusinessEntityID IN (7,8)See possible answers