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.
When Do We Ask for Help?
When do we ask for help? It's a tough balance to strike between asking too soon or waiting too long.
Power BI Smart Narrative
A new feature in Power BI is the Smart Narrative that allows you to add a textual narrative to your reports to help provide additional information to the user.
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