THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » powershell   (RSS)
Showing page 1 of 16 (159 total posts)
  • Using Visual Studio Code and the PowerShell extension behind a proxy

    I’m putting this here solely for myself so I’ve got it for later. If its useful for anyone else, great. I’m a big fan of Visual Studio Code (VSCode) for editing code scripts mainly because of the Git integration, the built-in Explorer and the fact that its so lightweight. I have even used VSCode for editing PowerShell scripts in preference to ...
    Posted to Jamie Thomson (Weblog) by jamiet on June 8, 2016
  • [Speaking] SQL Intersection - April in Orlando

    This coming April 16 - 20, the Spring 2016 SQL Intersection conference will be held at the Walt Disney World Swan hotel, and I'll be presenting two sessions this year.Get Near Realtime ETL with Service Broker Most of the time you’ll see ETL being done with a tool such as SSIS, but what if you need near-realtime reporting? You need to get the ...
    Posted to Allen White (Weblog) by AllenMWhite on February 8, 2016
  • Calling Cronacle web service QueryJob1 from PowerShell

    2 blog posts in 2 days. Hell must have frozen over… On my current project we are using Cronacle as our job scheduler and we have a need to programatically query Cronacle to ask it the status of a job. The following script accomplishes that using PowerShell: Code Snippet function Ignore-SSLCertificates { ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 22, 2016
  • Issuing linux commands with embedded quotes from PowerShell.

    Here’s a little thing I figured out today and I’m sticking it on my blog because I know I’ll need this again at some point. I’ve been writing some PowerShell code to connect to linux and issue bash commands (don’t ask why ). We use PLink.exe, a free utility that is bundled inside putty, to issue the commands hence our code is something like ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 21, 2016
  • 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
1 2 3 4 5 Next > ... Last »
  Privacy Statement