Skype for Business
See all products »
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Second shot for certification
Born To Learn blog
Find technical communities in your area
For small and midsize businesses
For IT professionals
For technical support
For home users
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Insufficient data from Andrew Fryer
The place where I page to when my brain is full up of stuff about the Microsoft platform
Application Lifecycle Management
Azure Machine Learning
Data Protection Manager
Essential Business Server
Full Text Search
Microsoft Security Essentials
Performance Point Server
Read Only Domain Controller
Remote Desktop Services
Slowly Changing Dimensions
Software + Services
SQL Server 2008
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
SQL Server Express
TechNet Road Show
Windows Server 2008
Windows Server 2008 R2
Windows Server 2012
Windows Server 2012R2
Browse by Tags
Insufficient data from Andrew Fryer
Data, no use at all without a catalog
About a decade a go I went on a Microsoft BI boot camp which was also attended by Microsoft staff specifically Matthew Stephen and Rob Gray who inspired me to work towards joining Microsoft myself. Two years later I got in and haven’t looked back and I still track Matt on LinkedIn, so I was very interested...
6 Oct 2015
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...
31 Oct 2008
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...
11 Feb 2008
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...
12 Oct 2009
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...
6 Nov 2007
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...
18 Dec 2008
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...
25 Feb 2008
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...
18 Feb 2011
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...
4 Oct 2007
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...
19 Mar 2013
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...
26 Apr 2010
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...
4 Jan 2011
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...
5 Oct 2010
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...
14 Mar 2013
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...
18 Oct 2010
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...
30 Mar 2010
© 2015 Microsoft Corporation.
Privacy & Cookies