Learn how to use the Azure Portal to create a cloud-based SQL database with just a few mouse clicks.

When you need a SQL database fast, the cloud is the best way to go. Azure provides a SQL database as a PaaS that eliminates the need to get an entire SQL Server deployment up and running.

The New-AzureRmResourceGroupDeployment command has a TemplateParameterObject parameter where we can pass in the values to create our SQL database. Assuming that: ...

Creating a new table from query results can help you build a database of your clients, employees, expenses and other business details by allowing you to select certain columns from existing tables.

Missing Indexes Dynamic Management Views SQL Server includes a set of dynamic management views which tell you what indexes the SQL Server database engine thinks need to be added.

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