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 15 (150 total posts)
  • 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
  • Quick and Dirty PowerShell SQL Server Load Test

    Today I wanted to share a very short PowerShell script that can be used to simulate running multiple clients against a SQL Server, for simple performance or hardware testing. One thing I love about PowerShell is that so many functions and features are pre-built and easily accessible that I have to write very little code to accomplish a lot. This ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on July 12, 2013
  • Tech Ed Demos for "Manage SQL Server System and Performance Data with PowerShell"

    This morning I presented my session Manage SQL Server System and Performance Data with PowerShell at Tech Ed NA in New Orleans. We had a good sized audience who were very responsive and had many great questions. I had a great time presenting and the feedback I've gotten so far tells me the audience enjoyed it as well. I really appreciate ...
    Posted to Allen White (Weblog) by AllenMWhite on June 4, 2013
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement