Category Archives: SQL Server

About SQL Server.

My IDERA’s PowerShell Webcast not only for DBA’s

I decided to compiled all of the webcast I did for IDERA Geek Synch from the last two years(2015 – 2016). Free registration and view the webcast: https://www.idera.com/events/geeksync 08/10/2016 – Geek Sync Webcast : Learn the PowerShell Essentials on Error … Continue reading

Posted in PowerShell, Resources, SQL Server | Comments Off on My IDERA’s PowerShell Webcast not only for DBA’s

VS Code working with SQL Server

VS Code editor works great and specially when using it in cross-platform environment. So, I decided to try using it connect to one of my SQL Server instance. To configure VS Code editor is simple. Make sure to check my previous … Continue reading

Posted in PowerShell, SQL Server | Comments Off on VS Code working with SQL Server

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

Important PowerShell Links To Remember

Just a reminder!  Here are some PowerShell resource link to save. Microsoft just recently announce the PowerShell “Windows Management Framework 5.1 Preview“. Check the PowerShell Team Blog: Announcing Windows Management Framework (WMF) 5.1 Preview In addition, if you encounter any … Continue reading

Posted in PowerShell, SQL Server | Comments Off on Important PowerShell Links To Remember

Microsoft SSMS July 2016 Hotfix is Available now

Go and get it.  Of course, No SQLServer PowerShell update on this hotfix. But you’ll need this update. Read more on this link for more information: https://msdn.microsoft.com/en-us/library/mt238290.aspx If you are still interested of see what’s new in this July Edition of … Continue reading

Posted in PowerShell, SQL Server | Comments Off on Microsoft SSMS July 2016 Hotfix is Available now

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