THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Powershell   (RSS)
Showing page 1 of 16 (155 total posts)
  • Automate ETL Testing: Cross-Server Data Comparison with PowerShell

    In collaboration with a current client over the past year or so, I've been working on the issue of Test Driven Development for ETL work, especially in the area of automated testing for data. He graciously agreed to allow me to rewrite some of the code we originally developed in Ruby as a set of PowerShell demo scripts and share it through ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on November 22, 2015
  • Test for a warning message using Pester

    Here’s a little ditty that’s worth throwing out (if nothing else so that I can find it later), if you’re not using Pester to test your PowerShell code then this post probably isn’t for you. If you’re not using PowerShell stop reading now. I wanted to write a Pester test that tested whether or not a piece of code threw a warning or not. I ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 5, 2015
  • Tribal Awards Winner

    Yesterday I received the news that I was the winner of the Tribal Awards in the category of Best Free PowerShell Script. This award means a great deal to me, as it's for something I gave to the community to share both a useful tool and a way to teach people more of the benefits of PowerShell. Thank you to Red Gate and Simple Talk for putting the ...
    Posted to Allen White (Weblog) by AllenMWhite on January 21, 2015
  • Parallel Foreach loops, one reason to use Powershell Workflow instead of SSIS

    Lately I’ve been using Azure Automation which is a service on Azure for running Powershell Workflow scripts, as such as I’ve diving deep into Powershell Workflow. What’s Powershell Workflow? I’m glad you asked: A workflow is a sequence of programmed, connected steps that perform long-running tasks or require the coordination of multiple steps ...
    Posted to Jamie Thomson (Weblog) by jamiet on December 9, 2014
  • Create a BLOB in Azure BLOB Storage using the REST API and Powershell

    Have you ever wanted to use Powershell to call the Azure BLOB Storage API in order to create a new BLOB? You haven’t? What have you been doing all your life? (!!!) Well, if your life ever does reach the same giddy heights as mine and you find that you need this ability added to your personal armoury then this blog post should be a massive help. ...
    Posted to Jamie Thomson (Weblog) by jamiet on September 12, 2014
  • Time your commands [Powershell nugget]

    When using Powershell I’ve always found it useful to be able to time how long commands/scripts are running for, invaluable when running long-running scripts. I used to do something similar to this in all my scripts: which is rather crude. It also has the disadvantage that I have to remember to actually put this into my scripts. What I’d prefer ...
    Posted to Jamie Thomson (Weblog) by jamiet on August 26, 2014
  • Prompt for a password with a mask using Powershell

    Here’s some code that I absolutely know I’m going to need again in the future, what better place to put it than on my blog! If you need to prompt the user for a password when using Powershell then you want to make sure that the value types in isn’t visible on the screen. That’s quite easy using the –AsSecureString parameter of the Read-Host ...
    Posted to Jamie Thomson (Weblog) by jamiet on April 24, 2014
  • [Speaking] SQL Saturday #295 - Las Vegas

    On Saturday I'll be presenting one of my favorite sessions, Manage SQLServer Efficiently w/PowerShell Remoting, at the Las Vegas SQL Saturday.  Here's the abstract:You have more and more servers to manage and less time to accomplish everything. You're writing scripts to automate those tasks but they still take time to run. PowerShell ...
    Posted to Allen White (Weblog) by AllenMWhite on April 2, 2014
  • Automate Your ETL Infrastructure with SSIS and PowerShell

    SQLPASS TV channel has been published the session Automate Your ETL Infrastructure with SSIS and PowerShell that Allen White (@SQLRunr) has done during the PASS Summit 2013.  Abstract Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on December 25, 2013
  • Clone an Azure VM using Powershell

    In a few months time I will, in association with Technitrain, be running a training course entitled Introduction to SQL Server Data Tools. I am currently working on putting together some hands-on lab material for the course delegates and have decided that in order to save time in asking people to install software during the course I am simply ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 4, 2013
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement