The Side Project
When I first started working as a technologist some 17 years ago, I was doing fairly low-level stuff: moving and...
2017-01-11 (first published: 2017-01-04)
1,361 reads
Tim Mitchell
ETL Error Handling
In designing a proper ETL architecture, there are two key questions that must be answered. The first is, “What should...
2016-12-28
767 reads
Survey Results: Skipping the Holidays
Last week I posted a brief survey about working the holiday. To those who normally are not required to work...
2016-12-27
379 reads
Survey: Skipping the Holidays?
For a little pre-holiday fun, I’ve got a simple scenario to present to you, and I am interested in your...
2016-12-23
378 reads
SSIS Custom Logging Levels
In my ongoing series on ETL best practices, I recently wrote about the importance of logging in extract-transform-load processes. For...
2016-12-22
482 reads
KPIs in SSRS 2016
Key performance indicators, or KPIs, are at-a-glance metrics for simple insight into the business. These are each designed to provide...
2016-12-30 (first published: 2016-12-22)
1,746 reads
Report Portal in SSRS 2016
SQL Server Reporting Services benefits from a major update in SQL Server 2016, which is obvious from the first interaction...
2016-12-20
566 reads
The Trails We Leave
Over the weekend I got an email from have i been pwned, a website that tracks data breaches and notifies...
2016-12-19
349 reads
SSRS 2016: Great and Getting Better
Although I’ve been a regular user of SQL Server Reporting Services since it was released in the mid-2000s, I’ve done...
2016-12-18
414 reads
SSIS Execution Status Lookup
The SSIS catalog comes packaged with a rich set of built-in reports that give those monitoring Integration Services a window...
2016-12-17
413 reads
Blogs
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Forums
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Having a Little Fun at SQL Server Central
Comments posted to this topic are about the item Having a Little Fun at...
Designing SQL Server Pipelines That Are Ready for AI Before You Actually Need AI
Comments posted to this topic are about the item Designing SQL Server Pipelines That...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers