High ROI items for SQL Server 2008

To persuade your boss to embrace an upgrade to SQL 2008, you need to know which features have high Return On Investment. They may have seen presentations talking about features like Spatial, or MERGE (and been quite impressed), but they may well have left those presentations thinking about the effort that’s would be involved in rewriting applications to take advantage of these features. It’s all well and good to see your customers on a map, but someone has to make that spatial data appear somewhere. This post is a callout for features that will benefit you (and your boss) as … Continue reading High ROI items for SQL Server 2008

StreamInsight talk coming up at SQLBits

My talk on StreamInsight is up next. I’ll try to blog more about that later. For now, I want to mention more about SQLBits itself. This is by far the largest SQL-only conference I’ve attended (I haven’t been to SQL-PASS yet), and it’s great to be involved. Yesterday I had an all-day seminar about the new items for Developers in SQL 2008. It was a good time – the delegates responded very positively, and many of them have caught up with me since. But for me, the conference is being a great way of catching up with (and meeting for … Continue reading StreamInsight talk coming up at SQLBits

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 are always great, but in this one she has help from Paul Randal & Kimberly Tripp, Conor Cunningham and Adam Machanic – all SQL Server legends in their own right. The book they have made is just excellent, and should be read by everyone who wants to get deeper into SQL Server. There are … Continue reading A review – SQL Server 2008 Internals

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 depends on the value of the Aussie dollar, but either way, it’s not a bad opportunity. The offer is only on for a very short time, but why not check out http://www.learnandcertify.com/mcpupgrade/ and see what you can do? I’m thinking it’s a nice opportunity to knock over one of those … Continue reading Seriously cheap exams in Australia

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 released. There’s also a new version of the Feature Pack for SQL Server 2008, available from: http://www.microsoft.com/downloads/details.aspx?familyid=B33D2C78-1059-4CE2-B80D-2343C099BCB4&displaylang=en

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 lines aren’t straight – except the equator. Just look on a globe and you’ll see what I mean.The curvature of the earth just gets in the way a bit. If you’re ten miles from the North Pole and travel east until you come back on yourself, you’ve just gone around in a circle that’s 20 miles across. The smaller … Continue reading The problem with America – spatial data

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, if I show the Execution Plan from this simple query, I get a nice suggestion. My query… select productid, orderqty from sales.salesorderdetailwhere carriertrackingnumber = ‘FB88-4B92-82’; …could be improved through better indexing. It uses 1240 reads to get this data, which seems awful. The system shows me that it could be improved, and suggests an index. It’s … Continue reading Missing Index in SQL Server 2008 – should try harder!

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. The authors are all great guys who really know their stuff. What’s more, Donald Farmer is _the_ guy for Data Mining, so I was hoping for a big section about the improvements in that area for SQL 2008. Looking through it though, it feels like a book that was written for … Continue reading Accelerated SQL Server 2008 – Walters, Coles, Ferracchiati, Rae & Farmer

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 just noticed the File menu has a “Move <file> into project” entry down near the bottom. So now I can just choose that and my query magically appears in the project. Terrific! There seems to be so many nice little things in SSMS 2008 – try right-clicking on some data in … Continue reading Another new SSMS 2008 goodie – moving files into a project

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 of data from Virtual Earth expert (and good friend) John O’Brien, containing geometry figures for the world. Geometry for things that are on the world isn’t exactly the best, but it was better than nothing. So then there was the matter of converting it to the Geography type. Geometry … Continue reading Map of the world in the Spatial Results tab (and converting from Geometry to Geography)