Euan Garden's BLOG

We get asked for this a lot and we are looking to address it in the future, for now Michael has a workaround that I have copied below. 1) In Excel : - Create new file in excel - File->Properties - Go to the Custom page - In the Name edit box...

This is a cool project for lots of reasons; There is a real need for this It has already been used by some MCS consultants so we know it works Its being released as a community project For me its cool because its for Analysis Services,...

Seems like Mike has the info on whats going wrong and how long it will be before its fixed.

There are several ways but the most commonly used approach of using linked servers hits ona 1000 row limit in the AD OLE DB Provider, here is a solution using SQL CLR, I have not tried it but if it works as advertised then it should help, beware it does...

Mairead is asking for more feedback here.

Paul is the PM , he made the announcement today.

Database Diagrams in SQL Server 2005 and VS 2005 were one of the more *ahem* controversial issues. If you remember at one point they were cut, then they came back, mostly as a result of the overwhelming feedback on them. Well (Data Dudette) Mairead...

Ok I am being brave again and forward posting this, SP2 is done and should be available for download here 9:00am Monday.

I think its fair to say that this 100+ page monster is the definitive SSAS 2005 Perf White paper, even Mosha likes it!

This question has been coming up a lot internally lately, short answer is: Data Source=D:\Test.xlsx;Provider=Microsoft.ACE.OLEDB.12.0; Extended Properties=Excel 8.0; Note that the provider is no longer JET but the new data engine from the office...

Linchi continues his excellent series analyzing the impact of new system features in SQL Server 2005 here .

Soon according to Paul .

Nice work Dan and team, you can get it here , including some of the source. There is a link that page to download the binaries from here .

When it was announced that there was a default trace that was on in SQL Server 2005 lots of people got very nervous(similar reaction was had to the idea of DMVs). A lot of the fear of the impact of trace comes historically. When trace was used in 7.0...

I mean SQL Server CE , SQL Server Mobile , SQL Server Everywhere ...oh well you get the idea. Lots of great content starting here

and how its managed, and how its different in RTM, SP1 and SP2? Start here , it took me 2 nights to read all the entries on this, the question is how long will it take for me to understand it!!!

No not a reference to the movie but a great set of videos to help folks get started with SSE. You can find them here , more added every so often.

Scott Guthrie has produced a great tutorial in using the CTP of the Publishing Wizard over here . I have no idea how Scott manages to find the time to produce this great, detailed content, as well as be the General Manager for IIS, ASP.Net, Commerce...

Welcome to 2007! As seems to be the trend here is the list of most popular posts for the last year, I have applied some filtering (ie some posts had a lot of comments but they were just links, I excluded them). Top 3 by hits (combo of feeds and direct...

Just in time for Christmas get it here . This will be the last CTP of SP2 so get testing and have a great festive season.

I was reading through some of the PASS slides from MS Presenters that were shared out internally. Mark Souza had what looked like an amazing session, some of the highlights; There is a new Best Practices site here , lots of good stuff. Some other...

You can get it here , more details from Gert here Congrats to the team, its less than 2 years since data dude was a series of box and lines on a whiteboard, its a great product, enjoy.

SQL Server 2005 includes a lot of changes to help make moving from Oracle to SQL Server easier, these include; - User Schema separation - Multiple Active Result Sets (MARS) - Synonyms - Recursive Queries(CTEs) and some other smaller issues...

Get it while its hot! Whats New Download Page (this will be live later today) I know a lot of people wanted more issues addressed in SP1 but there are all sorts of complex timing issues when it comes to planning an SP, especially on a new code...

Dan announced this a little while back here . One of the challenges that we did not really come up with a good solution for in SQL 2005 RTM was the following; Develop an app locally on your machine using one of the VS Express SKUs(Primarily Visual...