Data security in the cloud is of chief concern not only to healthcare and financial services, but anyone with sensitive data of any kind that should only be disclosed to authorized parties. No discussion of enterprise security would be complete without a look at data protection and governance. For purposes of this discussion, data comes … Continue reading “5 ways to secure your SQL data in Microsoft Azure”
Below for reference is a quick PowerShell sample for downloading and installing SQL Server 2016 Management Studio (SSMS). While this component used to be included in the SQL Server installer, it is now a separate download. Questions or comments? Use the comments section below.
In previous articles, I have demonstrated how to create Azure SQL Server and database instances via PowerShell in: How to Create an Azure SQL Instance via PowerShell How to Create an Azure SQL Database via PowerShell Certainly you could create both your Azure SQL Server instance and the database in the Azure Portal, so do … Continue reading “How to Query Azure SQL Databases via PowerShell with SMO”
As I mentioned yesterday in “How to Create an Azure SQL Instance via PowerShell“, Azure SQL provides some cost advantages over running SQL in Azure VMs for scenarios where all you need is a database. In yesterday’s article, we created an Azure SQL database instance, as well as a firewall rule on the instance to … Continue reading “How to Create an Azure SQL Database via PowerShell”
I wanted to share a bit about Azure SQL (PaaS) in Azure, as I believe it will commonly used by IT Pros in the future, particularly as a logging and reference databasew when working with Azure Automation. One compelling reason to Azure SQL instance of SQL Server in Azure VMs is cost. If you just … Continue reading “How to Create an Azure SQL Instance via PowerShell”