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 > sql server 2008
Tagged Content List

  • Blog Post: System Center Advisor– now live

    I remember hearing about a Project Houston about a year ago, a cunning plan to allow Microsoft to check the heath of your SQL Server databases and the operating system it sits on. It is now live and it’s called System Center Advisor . It works by using an internet gateway server you setup which in turn...
    on7 Mar 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: 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: Running out of space

    One of the best parts of my job is helping people, and although I am not a Microsoft support guy, I will respond if I can to requests on my blog , twitter etc. a particularly if it’s from people new to a particular technology.   This is partly out of a recognition that we’re all experts in...
    on7 Aug 2011

  • Blog Post: Data Mining not dead, but possibly forgotten

    With the launch of SQL Server 2008 R2 and SQL Server Denali ctp3 there has been ever more BI functionality built in but nothing has been mentioned about the strange world of data mining . Data mining has been in SQL Server since analysis services was launched but I have rarely seen it being used - it...
    on4 Aug 2011

  • Blog Post: SQL Server developer training kit–to useful to be just for developers

    One of the few niggles I have about working at Microsoft is the way we try and put you the reader into pigeon holes, and an area where this fails for me is when it comes to SQL Server.  My developer friends won’t go near SQL Server unless they have to and this things like  LINQ / Entity Framework...
    on24 Jun 2011

  • Blog Post: Virtualising SQL Server - a second opinion

    I caught a really good presentation from Chris Kranz( www.wafl.co.uk and @ckranz),  Principal Solutions Architect responsible for Storage and Virtualisation projects at leading Systems Integrator, Kelway (UK) Ltd . at the Leeds VM user group last month.  Chris first encountered virtualisation...
    on17 May 2011

  • Blog Post: Guest Clustering–What is it and do you need it?

    I am pretty sure the term guest clustering is not a standard industry term nor is it official Microsoft speak, so what do I mean by it? I mean the business of creating a cluster out of a group of virtual machines – you might call this a virtual cluster but that might confuse it with clustering physical...
    on9 May 2011

  • Blog Post: Event Handling for the IT Professional

    My diary is solid for the next few weeks as there seem to be a lot of events on. This is good for me as the best bit of my job is swapping ideas and stories with like minded individuals, not to mention the odd lively debate.  I also get the impression that many of you enjoy this too and I often...
    on10 Apr 2011

  • Blog Post: Using System Center Advisor

    In my last post I fired up the new release candidate of System Center Advisor , and this is what it looks like after I have left it running across a couple of servers I have pointed to the servers.. Just one thing to note, in my last post I introduced Advisor as “essentially Systems Center Operations...
    on6 Apr 2011

  • Blog Post: Bye bye Atlanta, Hello System Center Advisor

    One of the many announcements to come out of the recent Microsoft Management Summit was System Center Advisor . Essentially this is Operations Manager (SCOM) in the cloud, so a sort of InTune for servers.  I had a look at the precursor to this, Project Atlanta back in January, but at the time it...
    on4 Apr 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: SQL Server and dynamic memory with Hyper-V in Windows Server 2008 R2 sp1

    Running SQL Server in a virtual machine is a good thing for many reasons however there are two basic rules: don’t over commit processors use fixed or pass through disks (i.e. not dynamic one) The guidance from the SQL CAT (SQL Server Customer Advisory Team) doesn’t extend to memory as up until now you...
    on28 Feb 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: Project Atlanta part 2–Installation

    Following on from last post I thought I had better fire up Atlanta to see what it cold find out about my demon environment. I made this screencast as I installed and configured it .. It only took a few minutes to get to the stage where I had two servers, one (Oxford-DC, a server with no SQL Server on...
    on19 Jan 2011

  • Blog Post: Project Atlanta part 1 – Introduction

    In the post Christmas rush to get fit the well off will have personal trainers assigned to them to help get back into shape. Similarly in the world of SQL there is an abundance of experts to help ensure that SQL server is as lean and mean as possible, however not everyone can afford that expertise, or...
    on18 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: SQL Server performance in a virtual world

    Despite doing quite a few posts and talks on Virtualising SQL Server, I am still getting the odd comment on earlier posts, so please forgive this if you have heard it all before. Firstly these are my musings on the topic to date: Virtualisation for the DBA part 1  - Are you bovvered? Virtualisation...
    on23 Nov 2010

  • Blog Post: TechEd Berlin Day 1

    Simon and i are at TechEd Berlin all week, his post on the keynote is here.  I didn’t get to that as I was setting up BI demos al day on the SQL Server stand. I got asked a couple of interesting SQL Server questions I thought I would share: I have SQL Server 2008 but not R2 what BI features do I...
    on10 Nov 2010

  • Blog Post: SQL Server Reporting Services interop part 2

    I forgot one thing on my recent post on Reporting services interop, Report Builder.  What is Report Builder? it’s an end user (information worker in Microsoft speak), tool that creates a report that can run in SQL Server reporting services.  What this actually means is that it creates a xml...
    on2 Sep 2010

  • Blog Post: SQL Server Redundancy

    When I saw SQL Server redundancy on a recent internal e-mail I wondered if it was about a replacement for SQL Server , DBA job losses, or the rise of the NoSQL movement.  It turned out to be nothing more than a general ask about the pros and cons of clustering and mirroring. If there are internal...
    on31 Aug 2010

  • Blog Post: SQL Server Reporting Services interop

    SQL Server Reporting Services is nearly ubiquitous as SQL Server itself, it is in nearly all versions of SQL Server from Express (with Advanced services) to DataCenter edition and will soon be available in SQL Azure. It’s been around for 8 years and if Microsoft used traditional version numbers...
    on23 Aug 2010

  • Blog Post: Spatial Referencing Systems in the UK

    I have had a couple of queries about spatial data in SQL Server regarding SRIDs.  I have posted already on some of this here , and while I mentioned SRIDs I didn’t really cover what that means so hopefully this explains it... First of all the term Spatial Reference Identifier ( SRID ) is a European...
    on11 Aug 2010

  • Blog Post: Tricking a client into connecting to a SQL Server Instance

    One of the challenges of consolidation and upgrades is that some applications might have hard coded or difficult to find references to the server instance they are connecting to. When you want to point this hypothetical application to the non-default instance on a new server you can often use DNS to...
    on16 Jun 2010

  • Blog Post: Free Tickets to the SQL Master Class

    Here’s a problem how do you give away 2 tickets to the SQL Server master class with Kimberly Trip  and Paul Randall ?  The logical answer is to ask a technical question, but if it’s too hard the winner who answers it won’t get the same benefit from going to the master class.  Of course...
    on8 Jun 2010
Page 1 of 10 (237 items) 12345»