Category Archives: SQL Azure

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

Getting Ready with “Windows Azure SQL Database Server” PowerShell and SMO Part – 1/2

But before we start using PowerShell with “Windows Azure SQL Database Server” there a few more steps we need to be completed after you have started your subscription: Installing the most recent Windows PowerShell Azure module Rename Subscription name (Optional) … Continue reading

Posted in Azure, PowerShell, SQL Azure, Windows 8 | Comments Off on Getting Ready with “Windows Azure SQL Database Server” PowerShell and SMO Part – 1/2

South Florida IT Camp Saturday 2011 on July 23rd

We are pleased to announce the first South Florida IT Camp on Saturday, July 23rd 2011 from 8:00 am to 5:00 pm at Nova Southeastern in Fort Lauderdale. Parking and admittance to this event is free.  Lunch will provided. Please … Continue reading

Posted in Events, Exchange, Office, PowerShell, Resources, Sharepoint 2010, SQL Azure, SQL Server | Comments Off on South Florida IT Camp Saturday 2011 on July 23rd