Category Archives: SQL Server

About SQL Server.

PowerShell in South SQL Saturday 379 was a Great Success

Once again I’m thankful to the organizers to have me speak at this “Awesome” event.  I appreciate the all whom attend my session meking it a Great Success and they got more.  My “PowerShell with Visual Studio SQL Data Tools” … Continue reading

Posted in PowerShell, SQL Server, SSIS, XML | Comments Off on PowerShell in South SQL Saturday 379 was a Great Success

June Month for learning PowerShell and SQL Server SMO

Yes! This is month you could learn PowerShell and SQL Server Management Object (SMO) techniques to start building script(s) to manage your SQL Server(s). I will be speaking at the following events: 1. South Florida SQL Saturday #379 on 06/13/2015 … Continue reading

Posted in PowerShell, SQL Server | Comments Off on June Month for learning PowerShell and SQL Server SMO

PowerShell SQLServer SMO Simplicity Series – 2

Now that we got the connection to the server there are a couple of lines we could include to avoid connection timeout during execution of our T-SQL script using SMO with PowerShell. So, in this blog will be covering executing … Continue reading

Posted in PowerShell, SQL Server | Comments Off on PowerShell SQLServer SMO Simplicity Series – 2

PowerShell using SMO to get SQL Database Table information

Using SQL Server Management Object .NET class can assist in extract information about your SQL Server engine.  This is a sample PowerShell script code using SMO to extract database tables information and display it in the PowerShell console; Notice that … Continue reading

Posted in PowerShell, SQL Server | Comments Off on PowerShell using SMO to get SQL Database Table information

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”

IT Palooza South Florida Great Success – PowerShell Rules!

Great event on 12/12/2013 in South Florida with most IT Community User Groups showcasing their stuff. It was full of people and friends. Thanks to Nova Southeastern University and organizers (specially Alex Funkhouser) for having me as a speaker present … Continue reading

Posted in PowerShell, Resources, SQL Server, SSIS | Comments Off on IT Palooza South Florida Great Success – PowerShell Rules!

Nice DOTNETZIP Integration with PowerShell

Let me share a script I built two years ago, and I just created a function for it named “New-ZipFile“. Basically, this PowerShell function script will create a blank zipped file and copy the files to it. At the same … Continue reading

Posted in PowerShell, SQL Server, SSIS, 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

Great PowerShell sessions at SQLSaturday SoFla on June 29th 2013

Yes! On Saturday June 29th, I’ll be presenting two interesting PowerShell sessions: 1. DBA Track – PowerShell Working with XML 2. SSIS Track – Integrating PowerShell in a ScriptTask component These session come full of demos and reference information.  The … Continue reading

Posted in Events, PowerShell, Resources, SQL Server, SSIS, XML | Comments Off on Great PowerShell sessions at SQLSaturday SoFla on June 29th 2013