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 (152 total posts)
  • 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
  • PowerShell Script to Deploy Multiple VM on Azure in Parallel #azure #powershell

    This blog is usually dedicated to Business Intelligence and SQL Server, but I didn’t found easily on the web simple PowerShell scripts to help me deploying a number of virtual machines on Azure that I use for testing and development. Since I need to deploy, start, stop and remove many virtual machines created from a common image I created (you ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 29, 2013
  • Speaking - Automate Your ETL Infrastructure with SSIS and PowerShell

    Today at 4:45PM EDT I'm presenting a new session using PowerShell to auto-generate SSIS packages via the BIML language.  The really cool thing is that this session will be live broadcast on PASS TV! You can view the session by clicking on this link.  If you have questions for me during the session, you can send them to me via Twitter ...
    Posted to Allen White (Weblog) by AllenMWhite on October 16, 2013
  • Fall 2013 IT/Dev Connections Sessions

    This week I had the honor of presenting two sessions at the IT/Dev Connections conference in Las Vegas.  My two sessions were Manage SQL Server 2012 on Windows Server Core with PowerShell and Manage SQL Server Efficiently with PowerShell Remoting.  I think both sessions went well, and the attendees indicated that they will be able to use ...
    Posted to Allen White (Weblog) by AllenMWhite on October 4, 2013
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement