The Subtle Differences Between COALESCE and ISNULL
See how ISNULL and COALESCE behave in different situations and ensure you know which one to pick when.
2025-04-18
91 reads
Articles
The State of the Database Landscape in 2025: Insights and trends
How are you navigating the database landscape? Our latest report sheds light on the current state of database management and offers valuable insights into how organizations can navigate and simplify the growing complexities of the database landscape.
2025-04-18 (first published: 2025-03-10)
Using the Default Trace in SQL Server
I have heard of the default trace in SQL Server. I know it’s on by default, but I don’t know how to use it. What can I do with the default trace?
2025-04-18
Metadata Driven Pipelines (Full Load): The Fabric Modern Data Platform
Learn how you can create a full data load process in Fabric.
2025-04-16
1,440 reads
2025-04-16
1,047 reads
Navigating Your Test Data Challenges: Insights and Solutions
Join Redgate on May 1st for an insightful webinar cohosted with analyst firm, Bloor Research, featuring independent Senior Analyst Daniel Howard and Redgate's Steve Jones. Discover the biggest test data challenges, the latest approaches like AI synthetic data generation, and how effective test data management can benefit your entire organization. Don't miss out on this opportunity to gain valuable insights and solutions.
2025-04-16 (first published: 2025-04-07)
Securing the DevOps Pipeline Part 1: Tools and Strategies for Safer Deployments
DevOps has transformed software delivery, but with rapid deployments come increased security risks. As a DevOps engineer, I’ve seen firsthand how small security oversights can lead to major vulnerabilities.
2025-04-16
Creating a Date Dimension (Calendar Table) in SQL Server
Learn how to create and populate a Date Dimension table in SQL Server
2025-04-14
2,618 reads
How to Remove Constraints from a SQL Server Table
I need to drop constraints on a number of my SQL Server tables. Most of our constraints are primary key and foreign keys, but there are other constraints too. How can we script it so it will deploy with a pipeline in a repeatable manner?
2025-04-14
Elements of the SQL Server Update Statement
Learn how to use the UPDATE statement, along with a few things to be aware of when changing data.
2025-04-11
1,377 reads
Blogs
SQL Server Wait Stats
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
FabCon 2025 Recap
By DataOnWheels
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...
Privacy Policy
We value your privacy. This policy explains what personal data we collect and why. What...
Forums
The Subtle Differences Between COALESCE and ISNULL
Comments posted to this topic are about the item The Subtle Differences Between COALESCE...
SQL Server Collations
Comments posted to this topic are about the item SQL Server Collations
Why would using a variable vs Hard Value impact a Query's Performance
Why would using variables in place of hard coded numbers impact a query's performance? ...
Question of the Day
SQL Server Collations
At what levels can we set the collation in SQL Server 2022?
See possible answers