Metadata Hygiene
Those who follow my blog know that I write a lot about data quality. Measuring and improving the quality of...
2017-03-09
416 reads
Tim Mitchell
Loading to Azure from On-Prem SSIS
In my introduction to the topic of using SSIS in the cloud, I noted that SSIS is not currently available...
2017-03-02
425 reads
The Psychology of Value
J.C. Penney is one of the oldest and most storied retailers still in existence in the United States. For years,...
2017-03-02
378 reads
Is Your Database App Ready for the Cloud?
The cloud has evolved. Just a few years ago, cloud-based applications were the exception rather than the rule, and on-premises...
2017-03-03 (first published: 2017-02-24)
2,205 reads
Digital Privacy is the Wild West
Who has the legal right to access your personal and private digital assets? The answer can be complex, and will...
2017-02-27 (first published: 2017-02-23)
1,498 reads
Managing Bad Data
In the last post in my ongoing series about ETL best practices, I discussed the importance of error handling in ETL...
2017-02-21 (first published: 2017-02-16)
2,205 reads
Retrieve a List of Files from FTP using SSIS
The FTP protocol is one of the oldest methods for sharing and moving files. Although frequently considered to be an “old-school”...
2017-01-27 (first published: 2017-01-20)
1,506 reads
Upcoming Class: Building Better SSIS Packages in Pensacola
I’ll be teaching my popular day-long course, Building Better SSIS Packages, on Thursday, June 1 in Pensacola, Florida. This class...
2017-01-17
366 reads
Why Data Warehouse Projects Fail
Data warehouse projects are among the most visible and expensive initiatives an organization can undertake. Sadly, they are also among...
2017-01-10
1,099 reads
What is ETL?
In my ongoing series on ETL Best Practices, I am illustrating a collection of extract-transform-load design patterns that have proven...
2017-01-16 (first published: 2017-01-06)
2,506 reads
Blogs
Setting PK Names in Redgate Data Modeler
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
A New Word: Fawtle
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
Forums
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers