SQL Server 2019 New Performance Features
SQL Server 2019 has introduced several new features that offer improved performance. The optimizer continues to evolve and get smarter.
2020-04-29
Articles
Your First Pipeline with Azure Data Factory
Learn how to build your first Azure Data Factory Pipeline
2020-04-28
9,237 reads
Getting Started with CQRS – Part 3
Diogo Souza completes his series on CQRS. He demonstrates Event Sourcing to capture the data as it flows through the system which can then be analyzed without affecting the source.
2020-04-28
A Pattern Based Approach to Masking Errors
A few years ago I had a requirement to allow both developers and customers to see rows from a table used to store error information while making sure that any PII, PCI or similar sensitive data was not displayed. The tolerance for “oops” was low! This article presents one way to solve the challenge by […]
2020-04-27
1,764 reads
SQL Monitor Roadtrip: Preparation
Setting up SQL Monitor without a bit of preparation work is a bit like embarking on a road trip without first learning to drive. Phil Factor show the essential kit and route maps you need for the journey.
2020-04-27
Tracking Underlying Object Changes in Views
Views in SQL Server are used to simplify writing queries and managing security, but’s it’s easy for views to eventually get out of sync with the underlying tables. In this article, Edward Pollack shows how to overcome this problem.
2020-04-27
Representing XML data in SQL Server
In this article, we will see how to use the FOR XML statement in SQL Server to represent the result of queries in XML format.
2020-04-24 (first published: 2018-08-07)
6,694 reads
Creating or Altering an Objects with a Single Statement
Do you get tired of having your CREATE PROCEDURE statement failing if the stored procedure already exists? If you are like me then you probably hate this as much as I do.
2020-04-24
What Percent Complete Is That Index Build?
SQL Server 2019 has introduced several new features that offer improved performance. The optimizer continues to evolve and get smarter.
2020-04-23
What’s changed for database monitoring this year?
Have your say on the state of database monitoring in 2020. In this latest blog, Redgate’s Jamie Wallis reviews what we discovered from last year’s survey and how you can define the insights for 2020. Tell us and you can get early access to the report plus be entered for a chance to win a $500 Amazon voucher. Read the blog to find out more:
2020-04-22
Blogs
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
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...
Forums
String_agg not working as needed
I'm trying to get this string_agg to put all the 'comments' into one result...
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
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