SQL Monitor 10 packs a lot more under the hood in terms of connectivity, establishing cause-and-effect, and alerting. This article provides the high-level tour of the features we've introduced or improved, and why.
2020-03-20
MidnightDBA and Red Gate have joined together to produce a new book on SQL Server, written by 15 first-time authors. The resulting book, TribalSQL, includes everything you should know about SQL Server that isn’t taught in traditional training, they call it Tribal knowledge.
2019-03-26 (first published: 2013-09-18)
438 reads
This article from Tony Davis describes how to the use the Redgate SQL Compare and SQL Data Compare GUIs to get the current version of a database schema, and its static data, into version control, and then automate database deployments from the version control system using SQL Compare's command line and PowerShell.
2017-05-26
4,474 reads
For many years now we always seem to have been on the verge of the revolution in object databases, without it ever quite transpiring. Why is this?
2017-02-21 (first published: 2009-06-17)
740 reads
Tony Davis on why the dusty corners of many organizations still hide numerous SQL 2005 instances.
2015-04-20
139 reads
The next time you are tempted to hammer a performance problem with hardware, why not instead invest that time in hammering and refining your SQL queries? There are rich rewards to be had.
2014-12-26 (first published: 2009-11-02)
539 reads
Source control can and should play a key role in the database development and deployment process, and this book will show you exactly how to get started.
2014-11-11
573 reads
Source control can and should play a key role in the database development and deployment process, and this book will show you exactly how to get started.
2014-11-11
1,912 reads
There is a paradox in the nature of the abstractions that many developers want when dealing with databases. They will strain at the gnat, but swallow a camel (Matthew 23:24). Whereas they will recoil with horror when a DBA suggests that an abstraction layer based on views, functions and procedures in a separate database schema […]
2014-09-15
184 reads
Backing up MongoDB is akin to backing up SQL Server databases with a Windows tool such as Microsoft DPM. It removes almost all control over the database backup, and more critically, the database restore operation.
2014-02-03
299 reads
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
By Brian Kelley
I refresh my test SQL Servers at least monthly with a fresh VM. Setting...
By Chris Yates
Embracing Total Responsibility In every organization there comes a moment when teams must choose...
We have created a parent table, child table & Audit log table in SQL...
Comments posted to this topic are about the item Change Tracking Default Retention
I am trying to create a subscription that posts to a one drive directory. ...
I run this command on my SQL Server 2022 database:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;What is the default data retention period? See possible answers