Learn how easy the new SQLServer module makes backups of SQL Server databases.

Backup Data Security

by Steve Jones

SQLServerCentral.com

Editorial

We need better security for our data, especially for our choices in managing data.

Identifying Last Night’s SQL Agent Job Failures

by Additional Articles

Database Journal

SQL Agent

Finding the nightly job failures is just one of a DBA's morning rituals. It is fairly easy to scan all the email with a number of creative search criteria, but what if you would like a more automated approach? Read on to learn how to find and report all job failures using a script.

Not Excited by Linux

by Steve Jones

SQLServerCentral.com

Editorial

Much of the community isn't excited by SQL Server on Linux.

Stairway to U-SQL Level 12: SQL.ARRAY and CROSS APPLY EXPLODE

by Mike McQuillan

SQLServerCentral.com

U-SQL introduces two new data types - SQL.ARRAY and SQL.MAP. Here, we look at what we can do with SQL.ARRAY and the CROSS APPLY EXPLODE expression.

SQL Server Database Provisioning

by Additional Articles

SimpleTalk

provisioning

Database provisioning for development work isn't always easy. The better that development teams meet business demands for rapid delivery and high quality, the more complex become the requirements for the work of development and testing. More databases are required for testing and development, and they need to be more rapidly kept current. Data and loading needs to match more closely what is in production. Grant Fritchey explains.