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

Microsoft's premade templates allows for the deployment of SQL databases without having to use complex PowerShell commands.

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.

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

Procedure to move Microsoft SQL Server database to a new location, painlessly, if you’re running low on disk space, added a new drive array, or just curious.

SQL development is evolving fast, and Microsoft.Build.Sql is leading the charge. This next-generation SDK brings flexible project structures, better source control integration, automated build-time ...

Figure 3. Your SQL Database Servers. Next, you'll need to create the rule to allow one or a block of IP addresses. If you'd like just to let the public IP address you are coming from (if the computer ...