SQL Server T-SQL CASE Statement Examples
This tip will teach you when and how you can use CASE in T-SQL statements with several code examples to give you a better understanding.
2021-05-14
Additional Articles
Your Top 10 Ideas for SQL Server
You’ve submitted thousands of bug reports and feature requests at feedback.azure.com. Brent Ozar goes through what you’ve voted as the top 10 requests right now.
2021-05-14
Automating Azure DevOps with Logic Apps
Azure Logic Apps can be used to automate steps like sending approval emails. Elie Bou Issa explains automating Azure DevOps with Logic Apps.
2021-05-12
Take our survey to win a $500 Amazon gift card
Take the 2021 State of Database Monitoring survey and tell us about how you monitor your databases, instances and servers. By taking the survey, you’ll contribute to (and get early access to) the leading industry-wide report on database monitoring, and be entered to a prize draw for a $500 Amazon gift card.
2021-05-12
Running Dynamic Code Quality Checks on Flyway Databases: Table Smells
How to extend the range of SQL code analysis, during database development, to include dynamic analysis of the database metadata. This will allow regular checks for problems with the design of your tables and indexes ("table smells") that can affect database performance and data integrity.
2021-05-10
SQL Server Sequence Numbers
In this tip we look at the Sequence Number feature in SQL Server and compare it to the use of identity columns.
2021-05-10
DevOps as a bludgeon
With both personal experience and the real world evidence to back it up, Grant Fritchey says, unequivocally, a well-implemented DevOps process helps the organization. But it's not always easy to bridge a siloed organization, and sometimes organizations adopt DevOps for the wrong reasons.
2021-05-07
Getting Started with MLflow in Azure Databricks
In this article we cover how to get started with MLflow using Azure Databricks which manages the end-to-end machine learning lifecycle.
2021-05-07
Finding Dependencies in SQL Server Databases using SQL Dependency Tracker
Before you alter a database object, you need to understand what other objects will be affected. This article shows how to generate a simple dependency diagram that reveals both those objects that reference the target object, and those referenced by it, and includes foreign key references, column references and all the other details you need.
2021-05-05
Insurance price prediction using Machine Learning (ML.NET)
In this article, Chandra Kudumula shows how to use ML.NET to train a model for predicting costs from an insurance dataset.
2021-05-05
Blogs
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers