Managing, Editing and Comparing SQL Code Analysis Settings
If you need to manage multiple code analysis settings files, per team or database, you'll want a good way to document and manage the files, and to compare two files to see what changed.
SQL Server High Availability and Disaster Recovery Plan
Microsoft provides quite a few features for high availability and disaster recovery. In this article, Priya describes the HA/DR options.
Do as I say, not as I do
Steve wishes that Microsoft would follow some of their own advice on SQL Server development in their other software.
Merge Multiple Files in Azure Data Factory
A short tutorial on how to combine multiple files together in an Azure Data Factory Copy Data activity.
Typical uses of Oracle sequences
Oracle sequences supply unique numbers that can be used when populating tables. In this article, Jonathan Lewis explains the typical uses of Oracle sequences.
Using Data Scanning to Identify and Classify Sensitive Columns
SQL Data Catalog's new data scanning feature uses regular expressions and data dictionaries to identify where sensitive and personal data is stored in your databases.
Interconnected Temp Files
Links between systems can become a problem if an issue in one system affects the others.
Working with Azure IoT Central
Gathering data from sensors and Internet of Things (IoT) devices is becoming more and more common in many organizations. This introductory article shows how you can get started with IoT Central in Azure.
Beautify HTML Tables in Emails for SQL Database Mail
In this article we look at how to format HTML tables sent via SQL Server Database Mail to make the emails and data easier to read.
Overcoming Database DevOps challenges - Part 1
When integrating database changes into a DevOps process, the biggest challenge is to standardize and coordinate the different approaches to application and database development. Discover the key tools & training resources to help you and your team.
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
"Click" your SQL Server into an MCP agent, with RBAC and full security
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers