Constant Integration
Apple buys a company every few weeks. The data integration for this must be a large effort.
Datatypes and the Default Mask with Dynamic Data Masking - Step 2 of the Stairway to Dynamic Data Masking
This article digs deeper into the ways that Dynamic Data Masking works with different data types.
What is interpolation?
In this article, Joe Celko explains interpolation and covers a bit about the history and what we all did before computers.
Generating Art
Using metadata to drive software is very useful, which means that having clean data and lots of metadata can help create better software.
Building reusable table build scripts using SQL Prompt
You need a fast, general-purpose way to save the results of a query or batch or procedure into any sort of worktable, such as a temporary table or a table variable or table valued parameter. A simple SELECT…INTO isn't versatile enough for these requirements, and the alternative ways to handcraft the list of columns are slow and error prone. Phil Factor shows how to create a 'table-build generator' that will do all this, and save you a lot of time, especially if you use a lot of working tables in your code.
Using Kerberos Configuration Manager for SPNs Validation
Learn how to manage and troubleshoot Kerberos authentication for SQL Server using the Kerberos Configuration Manager.
How Quickly We Forget
One of the interesting things about modern software is how updates are handled.
System-Versioned Temporal Tables - A Case Study
A short look at temporal tables and how to deal with the system generated historical tables.
Combine Multiple SQL Server Query Results with Registered Servers
Learn how to configure and use SQL Server Management Studio to do run the same query against many different SQL Servers and consolidate the results.
Customizations in SQL Prompt
In this brand new course on the Redgate University Grant Fritchey walks you through the many ways in which SQL Prompt can be customized to suit your specific needs.
Blogs
Local LLM Models at SQL Saturday Boston 2025
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
3 things you must do to start data quality management right
As a data & AI strategist who’s seen countless projects succeed and fail, I...
Set Theory vs. Batch Mode in SQL Server
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Forums
Changing the Recovery Time
Comments posted to this topic are about the item Changing the Recovery Time
Getting More Time from AI
Comments posted to this topic are about the item Getting More Time from AI
When Page Prefetching Takes a Back Seat – Exploring Trace Flag 652 in SQL Server
Comments posted to this topic are about the item When Page Prefetching Takes a...
Question of the Day
Changing the Recovery Time
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers