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 ...

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 ...

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 ...

Querying and updating an SQL database, PHP script for updating. Getty. SQL, or the structured query language, is a specialized programming language designed for working with databases.

During the last few articles, we have covered the basics of working with SQL server using the Server Management Objects (SMO) and PowerShell. We have covered things such as viewing the state of ...

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.