Euan Garden's BLOG

The final CTP of DataDude is now live, Gert blogged lots of info here . Matt clarifies the licensing issues around using developer edition here . And finally, Mairead is now blogging here , thats a pretty cool header she has for her blog I might have...

Remember SQL Express has a limitation of a single proc and 1GB of RAM (for the Buffer Pool), so can it be installed on a machine with more than those limits and what happens if it does install? In short, yes it will install just fine and once its installed...

In previous versions of SQL Server there was a licensing app that was integrated into control panel and was exposed via setup. It allowed you to enter the type of license you had for your server(Server+CAL or per CPU) and if you were using a CAL option...

The folks from CSS have a huge amount of knowledge and while there have been a couple of bloggers I had always hoped for more. Well my hopes have been answered, the new sqlblog has a ton of great content already I suggest keeping an eye on it! Maybe we...

I'm sad, I admit there are sometimes very small things that get added to products that get me excited, one of my fave small things in SSRS 2005 was Multi Value parameters. The All option was especially handy for a bunch of reports that we use internally...

While it always sucks to reship something the Data Dude folks have made the right call with the refresh on CTP 5. You can read about it here .

One of the cooler features in SSMS is the vast amount of info thats integrated via the summary page and its reports. Almost since the first day we showed these there have been 2 questions that alwsy come up.; 1/ Can I get the RDL for the report so...

I linked to Craig's blog when he started but he has had a series of CRACKING posts on joins. I highly recomend reading the summary post, lots of good stuff in here and its readable and written for humans. The SQL Server QP team are scary smart and...

In case you missed the 1,000s of other posts you can find it here . Highlights so far (for me at least) more stability, lots of copol options via project properties and the start of support for SQL 2005 features/objects, they are not all there yet but...

Have you been following Made In Express ? If not then its still ok, the 12 finalists are done and now you have a chance to vote on the winner, there are some great apps in there. Personally I like the curmudgeon chat bot on a point of principle<g>

The folks at SQLTeam have done some analysis on different ways of importing text files, you can read the info here; http://weblogs.sqlteam.com/mladenp/articles/10631.aspx http://weblogs.sqlteam.com/mladenp/archive/2006/07/22/10742.aspx And of...

The 3rd update to SQL Server 2005 Books On Line(BOL) is now available here , also the online version is updated. 3 Updates less than a year after RTM, great work by the UE team.

Technorati Profile

As a follow up to Tuesdays post , lets take a look at how this changes with SQL Express. (as always a little history) In MSDE for SQL Server 7/2000 the DTS runtime was included, this included the Package and Pump object models as well as the dtsrun...

I see this question come up in 2 main contexts, one is express users the other is users who thought they knew how to do this in SQL Server 2000 and are now confused in SQL Server 2005. We'll start with SQL Server 2000... In general the starting...

Get it while its hot!

This is not the answer to all occurences of the issue but try the following; Shut down SSMS. Go into IE, select Tools|Internet Options|Advanced If “Check publisher’s certificate revocation” under the security node is checked, then uncheck...

The folks on the BI Practices Team(now merged in with the SQL Server Perf Engineering Team) have spent the last 2 years working on a mondo BI reference implementation called Project Real. Working with data that started out form a real customer, hardware...

The SQL Everywhere guys have started blogging in fine style with 3 good posts today. You can read them here .

I've been catching up on my KB reading , I was prompted to go read this article by Robert Dorr, one of our Escalation Engineers. He was answering a question on one of our internal alias's (dbtalk) asking about using Solid State Disks for tempdb.

When Paul starting talking about Microsofts vision for data a while back one of the key pillars was built around the next evolution of data programmability, however there was not much info at the time. We've now released these 2 whitepapers that discuss...

Can be found here . Why is this especially interesting? well it includes the following; Bug fixes from the community feedback on the previous CTP Integrated Auth support(probably THE most requested feature) Client Failover support IBM...

No And now the explanation. I have seen a fair number of folks having problems getting data dude running because by default it looks for a named instance of SQL Express. (I actually hit this myself when I started playing with it but I was lucky enough...

When we first released the Oracle Migration Assistant we had a ton of requests for other platforms. The first was for Access migration, the challenge here is that Access includes an upsizing tool but it is not always viable, the latest version of Access...

Data Dude CTP bits can be got here , its an .img file which I a cd image, hence needs either exploded or burnt to cd before installing. I have been playing with this a lot the last few days and I am very impressed with the schema diff which I have been...