Insufficient data from Andrew Fryer

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

Browse by Tags

TechNet Blogs > Insufficient data from Andrew Fryer > All Tags > business intelligence
Tagged Content List

  • Blog Post: HD Insight

    Despite common misconceptions Microsoft now has extensive interoperability with open source technologies for example you can run a php application on Azure, get support from us to run RedHat, SUSE or CentOs on Hyper-V and manage your applications from System Center . ,  So extending this approach...
    on22 Mar 2013

  • Blog Post: SQL Relay 2012

    Four cities,  in four days makes for one tired evangelist, so why am I doing SQL Relay with the SQL community I hear you ask.  Well that’s your answer really -  I can’t hear you ask anything when I am sat in darkest Surrey blogging away so I am actually doing these events not so much to...
    on7 May 2012

  • Blog Post: Business Intelligence for the Private Cloud part 1

    If you have looked at any of the new components of System Center 2012 you may have noticed that everyone seems to have a bunch of reports, some of them have data marts or data warehouses and some of them have analytics in the form of analysis services cubes.  Apart from the confusion over when to...
    on30 Apr 2012

  • Blog Post: 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...
    on6 Feb 2012

  • Blog Post: What’s good in SQL Server 2012 Integration Services

    This is a guest post by Allan Mitchell MVP, and one of the top speakers at SQL Bits   The launch of SQL Server 2012 is not too far away and the SQL Server team have been hard at work adding new functionality and also improving upon existing features.  I am lucky enough to have been working...
    on6 Feb 2012

  • Blog Post: 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 else you need besides the...
    on8 Nov 2011

  • Blog Post: SQL Relay

    I am in the middle of SQL relay this week, but I just realised that you might like to have a copy of my Denali slide deck, which I have now posted to SkyDrive . You are welcome to have a look at it even if you couldn’t make one of the four venues I am presenting at this week, but there isn’t a lot of...
    on5 Oct 2011

  • Blog Post: Does “self service BI” mean more or less work for IT?

    Before I answer that question I want to be clear on what exactly self service BI means as you could argue that users have been doing BI for themselves since the spreadsheet was invented. In those early days users would often have to rekey data into whatever analysis tool they were using as the source...
    on5 Oct 2011

  • Blog Post: SQL Bits 11 - Notes & Queries

    If you didn’t manage to fight your fight your way through the Everton & Liverpool fans to SQL Bits I thought you might like to see some of the random questions I got asked.. How do I manage SQL Azure? I think the key thing about developing for the cloud is to ensure that your application can handle...
    on3 Oct 2011

  • Blog Post: 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 this report can be considered...
    on24 Aug 2011

  • Blog Post: Installing Denali ctp3–how hard can it be

    l forget sometimes that installing SQL Server isn’t that straightforward, in part because it is now so much more than the database engine, that was SQL Server 7 when I started.  I also think its important that you understand the choices you are making when installing it although many of these can...
    on18 Aug 2011

  • Blog Post: BISM and Consumerisation in BI

    What on earth is consumerisation and what has it got to do with Business Intelligence?  Consumerisation is the recognition that our users are tech savvy and want to have access to the tools and way of working that they have outside of work.  Self Service is the result of applying these ideas...
    on28 Jul 2011

  • Blog Post: the BI Sematic Model in SQL Server Denali ctp3

    Some sort of semantic model is needed in every BI solution but what is it and why do I need one?  It’s a view of the data store(s) you want to work on for business intelligence which adds additional information that can be stored in the individual tables themselves.  For example how are the...
    on25 Jul 2011

  • Blog Post: Analysis Services cubed in SQL Server Denali ctp3

    I have now managed to install analysis services (SSAS) in SQL Server Denali ctp3 three times to reflect the three installation options that now exist .. The top instance is the table based installation that’s completely new for SQL Server Denali Then I have olap based SSAS instance that I have deliberately...
    on21 Jul 2011

  • Blog Post: 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...
    on20 Jul 2011

  • Blog Post: Before I get started with SQL Server Denali ctp3

    I have spent the last couple of days setting up a demo environment for SQL Server “Denali”, and I thought it might be useful to share some of my experiences over the next few days. Before I get into that a short post about the environment I have which will comprise of 7 x virtual machines (VMs) running...
    on18 Jul 2011

  • Blog Post: Notes & Queries from TechDays 2011

    I have been at TechDays Live all last week and although I did a bit of presenting, I was mainly there to listen and keep the week running smoothly.  I scribbled down a few notes during the various sessions I was in which I thought might be of interest: Easyjet have an amazing set of stories around...
    on1 Jun 2011

  • Blog Post: Applied Business Intelligence

    Like many IT Professionals, I love my gadgets but what really matters is what you do with them – so which games do you play  on your gamer PC what did you photograph with that monster lens you bought for your DSLR and  who did you hook up with on Facebook at the weekend?  The same is true...
    on21 Mar 2011

  • Blog Post: BI for small business

    When I applied to join Microsoft nearly 4 years ago I had to give  a presentation on olap for small business which now looks a little dated.  So yesterday I got the chance to revisit my thoughts on this over espresso  with BI Guru Rafal Luckaweiki from Project Botticelli who was over to...
    on3 Mar 2011

  • Blog Post: 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...
    on8 Feb 2011

  • Blog Post: Looking backwards over a decade of Microsoft BI

    It was in early 2000 if memory serves that I first used OLAP Services in SQL Server 7 and Cognos Novaview 1.0 and ten years later I wondered, as you do at this time of the year, what has changed and what will the future bring? and specifically is there a future for the BI professional with the dawn of...
    on5 Jan 2011

  • Blog Post: 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...
    on5 Dec 2010

  • Blog Post: A worked example of using spatial and olap data in Reporting Services part 2

    Following on from my my post on Monday I wanted to show you how to link reports together using the mapping control in Report Builder 3.  This is actually pretty easy to do as any polygon or point on a map can have an action associated with it and one of the available action types allows you to call...
    on24 Sep 2010

  • Blog Post: Integration, Integration, Integration

    Microsoft is all about choice, so instead of having one way of shifting data between two different platforms we have three.  I get asked about two of these a lot but I also wanted to discuss the latest tool in this space to make sense of all them and understand when to use what: Integration Services...
    on14 Jul 2010

  • Blog Post: A different kind of pivot

    BI is as much about making sense of information as getting the right information to the right people.  I am still amazed at the amount of reports and spreadsheets that are pure numbers, however amazement would turn to fear if pilots were using spreadsheets to look at heading altitude, climb rate...
    on3 Jun 2010
Page 1 of 5 (122 items) 12345