Browse by Tags

• collation
• community
• indexing
• spatial
• sql
• sqlbits
• sqlpass
• t-sql tuesday

• 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 Read More... Posted Tuesday, February 12, 2013 11:11 AM by Rob Farley | 3 Comments Filed under: sql, t-sql tuesday, powershell

• PowerShell - grabbing values out of the registry and running them

  So I closed an application that runs when Windows starts up, but it doesn’t have a Start Menu entry, and I was trying to find it. Ok, I could’ve run regedit.exe, navigated through the tree and found the list of things that run when Windows starts up, Read More... Posted Tuesday, June 12, 2012 8:08 PM by Rob Farley | 3 Comments Filed under: powershell

• 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 Read More... Posted Tuesday, May 24, 2011 2:04 AM by Rob Farley | 15 Comments Filed under: sql, powershell

• 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 Read More... Posted Monday, January 03, 2011 4:54 PM by Rob Farley | 5 Comments Filed under: sql, indexing, powershell, sqlbits, sqlpass, collation

• 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. Read More... Posted Tuesday, December 07, 2010 12:14 PM by Rob Farley | 4 Comments Filed under: sql, powershell

• Fetching Latitude and Longitude Co-ordinates for Addresses using PowerShell

  Regular readers of my blog (at sqlblog.com – 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, Read More... Posted Sunday, May 23, 2010 6:59 PM by Rob Farley | 9 Comments Filed under: sql, community, spatial, powershell