Snowflake for SQL Server Developers - NULL Functions - Part 2
Learn about NULL functions that exist in Snowflake but not in SQL Server like NVL2, ZEROIFNULL, EQUAL_NULL, and IS_NULL_VALUE.
2023-03-06
Additional Articles
Creating Animated Line Plots with Python
Python has the ability to create many different types of charts and graphs and in this article, we look at how to create animated line plots with Python.
2023-03-03
How to Improve the Quality of Database Releases using Clones
This article explains how we can use the ephemeral, containerized databases delivered by Redgate Clone to increase database code quality and therefore the stability, reliability, and performance of the databases we release.
2023-03-03
Join Redgate at SQL Bits, March 15-18
From castles and dragons to sword fights and spells, this year’s SQL Bits will have it all. Make sure you don’t miss out on our great sessions, from Code Errors to Reliable Releases, to adding some PostgreSQL skills to your repertoire. Get 10% off registering with 10REDGATE
2023-03-01
Testing before coding: shifting farther left
A term I have only recently learned is "shift left testing." You can read more about this on Wikipedia here. The term was coined in 2001 and generally means testing earlier in the development lifecycle. Hence, shifting your testing left in the timeline. Just how left should you shift your testing, though? In my mind, so early, the rooster hasn't entirely fallen asleep yet.
2023-03-01
How to create a Sankey Chart in Power BI Desktop
Learn how to build and format a Sankey Chart using Power BI along with step-by-step instructions.
2023-02-27
The business value of frequent deployments
The multi-million-dollar question for you and your business is... what is the real business value of frequent deployments? Part one of three in this series on the value of database DevOps.
2023-02-27
Getting started with SSIS External Configuration File
This article illustrates how to use an SSIS external configuration file to enable the properties of package objects to be dynamically updated at run time.
2023-02-24
Join Redgate at SQL Bits, March 15-18
From castles and dragons to swordfights and spells, this year’s SQL Bits will have it all. Make sure you don’t miss out on our great sessions, from Code Errors to Reliable Releases, to adding some PostgreSQL skills to your repertoire. And come say “hi” to us at the Redgate booth, where we’ll have some news for you. Get 10% off registering with 10REDGATE.
2023-02-24
PostgreSQL Basics: Roles and Privileges
Information security, whether in databases, applications, or larger IT systems, is based on the principles of Authentication and Authorization, often referred to as AuthN and AuthZ respectively. Likewise, PostgreSQL security involves creating roles that allow access to server resources (AuthN) and then granting privileges to database objects appropriately (AuthZ). Understanding how each of these components work together is essential to effectively manage security in a PostgreSQL cluster.
2023-02-22
Blogs
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
Forums
Why End-User Testing Is Even More Important with AI
Comments posted to this topic are about the item Why End-User Testing Is Even...
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers