Insufficient data from Andrew Fryer

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

Application Platform Knowledge Hub

Albert Einstein once remarked that you don’t need to remember everything, you just needed to remember where to look.  When it comes to learning about Microsoft products this can sometimes be harder than it ought to be and what resources there are can be fragmented so you do have to remember where to look.  That’s… Read more

SQL Server 2012 editions and dependencies

You may have seen that there are going to be some changes to the way SQL Server 2012 is licensed and the editions available, if you haven’t then the detail is here.  What I want to cover off in this post is what the various new features depend on so you are clear on what… Read more

SQL Server Reporting Services–if it’s important look after it

Before I can commit funds to a new project be it at work or at home I need to know I can afford it; specifically is there enough money in the budget and to find that out I need to run a report.  This is what’s meant by operational reporting and this distinction means that… Read more

Query Across the Mersey

SQL Bits 9, Adelphi Hotel Liverpool 29th September to 1 October 2011, what else do you need to know? Well possibly a few things if you are now reading the second line of this post or you haven’t been to them before.. It’s the biggest and best SQL event in Europe, I know this because… Read more

Reporting Alerting in SQL Server Denali ctp3

The installation experience for SQL Server Denali is very similar to SQL Server 2008 R2 but there are some important differences because of the new services.  I would also add that this is the install of the beta and I daresay I’ll need to do another post when it is released. The options for the… Read more

Getting Started with SharePoint and SQL Server Reporting Services – a guest post by Jess Meats

One of the capabilities of SQL Server is the ability to create and publish rich reports on your data. One of the capabilities of SharePoint Server is the ability to store, manage and provide a portal to documents. Those documents could be your reports. So you have one system letting you create reports and the… Read more

SCE Sunday part 13 – Reporting

System Center Essentials 2010 (SCE) relies on SQL Server Reporting Services (SSRS) to show what’s going on with your infrastructure.  As I mentioned in part 1, you need to either set this up at install time or point to an existing installation of SSRS. Once you have done that the reports you get will depend… Read more

Microsoft BI and Kerberos

I was briefing a bunch of partners the other day, and during coffee I went off piste and did a short overview of my presentation “It’s not about the Technology” to the BI MSc course at Dundee University.  However sometimes technology does get in the way especially when it comes to implementation and security, so … Read more

Business Intelligence & Cognitive Psychology

One of the most interesting session at the recent SQL Bits 7 was Jen Stirrup’s talk on use of charts in reporting services, partly because I am a failed graphic designer by training and partly the study I made of it for my MSc at the OU.  What she has done is to explain the… Read more

The Shape of BI

I spent a couple of hours this morning with a partner who wants to work with the Microsoft platform to deliver spatial business intelligence.  Unlike some companies who have BI skills they are trying to extend into the spatial world, these guys are spatial experts who want to understand Microsoft’s capabilities.  I mention this because… Read more