How to Restore Files and Filegroups Using T-SQL. Alternatively, you can use the T-SQL commands to restore a database file or filegroup. RESTORE DATABASE [Northwind] FILE = N'Northwind' FROM DISK = N'C ...

There are lots of ways to create SQL databases, but especially in Azure, there's a much better way that doesn't include knowing a bunch of PowerShell commands and parameters.

Sample SQL Scripts and Tuning Tips. This appendix provides supplemental information to aid in setup, maintenance, and tuning of a spatial database. The scripts and tuning suggestions provided are ...

Elastic Jobs is specific to Azure SQL Database and allows you to execute T-SQL across a group of databases. This feature is still in preview of this writing, but it was introduced in 2015, so it ...

Database monitoring at Express Scripts is a combination of native and platform specific tools, Mertz said. Where native tooling is not available, the company does custom scripts. However, there are ...