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 » sql   (RSS)
  • 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
  • Behind the scenes of PowerShell and SQL

    Every year, PowerShell increases its stranglehold on the Windows Server system and the applications that run upon it – with good reason too. Its consistent mechanisms for interaction between its scripting interface and the underlying systems make it easy for people to feel comfortable, and there is a discoverability that has been lacking in many ...
    Posted to Rob Farley (Weblog) by rob_farley on February 11, 2013
  • PowerShell script to help uninstall SQL Server 2008 R2 Evaluation Edition

    If you haven’t been caught by a client (or even yourself) installing SQL 2008 R2 Evaluation Edition and then letting it expire, you might not realise the pain that this causes. To say it’s frustrating is a serious understatement. Fellow SQL MVP and SQLBlog blogger Aaron Bertrand (@aaronbertrand) has an excellent post on the matter, which he put ...
    Posted to Rob Farley (Weblog) by rob_farley on May 23, 2011
  • Using SQL Execution Plans to discover the Swedish alphabet

    SQL Server is quite remarkable in a bunch of ways. In this post, I’m using the way that the Query Optimizer handles LIKE to keep it SARGable, the Execution Plans that result, Collations, and PowerShell to come up with the Swedish alphabet. SARGability is the ability to seek for items in an index according to a particular set of criteria. If you ...
    Posted to Rob Farley (Weblog) by rob_farley on January 3, 2011
  • PowerShell to fetch a SQL Execution Plan

    With PowerShell becoming the scripting language of choice for many people, I’ve occasionally wondered about using it to analyse execution plans. After all, an execution plan is just XML, and PowerShell is just one tool which will very easily handle xml. The thing is – there’s no Get-SqlPlan cmdlet available, which has frustrated me in the past. ...
    Posted to Rob Farley (Weblog) by rob_farley on December 6, 2010
  • Fetching Latitude and Longitude Co-ordinates for Addresses using PowerShell

    Regular readers of my blog (at – please let me know if you’re reading this elsewhere) may be aware that I’ve been doing more and more with spatial data recently. With the now-available SQL Server 2008 R2 Reporting Services including maps, it’s a topic that interests many people. Interestingly though, although many people have plenty ...
    Posted to Rob Farley (Weblog) by rob_farley on May 23, 2010
Privacy Statement