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: Evaluate This–File Classification

    In my last post & screen cast I showed how Dynamic Access Control (DAC) worked; the business of matching a users claims to the properties of a file (Resource Property in DAC), however the problem then becomes how do I correctly tag my files so that DAC works.  You shouldn’t necessarily be doing...
  • 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: Five New Year’s Resolutions for 2011

    I  think a lot of people, IT Professionals included are worried about the year ahead, so here are some likely problems and my new year resolutions: Energy prices are spiralling This means the cost of moving whole atoms rather than just electrons is even more pronounced than ever, so moving data...
  • Blog Post: Microsoft is all in

    When Steve Ballmer says “We’re all in the cloud”  this should be viewed in the same way as when  Bill Gates talked about “a PC in every home”.  I could quote statistics on the investment Microsoft is making in the cloud or show you some cool pictures of containers in one of the data centres...
  • Blog Post: Evaluate This – Dynamic Access Control

    Managing users access to the right files is a pain on any OS, the best that’s going ot happen is that no one will complain about not having access to a file while none of your sensitive company data gets into the wrong hands.  In a traditional hierarchical business life was pretty easy you had a...
  • Blog Post: System Centre Configuration Manager 2007 R3– going for green

    I have never heard of an R3 of a Microsoft product before so I wanted to know more about what’s in SCCM 2007 R3 now it’s been released.  First of all the R3 suffix is about Microsoft being clear on the differences between release service packs etc.  A release is about added functionality without...
  • Blog Post: Spotting Databases

    SQL Server has a habit of popping up here and there without you necessarily knowing about it. This is a testament to its versatility and how it will generally just keep on going often without support from the IT team. However in age of auditors, risk management and compliance, you do really need to...
  • Blog Post: Governance, Risk Management & Compliance

    Blog posts which just reference whitepapers etc. can annoy some of you so I try and limit these, but if you are one of the many IT managers or DBA’s worried about compliance then please read on. The IT Compliance Guide    is a comprehensive guide to all of those annoying acronyms that seem...
  • Blog Post: Compliance in SQL Server

    I often get asked about whether SQL server is compliant with some standard or other e.g. Sarbannes-Oxley (SOX) , Data Protection etc.  The answer is yes, but there is no flip switch in SQL to turn any of these on , and as anyone knows who's tried it turning on c2 security is a great way of slowing...
  • Blog Post: SQL Server Security

    Security should be everyone’s business,  but it’s often seen as someone else’s problem.  When it comes to SQL Server there are at least three parts to the puzzle: The infrastructure guys will provide secure comms and accounts with which to access SQL Server. The developers be they in house...
  • Blog Post: Compliance

    The IT industry is awash with acronyms, Microsoft is drowning in them and I think we will soon need to move to FLA (Five Letter Acronyms) to keep up - I thought MSRC was the Microsoft Research Centre but Steve insists its' the Microsoft Response Center, and we're both right! However we are not alone...
  • Blog Post: SQL Server Advent Calendar 18 – Audit

    Day 18 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Rounding out ways of keeping an eye on what’s happening to your data in SQL Server 2008 is the new auditing feature in Enterprise edition.  As the name suggest it’s there for a specific purpose, to make your compliance...
  • Blog Post: Management Reporter - the new FRx

      One of the worst reporting headaches is producing output for the finance department.  The reports need to meet strict standards, be penny perfect, and the end user always wants the report to be in excel.  With reporting services in SQL Server 2005 this could be done by the IT department...
  • Blog Post: Normal Service has been resumed

    I’ve just got back from 5 weeks off in NZ to celebrate my 50th lap of the sun, hence the guest posts on here recently. Just before I went away  the UK TechNet team setup  Tech Days Online .. based on a chat Simon and I had about what 2011 holds for the IT Professional which you can watch here...
  • Blog Post: SQL Server SOX Compliance

    At the SQL Server community evening last week I was asked whether SQL Server is or is going to be SOX compliant. There are probably some of you thinking that we were discussing baseball so I should explain that Sarbannes Oxley (SOX) is a piece of financial compliance legislation introduced in the US...