In my last post in the ETL Antipatterns series, I wrote about the common antipattern of ingesting or loading more data than necessary. This brief post covers one specific...
2020-12-14
40 reads
Recently I had a client that wanted to know how they could use SQL Compare to catch actual changes in their code, but not have comments show up as...
2020-12-14 (first published: 2020-12-02)
214 reads
G’day, I was asked recently what a modern data warehouse is – and that’s a vey thought provoking question. First, there’s the tag “Modern” – I think what’s modern...
2020-12-14
18 reads
In my continuing series on ETL Antipatterns, I’ll discuss the problem of loading too much data in extract-transform-load processes. ETL Antipattern: processing too much data A common design flaw...
2020-12-13
13 reads
In this first post in my series on ETL Antipatterns, I’m going to discuss one of the most common missteps when building an extract-transform-load (ETL) process: jumping straight into...
2020-12-12
29 reads
We’re rounding the corner to the second half of December, which means it’s time for my favorite holiday: Festivus! Like many of you, I enjoy gathering around the Festivus...
2020-12-12
6 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Recently I saw Jason Horner do a presentation...
2020-12-11 (first published: 2020-11-30)
557 reads
A project I’ve been meaning to work on for a while has been to build my own Kubernetes cluster running on Raspberry Pis. I’ve been playing around with Kubernetes...
2020-12-11 (first published: 2020-11-30)
558 reads
I know that this isn’t the correct name, though the by-laws still list this as the corporation. Perhaps this is one more sign of the failure to evolve and...
2020-12-11
47 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-12-11
30 reads
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Comments posted to this topic are about the item Database security permissions save script
I have a SQL Agent job for backing up a set of Analysis Services...
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers