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,155 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)
62,032 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,902 reads
Git Anatomy
In this article, Dino Esposito gives an overview of git explaining repository, commit, and branch.
2020-11-05
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
Vectors in SQL Server 2025
Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences
Comments posted to this topic are about the item Odd Sequences
Everything is the right question away
Comments posted to this topic are about the item Everything is the right question...
Question of the Day
Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers