Performance Myths: Table variables are always in-memory
Guest author Derik Hammer dismisses the common myth that table variables perform better than temp tables because they are always in memory.
2017-05-11
5,730 reads
Articles
AlwaysON Availability Group and Jobs Part 1
In this article (consist from 2 parts) , I will be focusing on one of the practical solutions for management of internal SQL Server jobs in AlwaysOn Availability Groups scenarios.
2017-05-10
6,150 reads
2017-05-10
122 reads
SQL Data Mask: now featuring configurable masks
SQL Data Mask is the latest prototype to come out of Redgate Foundry. It copies your database while anonymizing personal data, and you can use it to mask your databases right now, free of charge. Here are the details.
2017-05-10
4,085 reads
Basic data masking for development work using SQL Clone and SQL Data Generator
This article describes a lightweight copy-and-generate approach for making a sanitized version of a production database available to development teams with SQL Clone and SQL Data Generator.
2017-05-08
3,810 reads
Deploying Multiple SSIS Projects via PowerShell
When there are several SSIS projects with packages in a SQL Server Database or Data Warehouse development, automated deployments as part of Continuous Integration can get tricky. Nat Sundar describes how he created a Deployment script that is intended to provision a Data Warehouse for System Integrated testing (SIT).
2017-05-08
5,786 reads
Azure Machine Learning - Your first experiment
In this chapter, we will show how to create a Machine Learning experiment from our Azure SQL Warehouse.
2017-05-05 (first published: 2016-06-14)
5,738 reads
Dude, where’s my database? Inventory management by Foundry
Have trouble keeping track of your SQLServer estate? Redgate Foundry are currently researching the area - here's what they've been up to, and how you might be able to help.
2017-05-05
2,873 reads
Exploring Azure Storage for SQL Server DBAs – Part 2
Managed Disks have simplified way that Azure storage interacts with the users' virtual machines, thanks to the way that it eliminates the need to deal with the Storage Account. It is now easier to add new disks to a virtual machine, either in PowerShell or via the portal. The Storage Spaces feature in Windows Server can be used to aggregate disks together and obtain higher levels of performance. Joshua Feierman explains how to do it all.
2017-05-05
4,376 reads
How to Move a Table to a Different File Group
There may be a time when you want to move a table from one file group to another. It's easy if it contains a clustered index. Read on to learn more.
2017-05-04
3,077 reads
Blogs
Overview of Claude AI Models: Which One to Choose?
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
Forums
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Spring Connections and Learning at PASS On Tour
Comments posted to this topic are about the item Spring Connections and Learning at...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers