Approaches to Import JSON in SSIS (SQL Server 2016+) Part 2
In this article, 2nd of 2-part series, we will look at the 3rd approach to import JSON, recap both parts of the series and form a conclusion.
What's the Cost of an Hour?
Outages can be expensive, and today Steve asks if you know just how expensive they are for your organization.
Free Fundamentals of Index Tuning Week: Part 3, Indexing for Joins
Previously we covered Part 1: Indexing for the WHERE Clause, and then we covered ORDER BY. Today, let’s tackle joins.
What’s New in SQL Monitor 10?
SQL Monitor 10 packs a lot more under the hood in terms of connectivity, establishing cause-and-effect, and alerting. This article provides the high-level tour of the features we've introduced or improved, and why.
Don't Lose Data Without a Hacker
Data loss shouldn't come from simple misconfiguration. As Steve notes, if no hacking is involved, you shouldn't lose data.
Restore SQL Server database using data management provider REST API
Learn how to restore sql server database using data management provider Rubrik REST API
Build and fill a SQL Server Database using SQL Compare CLI and a Batch Script
Phil Factor provides a powerful DOS batch script which, when coupled with SQL Compare CLI, allows you to build databases from source, during development, and fill them with the specific datasets required for testing.
Verifying Object Exists and Dropping Object with One Statement
For years you probably have been writing code similar to the code below to verify an object exist prior to dropping it.
SQL Is Always Going to be Popular
Steve thinks that learning more about the SQL language is always a good career investment.
SQL Server Extended Properties: Stairway to Exploring Database Metadata Level 7
In this level, I’ll introduce Extended Properties. As with the previous levels, I want to illustrate as much as possible with practical and immediately useful code.
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
Where Your Value Separates You from Others
Comments posted to this topic are about the item Where Your Value Separates You...
Fixing the Error
Comments posted to this topic are about the item Fixing the Error
T-SQL in SQL Server 2025: Encoding Functions
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Fixing the Error
On SQL Server 2025, I have a database that has this collation: SQL_Latin1_General_CP1_CI_AS. I decide I want to run this code:
SELECT UNISTR('*3041*308A*304C*3068 and good night', '*') AS 'A Classic';
I get this error:Msg 9844, Level 16, State 4, Line 24 The char/varchar input type uses an unsupported collation. Only a UTF8 collation is supported with char/varchar input type in UNISTR function.What is the easiest way to fix this error? See possible answers