Browse by Tags

All Tags » sql server 2008 (RSS)
Sat, Jun 13 2009 15:37

A review – SQL Server 2008 Internals

I’m reading SQL Server 2008 Internals at the moment. I say ‘reading’, because I think it’s going to be long-term thing. It’s just so full of useful information, that I’m sure I’ll be reading it over and over for a long time yet. Kalen Delaney ’s books...
Posted by Rob Farley | with no comments
Filed under: ,
Wed, May 6 2009 13:56

Seriously cheap exams in Australia

If you’re an MCP in Australia and you haven’t passed any exams over the past couple of years (since July 1, 2007), then Microsoft has an offer at the moment to let you do an exam for only US$25 (until June 30, 2009). Ok, so that means the price really...
Posted by Rob Farley | with no comments
Filed under: , , , ,
Wed, Apr 8 2009 12:01

SQL Server 2008 SP1 download

You can get it from http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19 For all those people who have been waiting for SP1 before considering a migration to SQL Server 2008, it has now been...
Posted by Rob Farley | 1 comment(s)
Filed under: ,
Mon, Nov 17 2008 7:53

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...
Posted by Rob Farley | 4 comment(s)
Filed under: , ,
Sun, Oct 12 2008 14:38

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,...
Posted by Rob Farley | 12 comment(s)
Filed under: , ,
Sun, Sep 21 2008 20:03

Accelerated SQL Server 2008 - Walters, Coles, Ferracchiati, Rae & Farmer

Apress asked me to review this book, so here goes... I was a little disappointed, but on the whole thought it was pretty good. I also posted this review to Amazon, where I figure more people will read it. I saw this book come out, and had high expectations...
Posted by Rob Farley | with no comments
Filed under:
Thu, Aug 28 2008 8:24

Another new SSMS 2008 goodie - moving files into a project

So many times I'm writing a query, and I think "I want to put this into that project...", but because I didn't add it when I first made the query it's a pain (and I end up copying the text into a new query). But in SSMS 2008, I've...
Posted by Rob Farley | 2 comment(s)
Filed under:
Mon, Aug 25 2008 22:11

Map of the world in the Spatial Results tab (and converting from Geometry to Geography)

One of the things on my list of stuff to check out in the RTM version of SQL Server Management Studio in 2008 is the Spatial Results tab that Isaac Kunen talked about a while back . He called it Eye Candy, and it really is. I started by grabbing a set...
Posted by Rob Farley | 1 comment(s)
Filed under: ,
Fri, Jun 20 2008 18:32

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...
Posted by Rob Farley | 6 comment(s)
Filed under: ,
Thu, Jun 12 2008 14:50

"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...
Posted by Rob Farley | 1 comment(s)
Filed under: , ,
Thu, Jun 12 2008 13:48

PowerShell changes in SQL Server 2008 RC0

Regular readers of my blog will remember my post about how to get PowerShell for SQL into your regular PowerShell window . Except that if you've just installed SQL Server 2008 RC0, you may have noticed it doesn't work any more. Never fear, they've...
Posted by Rob Farley | 1 comment(s)
Filed under: ,
Fri, Apr 18 2008 1:49

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 | 1 comment(s)
Filed under: ,
Tue, Mar 4 2008 11:54

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: ,
Tue, Mar 4 2008 9:17

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 | 18 comment(s)
Filed under: , ,
Tue, Mar 4 2008 8:53

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: , ,
Tue, Mar 4 2008 7:50

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: , ,
Sat, Feb 23 2008 16:00

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 | 3 comment(s)
Filed under: ,
Tue, Jan 8 2008 22:34

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: , ,
Tue, Nov 20 2007 8:02

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: