Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

SQL Server 2008- Backup Compression

SQL Server 2008 will have the ability to compress a database, but that functionality is not in the latest beta release (CTP5).  However CTP5 does have the ability to compress backups by simply extending the existing backup command: backup database adventureworks to disk=’C:\abc\adventureworks_compress.bak’     with compression What’s interesting about this is that it doesn’t just… Read more

Performance Point Server Planning Dependency on SQL Server Enterprise Edition

Sorry about the catchy title, but I wanted to clarify why the planning component of Performance Point Server in turn depends on SQL Server Enterprise edition. I pointed out in my recent TechNet presentations that Performance Point doesn’t make use of the cube write-back feature of analysis services, which is one of the extra features… Read more

SQL Nugget – Dates are illogical

Whether I am reading Chocky by John Wyndham or the 12 Caesers by Suetonius the illogical nature of a calendars can be annoying . In Chocky the alien wonders why we don’t have 16 months instead of 12 and why weeks aren’t made up of 8 days, and in the 12 Caesers successive emperors try… Read more

MCSE for SQL Server

I have to be honest I gave up getting certified before I joined Microsoft mainly because the exams didn’t keep up with the release of SQL Server specifically the Business intelligence exams. I then had the same problem as an evangelist I was working on the next release of the SQL or Windows Server. However… Read more

Using SQL Server 2008 R2 Report Builder 3 with Bing Maps

This article shows you how to get started with Report Builder 3 (RB3) and Bing Maps. I could use adventure works to show you this but I thought you might want to see a little bit of our green and pleasant land instead. To do this I have put  the previous SQLBits venues into a… Read more

SQL Server 2008 Notification Services

Notification services is one of the deprecated features in SQL Server 2008, essentially it is supported for now but will not be in the next release of SQL Server. If you are using notification services currently and you are looking to upgrade to SQL Server 2008 then you can get it from here. But why… Read more

SQL Server 2008 Resource Governor

The feature of SQL Server 2008 that seems to get  the most attention from DBA’s is the Resource Governor.  It basically does what it says on the tin; for example you may want to reserve a portion of CPU or other resource for a user, process etc. At the top level Resource Governor has Resource… Read more

Licensing SQL Server Client Tools

Ever since I have been using SQL Server you have had the ability to manage SQL Server from another machine, so back in the day I used enterprise manager and query analyzer on my PC to do stuff on a server hidden in a basement somewhere.  At some sites an enterprising software compliance guy would… Read more

Microsoft Business Intelligence without SharePoint

This might be a strange topic given that the release of SharePoint 2010 is just around the corner, but I wanted to respond to a couple of questions and debates I have been involved with in my temporary role in the partner team. I would like to start by going back to the early days… Read more