Insufficient data from Andrew Fryer

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

Browse by Tags

Related Posts
  • Blog Post: SQL Server 2008 Best Practice

    In SQL Server 2000 and 2005 there is a really useful utility called the Best Practice Analyzer which you can download here .  Essentially it looks at your database configuration and matches this against a set of rules to inform you you of what improvements to make, based on experience gained by...
  • Blog Post: Virtualisation for the DBA part 2 – SQL Server Management

    Given the almost mandatory drive to server virtualisation in data centres, what do you need to worry about and what’s in SQL Server to help you? The biggest worry is probably  trying to manage everything, as typically many organisations simply create a virtual machine for every physical server they...
  • Blog Post: Data Governance with SQL Server

    I thought it would be good to write up my talk at the IT Manager TechDays last week, as I get a fair number of questions and the information is not always easy to find. First let me explain what I mean by Governance: It is the policies, best practices, enforcement and training needed to address the compliance...
  • Blog Post: A last word on Policy based Management

    If I search my blog for Policy Based Management in SQL Server, I notice there are a fair few posts on the matter. I am not going to apologise for this as it’s a vital tool in any DBA’s armoury in the world of ever increasing databases compliance and risk management.  My blog is also like paging...
  • Blog Post: SQL Server 2008 Configuration Servers

    Following on from my last post, when DBA’s have to manage multiple SQL Server 2000 instances you would normally see all of them registered on their local desktop in enterprise manager under a variety of groups such as dev, prod, test etc. With the advent of SQL Server 2005 this practice seems to...
  • Blog Post: SQL Server 2008 for Developers

    There seems to be this divide between developers and DBAs.  Developers need to create databases and objects within them and of course DBAs want everything nice and tidy. SQL Server 2008 has quite a few new features fir developers including: ADO.NET entity framework to provide a semantic layer between...
  • Blog Post: 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...
  • Blog Post: SQL Server 2008 Configuration Servers – Blogcast

    Following on form my post on configuration servers in SQL Server 200, I thought you might like to see it in action so here’s a 5 minute blogcast on it…   Technorati Tags: SQL Server 2008 , Configuration servers
  • 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...
  • Blog Post: SQL Server 2008: where’s my stuff?

    For those of us who have been tracking the evolution of SQL Server 2008 through it’s long gestation it can be a bit annoying when things get moved around.  In RC0 odds and ends seem to have disappeared and the more sceptical DBA might assume the features have been pulled prior to release, however...
  • Blog Post: SQL Server 2008 Policy Management Blogcast

    Here’s another SQL Server 2008 blogcast on manageability, this time on using Policy Management, to implement best practice in SQL Server: Technorati Tags: SQL Server 2008 , Policy Management