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.

Don't Lose Data Without a Hacker

by Steve Jones

SQLServerCentral

Security

Data loss shouldn't come from simple misconfiguration. As Steve notes, if no hacking is involved, you shouldn't lose data.

Restore SQL Server database using data management provider REST API

by Pablo Echeverria

SQLServerCentral

Learn how to restore sql server database using data management provider Rubrik REST API

Build and fill a SQL Server Database using SQL Compare CLI and a Batch Script

by Phil Factor

SQLServerCentral

Phil Factor provides a powerful DOS batch script which, when coupled with SQL Compare CLI, allows you to build databases from source, during development, and fill them with the specific datasets required for testing.

Verifying Object Exists and Dropping Object with One Statement

by Additional Articles

Database Journal

For years you probably have been writing code similar to the code below to verify an object exist prior to dropping it.

SQL Is Always Going to be Popular

by Steve Jones

SQLServerCentral

Career Growth

Steve thinks that learning more about the SQL language is always a good career investment.

SQL Server Extended Properties: Stairway to Exploring Database Metadata Level 7

by Phil Factor

SQLServerCentral.com

In this level, I’ll introduce Extended Properties. As with the previous levels, I want to illustrate as much as possible with practical and immediately useful code.

Never Create Columns with ANSI_PADDING set to OFF

by Site Owners

SQLServerCentral

There is no good reason for having ANSI_PADDING set to OFF when you create tables in SQL Server. It was provided purely for legacy databases that had code that assumed the old CHAR behavior for dealing with padding, and its use has now been deprecated.