Browse by Tags

All Tags » sql server 2008 (RSS)
Friday, April 18, 2008 1:49 AM

Fuzzy in T-SQL

SQL Server gives you Fuzzy Lookups and Fuzzy Grouping , but only in SQL Server Integration Services. It's not even on the list of SSIS enhancements for SQL Server 2008. This week at the MVP Summit, I was having a discussion about this with Jamie Thomson...
Posted by Rob Farley | with no comments
Filed under: ,
Tuesday, March 04, 2008 11:54 AM

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...
Posted by Rob Farley | with no comments
Filed under: ,
Tuesday, March 04, 2008 9:17 AM

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?...
Posted by Rob Farley | 12 comment(s)
Filed under: , ,
Tuesday, March 04, 2008 8:53 AM

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...
Posted by Rob Farley | 2 comment(s)
Filed under: , ,
Tuesday, March 04, 2008 7:50 AM

Melbourne Launch

So I'm at the Heroes launch in Melbourne today. I'm going to hang out at the Experts booth, so if you're here and have a question about SQL Server 2008, why not come over?
Posted by Rob Farley | with no comments
Filed under: , ,
Saturday, February 23, 2008 4:00 PM

SQL Server 2008 CTP6 gives you PowerShell

The sixth CTP of SQL Server 2008, made available this past week at http://connect.microsoft.com/sql provides a PowerShell provider for SQL Server, which is backwards compatible with SQL Server 2005 as well. I showed it a little at the User Group in Melbourne...
Posted by Rob Farley | 2 comment(s)
Filed under: ,
Tuesday, January 08, 2008 10:34 PM

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...
Posted by Rob Farley | 2 comment(s)
Filed under: , ,
Tuesday, November 20, 2007 8:02 AM

It's a big week for downloads

SQL Server CTP5 is now available for public download. Yesterday I wrote about Visual Studio 2008 being live and ready for download to MSDN Subscribers, and today there will be more activity on the Microsoft servers again. This latest CTP includes lots...
Posted by Rob Farley | 1 comment(s)
Filed under: