Browse by Tags

• powershell
• spatial
• sql improvements
• ssis

• The problem with America - spatial data

  Ok, it's not really a problem with America, just a problem with the perception of straight lines like the USA-Canada border. It's roughly the latitude line 49 degrees north. A line that goes East-West, on a straight line. Except that latitude Read More... Posted Monday, November 17, 2008 7:53 AM from Rob Farley | (Comments Off) Filed under: sql, SQL Server 2008, spatial

• Missing Index in SQL Server 2008 - should try harder!

  Ok, maybe I'm being a little harsh, but I just feel like it should be better. Let me show you the niceness of the way that missing indexes are handled in SQL Server 2008. Using AdventureWorks (not AdventureWorks2008) on a SQL Server 2008 install, Read More... Posted Sunday, October 12, 2008 1:38 PM from Rob Farley | (Comments Off) Filed under: sql, SQL Server 2008, sql improvements

• COPY_ONLY backup option more obvious in SQL Server 2008

  I feel like I keep finding reasons to use SQL Server 2008 Management Studio with SQL 2005 instances, and here's another - the COPY_ONLY option now appears on the Backup dialog box (others include the DROP & CREATE scripting option, multi-server Read More... Posted Friday, June 20, 2008 5:32 PM from Rob Farley | (Comments Off) Filed under: sql, SQL Server 2008

• "No Match Output" in SSIS 2008

  The hairy Irishman (his description - I just call him Sacha) is presenting to the Adelaide SQL Server User Group today, talking about improvements in SQL Server 2008 Integration Services. Right now he's talking about the No Match output of the Lookup Read More... Posted Thursday, June 12, 2008 1:50 PM from Rob Farley | (Comments Off) Filed under: sql, SQL Server 2008, ssis

• Transfer SQL Server Object Task fixed

  It's nice to give Microsoft feedback and get the product changed! I first mentioned this in a post last month and logged a connect.microsoft.com entry . Microsoft checked it out, invesigtaed, and have now put a new property into SQL Server 2008 to Read More... Posted Saturday, March 29, 2008 12:41 PM from Rob Farley | (Comments Off) Filed under: sql, SQL Server 2008

• Local Server Group queries

  This is really quite cool, especially since it's a tool feature, and one that will help SQL Server 2005 installs. Suppose you have many servers, all registered in Management Studio, in the Registered Servers window. Now you can right-click on the Read More... Posted Tuesday, March 04, 2008 11:54 AM from Rob Farley | (Comments Off) Filed under: sql, SQL Server 2008

• SQL Server 2008 PowerShell SnapIn

  Installing SQL Server 2008 gives you SQLPS.exe, an application you can run which is a PowerShell including the PSDrives for SQL Server (and compatible with SQL Server 2005 as well!). But how do you make this work with your current copy of PowerShell? Read More... Posted Tuesday, March 04, 2008 9:17 AM from Rob Farley | (Comments Off) Filed under: sql, powershell, SQL Server 2008

• Using ScriptingOptions with SQLPS

  I've written before that SQL Server 2008 (February CTP) gives you SQLPS - a PowerShell interface to SQL Server. So I was trying to get the ScriptingOptions happening, and this is the only way I've found so far. It's ugly, and if you have a Read More... Posted Tuesday, March 04, 2008 8:53 AM from Rob Farley | (Comments Off) Filed under: sql, powershell, SQL Server 2008

• Querying distances using Spatial data types in SQL 2008

  SQL Server 2008 has spatial types which are very useful for all kinds of applications. I thought it would be nice to produce one of those charts like you get in maps, telling you the distance between cities. So I start by populating the data. This uses Read More... Posted Tuesday, January 08, 2008 10:34 PM from Rob Farley | (Comments Off) Filed under: sql, SQL Server 2008, spatial