Knee-Jerk Performance Tuning: Incorrect Use of Temporary Tables
Paul Randal continues his knee-jerk performance tuning series, focusing on ways to optimize performance when using temporary tables.
2016-04-25
6,231 reads
Articles
Automatic SSRS report output of all report parameter combinations
You already have a SQL Server Reporting Services (SSRS) sales report that takes parameters for Country and State. Each time the report is run a user selects the specific Country and State for the report. A request has been made to deliver one report via email that includes all of the combinations for each country and state. Daniel Farina shows how to achieve this without modifying the report.
2016-04-22
4,408 reads
Migrating an on premise SQL Server Database to Azure
For this article I want to show you how to import a BACPAC file to create a new Azure SQL Database which is Microsoft’s Platform as a Service(PaaS) offering.
2016-04-21
1,727 reads
Database Version Control
By placing under source control everything we need to describe any version of a database, we make it much easier to achieve consistent database builds and releases, to find out who made which changes and why, and to access all database support materials. Matthew Skelton explains how to make sure your version control system fully supports all phases of the database lifecycle, from governance, development, delivery and through to operations.
2016-04-21
4,275 reads
Getting Started Tuning Performance in Azure SQL Database
Tim Radney talks about the initial differences he has encountered while mastering the art of performance tuning Azure SQL Database.
2016-04-20
3,285 reads
2016-04-19
5,017 reads
What Does the Near-Future of PowerShell & SQL Server Look Like? An Interview with Ken Van Hyning
Ken Van Hyning is the Engineering Manager for the SQL Server tools, including SQLPS.
2016-04-19
1,653 reads
Row Level Security with SQL Server 2016
Have you ever wanted an easier way to provide security at the record level? If so, you can now easily do this with the Row Level Security feature that is being introduced with SQL Server 2016. Greg Larsen shows you how easy it is to use this new feature as a way to provide user access to a specific set of records.
2016-04-19
4,714 reads
Exporting Azure Data Factory (ADF) into TFS Source Control
Have you created a Data Factory in Azure and are wondering how to get it into TFS and source control? This article will show you how.
2016-04-18
4,090 reads
SQL Server System Functions: The Basics
Every SQL Server Database programmer needs to be familiar with the System Functions. These range from the sublime (such as @@rowcount or @@identity) to the ridiculous (IsNumeric()) Robert Sheldon provides an overview of the most commonly used of them.
2016-04-18
6,053 reads
Blogs
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Startup scripts in SQL Server containers
I was messing around performing investigative work on a pod running SQL Server 2025...
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Forums
What is Page Density
Comments posted to this topic are about the item What is Page Density
T-SQL in SQL Server 2025: Fuzzy String Search II
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Question of the Day
What is Page Density
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers