SQL Server

Microsoft SQL Server
SQL Server User Group December 2005 - SQL CLR Integration
This month's Melbourne SQL Server User Group meeting was all about the CLR integration in SQL 2005. There has been a lot of hype about this feature and you can find various views ranging from “use it for everything” to “don't even enable it”. The talk we given by one of our local members, Greg Obleshchuk from A & G Software and I think he did a great job of presenting the good points of the CLR integration and highlighting when to use it and when not to use it. As a general ......

Posted On Wednesday, December 21, 2005 7:03 PM | Comments (0)

Oracle 10g vs SQL Server 2005
I had a request recently from someone for information on performance of Oracle 10g vs SQL Server 2005. I don't think there is too much around on SQL 2005 yet as it has not been officially released for that long and the Beta and CTP releases were not really meant to be used for benchmarking (in fact I think the license agreements explicitly states that this is not allowed). I can't actually claim credit for this as the topic came up on the SQLDownUnder mailing list a couple of weeks ago and two of ......

Posted On Monday, November 21, 2005 1:34 PM | Comments (12)

Trying to register for a Microsoft e-Learning course.
Well, I have been trying to register for one of Microsoft's free e-Learning courses for SQL Server 2005 for the last 24 hours. But each time I try to access I get told I need to register and each time I try to register I get the following: There was an error while registering you as a Learner. Please try after some time. I have registered before for other similar courses without any problems, so “after some time” I come back, but still no luck. Darn it! I had set aside some time this ......

Posted On Saturday, November 19, 2005 4:57 PM | Comments (5)

SSRS–adding a pipe delimited text export option in Sharepoint Integrated mode
We are currently looking decommission an old reporting portal based on another technology stack and replace it with SSRS running in Sharepoint integrated mode. However one of the requirements was to support a “pipe delimited” CSV export format. There are a number of posts you can find about changing reportserver.config when running SSRS in standalone mode, but I could not find much information about how to do this when running in Sharepoint Integrated mode. MSDN documentation lists the various cmdlets, ......

Posted On Friday, April 10, 2015 8:37 PM | Comments (2)

SQL Saturday #365–Melbourne Feb 7 2015
Things have been a little quite around here recently, one of the reasons for that is that I’ve been hard at work as a committee member for SQL Saturday 365 which will be held in Melbourne, Australia on Feb 7th 2015. Following on from Melbourne’s first highly successful event earlier this year, next year's event promises to be bigger and better. Located again at the Caulfield Campus of Monash University, the event will have a mixture of local, interstate and international speakers. And for the very ......

Posted On Monday, November 17, 2014 9:37 PM | Comments (0)

SQL PASS Summit & MVP Deepdives Volume 2
I'm currently in Seattle enjoying the start of some of the activities around the SQL PASS Summit. One of the activities that I'm looking forward to is the book signing session for the MVP Deepdives Volume 2 at lunchtime on Wednesday. I was fortunate to be one of the 60 or so authors this time around with a chapter on using Powershell to manipulate Analysis Services databases. All of the proceeds from this book go to support Operation Smile. You'll find the book's website here: http://www.manning.com/dela... ......

Posted On Tuesday, October 11, 2011 9:24 AM | Comments (1)

New Technical Article on the Columnstore (Vertipaq) indexes in Denali
You may have already heard some information about the fact that Vertipaq indexes that are coming in the next version of SQL Server code named "Denali" following the announcements last week at PASS. If you want some more detailed information there is a new technical article available for download: Columnstore Indexes for Fast Data Warehouse Query Processing in SQL Server 11.0 which goes into more depth about how this will all work ......

Posted On Tuesday, November 16, 2010 1:55 PM | Comments (0)

Holy Cow Bat Man! –PASS Summit Keynote Day 1
Wow. There were a stack of announcements made at the key note. So I thought I would try to jot then down while I'm just waiting for my first technical session a Deep Dive on PowerPivot to start. The Parallel Data Warehouse Edition of SQL Server 2008 R2 has been released to manufacturing, there was a demo with a query over an 800 Billion record table that was returning in 19 seconds on a 40 node parallel cluster. Yahoo came up and talked about an SSAS cube of theirs, it's 12TB in size and they load ......

Posted On Wednesday, November 10, 2010 5:27 AM | Comments (0)

The PASS 2010 conference is approaching fast
Next week is the 2010 PASS conference. This will be my second PASS conference and I'm really looking forward to it. The content is great and I love the chance to meet up in person with all the really great people in the SQL community that come from all different parts of the world just to talk about SQL Server. On Tuesday 9th for Lunch I am hosting a "Birds of a Feather" table on "SSAS Triple A – Administration, Automation and APIs". Between PowerSSAS, BIDSHelper and the ASSP projects on codeplex ......

Posted On Thursday, November 4, 2010 10:12 AM | Comments (0)

MVP for another year
It was very exciting to see an email from the MVP Award program in my inbox this morning saying that I had been re-awarded as an MVP for another year. This will be my 4th year as an MVP and I am very honored to have been re-awarded ......

Posted On Thursday, July 2, 2009 7:34 AM | Comments (6)

Full SQL Server Archive