We’re sharing the results of our State of Database Monitoring survey in four insights reports this year – and the second one is out now. In The value of a monitoring tool for the entire organization you’ll learn why more businesses than ever are using a monitoring tool and how doing so can help the entire business to reduce costs, enhance security and collaborate more efficiently. DBAs - download a copy and send it to your boss, today!
2021-10-11
2021-10-08
2,280 reads
In this article we cover how to implement a batch Databricks Change Data Feed process through an end-to-end exercise.
2021-10-08
This video demonstrates a set of queries for estimating data compression savings in SQL Server. It also covers how to make an informed decision on whether data compression makes sense for your data and workload or not.
2021-10-08
Learn about the various ways to use the GROUP BY command to summarize and rollup query results. We look at the basics with examples as well as using group by rollup, cube and grouping sets.
2021-10-06
Join Kevin Davis, DBA Manager at Tower Loan to hear their playbook for successful distributed estate monitoring, and the role of SQL Monitor.
2021-10-06
This article looks at moving data in three related tables to Azure SQL Database using the change tracking feature in SQL Server to determine which rows have been changed.
2021-10-04
8,099 reads
Extended Events have been part of SQL Server since 2008. In this article, Ed Pollack explains the building blocks of Extended Events data collection.
2021-10-04
Microsoft Data Platform MVP Glenn Berry demonstrates a set of eleven SQL Server Diagnostic Memory Queries that help you understand your memory usage in SQL Server.
2021-10-04
Introduction According to the official documentation, the READ COMMITTED isolation level “specifies that statements cannot read data that has been modified but not committed by other transactions”. So, one could think that a record returned under this isolation level existed in the committed state at the time of reading. In this article, I am going […]
2021-10-01
2,160 reads
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Comments posted to this topic are about the item The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers