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
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 phone 7
Windows Server 2008
Windows Server 2008 r2
Windows Server 2012
Windows Server 2012R2
Browse by Tags
Insufficient data from Andrew Fryer
sql server 2012
Tagged Content List
Lab Ops 2–The Lee-Robinson Script
In my last post I mentioned how Marcus Robinson & had adapted PowerShell scripts by Thomas Lee to build a set of VMs to run a course in a reliable and repeatable way. With Marcus’s permission I have put that Setup Script on SkyDrive, however he has a proper day job running his gold partnership...
20 Sep 2013
Microsoft Valuable Penguin
I sometimes think the IT industry is a bit like a load of penguins on the pack ice, each one checking the others out to see who going to brave the ocean first. In IT it’s nervousness about when to jump onto a new technology and if there is one technology that makes IT professionals really nervous...
13 Aug 2013
SQL Server Spruce up
Landrovers, will take a lot of pounding and neglect, but when my wife drove hers to Australia she made very sure it was properly set up for 2 years on the road Similarly SQL Server is also often out in the wild far from DBA’s and inspection from maintenance tools, like System Center . However now...
8 Aug 2013
Installing SQL Server in a Virtual World
I do get occasional feedback that SQL Server is hard to install, all those screens all those checkboxes etc. etc. This is simply a reflection that there is so much in SQL Server aside form the database engine, however if you know what you want and you are doing this regularly then script it, if...
29 Jul 2013
Virtualizing Tier 1 SQL Server
A while back I published a couple of posts on virtualizing SQL Server, and in the light of developments in both the virtualization platform out there and SQL Server itself I feel the need to do a complete rewrite. The traditional approach to implementing high availability (HA) in SQL Server has...
22 Jul 2013
Server 4024 part 3 - Networking
Databases are typically bound either by networking or IO and actually this can be two sides of the same coin if you are using remote storage. So what’s new in Windows Server to improve networking both to improve access to shared storage and access to database workloads from another tier in a service...
9 Jul 2013
Server 4024 part 2 - Management
In the second post in this series I wanted to look at how changes to the way you manage things in Windows Server 2012 (WS 2012) affects your management of SQL Server 2012 (SQL 2012). Multi Server Management Traditionally to manage the OS we used to remote desktop onto every server we managed and applied...
12 Jun 2013
Server 4024 part 1 – Virtualisation
A database is only as good as the operating system it resides on. SQL Server only runs on Windows and given that Windows Server 2012 (WS2012) is a huge change from what there was in Server 2008 R2 what does this new OS mean for the DBA. The reference to Server 4012 is because that would be WS2012...
29 May 2013
Evaluate This – Storage Spaces
So far in this series I have used the new storage features of Windows Server 2012 as a place to run VMs from, but there’s more to it than that. Shared storage used to mean presenting SAN storage inside a cluster, and you relied on your SAN experts to provision the storage you needed. ...
6 Feb 2013
MCSE for SQL Server
I have to be honest I gave up getting certified before I joined Microsoft mainly because the exams didn’t keep up with the release of SQL Server specifically the Business intelligence exams. I then had the same problem as an evangelist I was working on the next release of the SQL or Windows Server. However...
31 Aug 2012
Contain your Enthusiasm
You may be aware that I am still keen on SQL Server and despite the changing nature of my role at Microsoft I still try and keep my hand in with the latest version. One thing I overlooked until I did SQL Relay was contained database security which is easy to use and can make your life a lot easier...
29 May 2012
SQL Relay Notes and Queries
I wanted to something different for SQL Relay last week as this is a community driven event and I didn’t want to cover areas that the other experts on the Relay team would cover. This left some gaps and I have had several follow up questions via twitter and e-mail which I want to cover in this post....
28 May 2012
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...
7 May 2012
Drinking the Champagne – SQL Server 2012 on Windows Server 8
Dogfood is the commonly described term for running your own beta software, however I prefer the term drinking your own champagne and to that end I have spent a days leave today playing Window Server 8 . Yes its very different to what you have seen before and rather like having the decorators...
5 Apr 2012
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...
7 Mar 2012
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...
6 Feb 2012
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...
6 Feb 2012
Data Transformation Services is the bit of SQL Server that helped pay for my house, car and some really nice holidays. I first got to use it some 12 years ago and after working with BCP (bulk copy program) it was just so easy, I was sucking data out of AS400/RPG, Oracle and Sybase to create data...
26 Jan 2012
Some SQL Server 2012 upgrade advice for ISVs
I have spent a lot if time recently briefing Independent Software Vendors (ISVs) on SQL Server 2012,so I thought a consolidated post on the subject might be useful for those planning to develop solutions on top of SQL Server 2012. New Features that will just work By this I mean there are some new...
18 Jan 2012
NO SQL Server
I spent last Thursday at Black Marble’s Architect Forum and my slot was on SQL, NoSQL, some SQL. It went down very well but I used OneNote on my tablet not PowerPoint and like all modern art my drawing needs a bit of explaining.. Databases were originally used to store transactions which are highly...
10 Dec 2011
SQL Server 2012 – TSQL
I have to confess I hadn’t paid too much attention to the changes to T-SQL in SQL Server 2012, and it was only a question at NextGenUG in Abingdon last night that prompted me to have a look. It turns out there are some really useful new commands , which I could certainly have done with when I was...
16 Nov 2011
SQL Server 2012 – Always On
There have always been several ways to do high availability in SQL Server, but choosing the right one has always been difficult as each approach has obvious benefits coupled with unavoidable limitations: Clustering looks after a whole instance of SQL Server containing many databases and is completely...
15 Nov 2011
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...
8 Nov 2011
SQL Server 2012 and the private cloud
Putting up a marketing slide that says SQL Server is a good private cloud citizen is good marketing, but what’s in the box to back the claim up? My top three would be: Windows Server core . Patching is a major maintenance problem with lots of virtual machines, and server core cuts that in half...
1 Nov 2011
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...
5 Oct 2011
Page 1 of 2 (48 items)
© 2013 Microsoft Corporation.
Privacy & Cookies
See all products »
Curah! curation service
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
Compatability & Converters
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
Support by product
Forefront Edge Security
Forefront Server Security
Other support links
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Look up event IDs and error codes
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums