Category Archives: SQL Server

About SQL Server.

Create PowerShell Top-Down ETL Process III

On previous blog we have collect some data and built our .NET PowerShell object which is going to be loaded into our SQL Server. In this final section we are completing the process of loading the data into SQL Server. … Continue reading

Posted in PowerShell, SQL Server, Windows 10 | Comments Off on Create PowerShell Top-Down ETL Process III

Florida PowerShell Upcoming activities for May and June 2016

It’s a busy and a good time to learn some PowerShell. 1. Where: Florida PowerShell User Group Monthly meeting, Date: Thursday, May 26th at 6:30pm. Online Topic: The Essential PowerShell on Error Trapping. Description: Do you to learn how to … Continue reading

Posted in PowerShell, SQL Server, SSIS | Comments Off on Florida PowerShell Upcoming activities for May and June 2016

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

PowerShell connecting to SQL Server without SMO

Sometimes there will be a need to provide a scripting solution to connect to SQL Server to execute either a TSQL query or Stored-Procedure without the need of installing a SQL Server bits.  Here I’m providing two code snippets that … Continue reading

Posted in PowerShell, SQL Server | Comments Off on PowerShell connecting to SQL Server without SMO

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”