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
A document search on a billion row "EAV" table is predicted to take 134 days. With a few design tweaks and an efficient relational division algorithm, Peter Larsson got it down to milliseconds.
2019-08-15 (first published: 2013-12-09)
1,507 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)
482 reads
Tony Davis on why the dusty corners of many organizations still hide numerous SQL 2005 instances.
2015-04-20
102 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)
522 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,802 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
282 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
167 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
181 reads
By James-Serra
Microsoft Ignite has always announced many new products and new product features, and this year...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
SQL Server is a complex beast, with many configuration options that can range from...
Hello, Looking for help combining two interval tables together. The tables are pretty simple......
Hi..How can do a loop statement for the following table first loop shld be...
Comments posted to this topic are about the item Azure SQL Managed Instance Features
Ask SSC