What is interpolation?
In this article, Joe Celko explains interpolation and covers a bit about the history and what we all did before computers.
2021-03-31
Articles
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.
2021-03-30
Using Kerberos Configuration Manager for SPNs Validation
Learn how to manage and troubleshoot Kerberos authentication for SQL Server using the Kerberos Configuration Manager.
2021-03-30
System-Versioned Temporal Tables - A Case Study
A short look at temporal tables and how to deal with the system generated historical tables.
2021-03-29
3,663 reads
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.
2021-03-29
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.
2021-03-29
2021-03-26 (first published: 2018-12-10)
13,476 reads
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.
2021-03-26
Why is my SQL Server Query Suddenly Slow?
A SQL Server query is suddenly running slowly, for no obvious reason. Grant Fritchey shares a 5-point plan to help you track down the cause and fix the problem.
2021-03-26
Hacking the DTSX (SSIS XML file) to Change Defaults
Introduction According to Microsoft, DTSX is an XML-based file format that stores the instructions for the processing of a data flow from its points of origin to its points of destination, including transformations and optional processing steps between the origin and destination points. In a nutshell, when you are creating your SSIS package, the SQL […]
2021-03-25
4,592 reads
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers