The four tenets of ETL testing
Every ETL pipeline is only ever as reliable as the data that the upstream system provides. It is inevitable that assumptions you make about the data you are provided...
2020-03-06
15 reads
Blog Posts
Appearance: Data Bits #2
Last week (as I write this), Kevin Hill (blog | twitter) released the first episode of his new podcast Data Bits. I enjoyed listening to it and said “hey...
2020-03-05
4 reads
SQL Homework – March 2020 – Database Configurations.
A little while back we tried configuring the instance. Sometimes though, instance settings are a bit heavy handed, so this ... Continue reading
2020-03-05 (first published: 2020-03-02)
464 reads
Why can’t I remove this extra transaction log file?
Before this post gets started, let’s get past the title. I know what many of you are thinking: what in the name of Paul Randal would make someone have...
2020-03-05 (first published: 2020-02-29)
412 reads
Deprecated and discontinued features in SQL Server
My co-authors and I recently wrapped up the book SQL Server 2019 Administration Inside Out, which should be hitting the shelves in the next week or two. At the...
2020-03-04
91 reads
Import Databases to Azure SQL Database
I recently spoke at a conference and was asked what is the easiest way to import databases to Azure SQL Database. Therefore, I wanted to share how I do...
2020-03-04
14 reads
Information Measurement with SQL Server Part 4.8: The Intersection Family of Distances
By Steve Bolton …………Each group of distance measures surveyed in this segment of the series was defined by affinities between the underlying equations. For example, the common denominator for...
2020-03-04 (first published: 2020-02-27)
259 reads
Schema Filtering in SQL Prompt
I love SQL Prompt, and I’m regularly impressed by the enhancements our teams continue to make in the product. One item that I found interesting recently was schema filtering....
2020-03-04 (first published: 2020-02-27)
243 reads
VMware vExpert 2020
I’m proud to announce that I’ve been awarded the VMware vExpert community award for the calendar year 2020. I’m absolutely thrilled to be awarded this title for the eighth...
2020-03-04
6 reads
A lack of foreign keys – a bad culture example.
G’day,
One of the things that I’ve been seeing more often than I would like to lately is large databases with...
2020-03-03 (first published: 2018-10-28)
3,192 reads
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers