Category Archives: SQL Azure

SSMS Version 17.4 no more SQLPS Module

It was just a matter of time, as it was already mention in previous SSMS (SQL Server Management Studio) documentation that SQLPS module was going to be deprecated and replace with the new SQLServer module. See SSMS download information at: … Continue reading

Posted in Azure, Bash, PowerShell, PowerShell Core, SQL Azure, SQL Server, Ubuntu, Windows 10, Windows 2012, Windows Server 2016 | Comments Off on SSMS Version 17.4 no more SQLPS Module

PSCore6 – Nuget Microsoft.SqlServer.SqlManagementObjects latest Package (v140.17218.0) Broken

This is the SMO (SqlServer Management Objects) package use to create PSCore6 scripts to connect and manage SQL Server on Windows, Linux, and Azure. But today, I found out the latest version “140.17218.0″ is broken. I had to rolled back … Continue reading

Posted in Azure, Bash, PowerShell, PowerShell Core, SQL Azure, SQL Server, Ubuntu, Windows 10, Windows Server 2016 | Comments Off on PSCore6 – Nuget Microsoft.SqlServer.SqlManagementObjects latest Package (v140.17218.0) Broken

PowerShell – SQL Server Management Studio v17 is Ready!

Yes! The SQL Server Management Studio  Version 17 is available for download for the purpose of managing the new SQL Server 2017, Azure SQL Databases and Azure SQL Data Warehouse. At the same time this version won’t prevent you from … Continue reading

Posted in PowerShell, SQL Azure, SQL Server, Windows 10 | Comments Off on PowerShell – SQL Server Management Studio v17 is Ready!

PowerShell – SQL Server 2014 SMO TruncateData() Workaround

As I was still puzzle why the SMO *.TruncateData() was missing in SQL Server 2014, I needed to find a quick workaround to continue with my data migration. Of course, here comes T-SQL scripting to the rescue: Basically, subtitute the … Continue reading

Posted in PowerShell, SQL Azure, SQL Server, Windows 10, Windows 2012 | Comments Off on PowerShell – SQL Server 2014 SMO TruncateData() Workaround

Azure PowerShell Preview 1.0 is here

Welcome to PowerShell Azure Resource Manager (RM)! Microsoft has introduce and made available Azure PowerShell Preview 1.0.  Please read all about it in the following Azure Blog site: Azure PowerShell 1.0 Preview:  https://azure.microsoft.com/en-us/blog/azps-1-0-pre/ Also, feel free to search for it … Continue reading

Posted in Azure, PowerShell, SQL Azure, SQL Server | Comments Off on Azure PowerShell Preview 1.0 is here

ITPro Camp SoFla – PowerShell SQL Azure Database

Thanks to all whom attend my session this year South Florida ITPro Camp 2014. Please click in the following link to download my presentation and demo scripts. Please don’t hesitate to contact me if you have any questions and keep attending … Continue reading

Posted in Azure, PowerShell, SQL Azure, SQL Server | Comments Off on ITPro Camp SoFla – PowerShell SQL Azure Database

FLPSUG Last meeting May 15th on “PowerShell Azure SQL Database”

FLPSUG Lync meeting Thursday May 15 2014 – Session: “PowerShell Working w/Microsoft Azure SQL Database” Speaker Maximo Trinidad (MVP) and Co-hosting Adnan Cartwright (MVP). In this presentation I will be covering how to subscribe to Azure, setup PowerShell to connect … Continue reading

Posted in Azure, PowerShell, SQL Azure, SQL Server | Comments Off on FLPSUG Last meeting May 15th on “PowerShell Azure SQL Database”

Quick Rundown – Microsoft Azure SQL Database Server and PowerShell

Azure SQL Database  1. Web and Business editions are no longer available. Now there’s Basic, Standard, and Enterprise editions. (New) 2. There is a limit of 6 SQL Database Servers and up to 150 databases per subscription. 3. Create database … Continue reading

Posted in Azure, PowerShell, Resources, SQL Azure | Comments Off on Quick Rundown – Microsoft Azure SQL Database Server and PowerShell

QuickBlog: PowerShell Working with Windows Azure

As I venture into the realm of learning some PowerShell Automation in Windows Azure, its interesting the things you learn by just trying things out.  On my previuos blogs I mention, in order to use PowerShell, you need to create … Continue reading

Posted in Azure, PowerShell, SQL Azure, Windows 8 | Leave a comment

Trap missing IP Address for SQL Database Server Firewall Rule

As I work on my second blog piece for the “Getting Ready with Windows Azure SQL Database Server PowerShell and SMO Part – 2/2“, I came up with a way to trap the current IP Address with PowerShell scripting.  When … Continue reading

Posted in Azure, PowerShell, SQL Azure, SQL Server, Windows 2012, Windows 8 | Leave a comment