Storage 101: Monitoring storage metrics
Well tuned storage is essential for SQL Server performance. In this article, Robert Sheldon explains the metrics that are important to watch.
2020-11-10
Articles
Finding the Free Space Difference Between Availability Groups Replicas
When was last time you have checked your Always On Availability Groups' replicas storage distribution?
2020-11-09
2,151 reads
Meet Redgate at PASS Virtual Summit
Redgate are Gold sponsors of PASS Virtual Summit, which this year is available to all online. It's time to accelerate your data career by joining Redgate's Advocates who will be presenting a variety of sessions, as well as demo solutions throughout the week of 11 - 13 November. See what's happening and register today.
2020-11-09 (first published: 2020-11-03)
SSRS Dynamic Row-Level Security with Recursive Hierarchy Group
In this article we walk through how to build a SQL Server Reporting Services report based on database level security settings by user to show different results to each user that runs the report.
2020-11-09
Service Broker Part 1: Service Broker Basics
This article covers SQL Server 2008 Service Broker, an asynchronous messaging framework that is directly integrated within the relational engine of SQL Server. The series will provides you with the basics about implementing Service Broker applications and how you can transparently scale them out to support any required workload.
2020-11-06 (first published: 2019-04-15)
61,715 reads
Format your own SQL code using this free online formatter
Redgate have launched their very own Online SQL Formatter powered by SQL Prompt. Visit the page here to try formatting your SQL code with a few pre-defined styles, or find out how to create and share your own styles with SQL Prompt.
2020-11-06 (first published: 2020-10-30)
How to Build a Cost Effective Virtual Desktop for Your Remote Teams
In this article we look at how you can easily build virtual desktops that you can deploy to your teams using Amazon WorkSpaces.
2020-11-06
Questions about SQL Prompt you were too shy to ask
Phil Factor answers some questions you've been itching to ask about SQL Prompt, covering ranked code completion suggestions and auto-fixing SQL code smells, and suggesting where in the tool to find other nuggets of hidden treasure.
2020-11-06
Automate MSBI deployments Using PowerShell
There are various ways we can deploy MSBI project deliverable. This article will give you an idea to automate MSBI deployments using Windows PowerShell.
2020-11-05 (first published: 2020-10-10)
2,900 reads
Git Anatomy
In this article, Dino Esposito gives an overview of git explaining repository, commit, and branch.
2020-11-05
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
Marketing
I’m trying to connect ideas from different marketing articles to get a bigger picture....
Marketing
I was reading several marketing articles and comparing different sources to understand the bigger...
What is Page Density
Comments posted to this topic are about the item What is Page Density
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