Find Unused or Backup Tables
If you rename old or backup tables, learn how to find easily find and drop them.
Protecting Off Hours
There is new legislation in Australia that is supposed to allow employees to ignore messages outside of working hours. Steve has a few thoughts on how he balances his workload.
Correct SQL Server Transactional Replication Issues with T-SQL and SSMS
Learn how to address SQL Server transactional replication issues with these easy-to-follow steps using T-SQL and SSMS to troubleshoot and fix issues.
Give It Away
Tech conference season is in full swing, and it’s only the middle of March. Between Grant, Steve, and I, we’ve attended or presented at about 10 events so far. And within my community of developers and database folks, I’ve seen pictures and posts of many more. As I’ve said a few times in previous editorials, […]
Growing Skills at Work
We all need to grow our skills at work. It can be challenging, but we can find ways, as well as advocate to management that resources are needed.
The difference between BIN2 and Case-Sensitive collations in SQL
Here you will learn about the key differences between the binary and SQL/Windows collations. You will see that even with all sensitivity flags enabled, SQL/Windows collation cannot behave the same way as the binary collations.
Automating BCP with PowerShell
I was talking with a good friend that has an environment with terabytes of information and to create a homolog or dev environment to him is a pain. He comes to me with a solution : A PowerShell script that gets only the first 1000 lines of each table, creates the inserts and schema files
Navigating the Database Landscape
Today Steve has a few thoughts on his keynote topic today at the Redgate Summit.
Stairway to Advanced T-SQL Level 2: Using the APPLY Operator
The APPLY operator allows you to join a record set with a function, and apply the function to every qualifying row of the table (or view). The APPLY operator takes on two formats: CROSS APPLY, or OUTER APPLY. This article will explain the differences between these two formats, and show you examples of how each of these formats work.
SQL Server to PostgreSQL Database Schema Conversion
In this tip, I will demonstrate how to migrate an existing database schema from SQL Server to PostgreSQL.
Blogs
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...
Post-quantum key exchange – Insurance policy for your packets
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Forums
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
Encoding URLs
Comments posted to this topic are about the item Encoding URLs
An SSIS Upgrade
Comments posted to this topic are about the item An SSIS Upgrade
Question of the Day
Encoding URLs
I have this data in a 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