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
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 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 2008
SQL Server 2008 Change Data Capture
One of the things that isn’t really clear form all the blurb about SQL Server 2008 is how the various new features affect each other and what’s already in SQL Server. So I wasn’t surprised to see questions being asked about Change Data Capture (CDC) and its affect on the log and specifically log shipping...
1 Sep 2008
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...
30 Mar 2008
On the Twelfth Day of Christmas an IT Pro sent to me...
Twelve New Servers Coming The product guys at Microsoft have been busy so there are going to be lots (but not 12) of new servers coming out this year: Windows Server 2008 (in 8 exciting flavours depending on whether you need virtualization or not) SQL Server 2008 editions: developer, express,...
5 Jan 2008
SQL Server edition sprawl
One of the confusing things about SQL Server is all the editions it comes in and one of the great things about SQL Server is er… all the editions it comes in. Recent additions to this edition sprawl are the SQL Server DataCenter edition, the SQL Server Parallel data warehouse and SQL Azure. Why is this...
3 Feb 2010
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...
9 Aug 2013
SQL Server Advent Calendar 14 – Integration Services Lookups
Day 14 of my virtual advent calendar, about stuff I like in SQL Server 2008.. If it aint broke don’t fix it, is probably best aimed at Integration Services in SQL Server 2008. So what was ‘fixed’? The most important thing was the performance of lookups, both in terms of speed and memory usage. ...
14 Dec 2008
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...
12 Oct 2009
SQLBits Goes West 19-21 November, Newport
When I am not doing the day job I like to draw and paint to relax so I have combined a bit of business & pleasure for the SQL Bits Goes West conference by doing a few cartoons for them… As you can see the event has grown to three days. While there has always been a deep dive, paid for training...
26 Aug 2009
SQL Server 2008 Encryption Keys
Encryption, Keys and certificates etc. are complicated and confusing judging by the number of support calls coming in from DBA's. As I said in my last post , Transparent Data Encryption is there to stop someone walling off with your data. A database can be encrypted using a key which is stored...
24 Dec 2007
SQL Server 2008 reporting takes off!
CTP5 has only been out for a week and so I was amazed that I got a comment on my blog from a specialist data and planning company operating in the aviation industry in the US. The company, US Aviation Data and Planning Corp (USADAP) are migrating their reports to SQL Server 2008 as I write...
1 Dec 2007
SQL Server 2008 ctp6
I have been to lots sessions on SQL Server 2008 at Microsoft's internal technical training fest (TechReady) over the last couple of weeks, and I wanted to post about but the new for CTP 6 stuff , but only when you can try it for yourselves. I wondered if there was any buzz in the public domain around...
19 Feb 2008
SQL Server Books On-Line
Staring the obvious here but SQL Server books on-line (BOL) is called that for a reason, it’s constantly being updated …on-line. I mention this because every now and then a new version becomes available for download, and in fact there was an update for SQL Server 2008 BOL on 30 January. Keeping...
5 Feb 2009
SQL Server Advent Calendar 19 – Data Collection
Day 19 of my virtual advent calendar, about stuff I like in SQL Server 2008.. I often get asked how much faster is SQL Server 2008 than SQL Server 2000, what impact will virtualisation have on my performance, and my answer in fine Microsoft tradition is it depends. So how can we begin to answer...
19 Dec 2008
SQL Server 2008 Webcasts
If you want to get an insight of what's hot on the next version of Reporting Services, you can't really do better than get it straight from one of the product managers. So checkout Jason Carlson the Principal Product Manager for reporting services who is presenting a webcast on 1 November. Of course...
24 Oct 2007
SQL Server 2008 Intellisense support for SQL 2000/5
Intellisense for SQL, how hard is that? Well judging for how long we have been asking for it the answer is “very”. Also talking to the product team it is actually much harder than for C# VB etc. because of the nature of SQL. Anyway intellisense appeared in CTP5 of SQL Server 2008 and at that...
11 Aug 2008
Virtualisation for the DBA part 3 – SQL Server Performance
As I have said already in this series the major concern most DBA’s have when virtualising SQL Server is performance. I think this is actually a bit of myth for a number reasons: Virtualisation just keeps getting better . This is down to a partnership between the hardware and software industries...
20 Oct 2009
SQL Server Advent Calendar 10 – Reporting Services Charts
Day 10 of my virtual advent calendar, about stuff I like in SQL Server 2008.. I have been using Reporting Services since beta 2 in SQL Server 2000, and for me the weak link was the charts which even then looked pretty basic… Many people resorted to using add-ons including the ubiquitous Dundas...
10 Dec 2008
SQL Server 2008 Spatial Data Types
Continuing my series of notes following the TechNet event last Thursday evening, I wanted to explain that in SQL Server 2008 there are two new data types for storing spatial information; geometry and geography. Unfortunately on Thursday I didn't have the final release of CTP5 so my demo...
26 Nov 2007
SQL Server 2008 Plan Guides
So here’s how it’s done.. So here’s how it’s done..I rarely know more about SQL Server than my friend Beatrice so I was surprised when I mentioned plan guides and she hadn’t heard of this new feature. I have to say this is not a big mainstream thing and it takes me back query hints in SQL Server 2000...
14 Nov 2008
Barriers to upgrading to SQL Server 2008
Most IT Professionals like to use the latest (stable) version of a product, so what’s holding up your adoption of SQL Server 2008? Hardware. If you are moving from SQL Server 2000 to 2008 that’s probably going to mean a new server as you’ll probably want to move to 64 bit hardware and that could be tricky...
20 Oct 2008
SQL Server 2008 Management event in Manchester
Unlike Manchester United, SQL Server 2008 is under new management. What I mean by this is that there are a load of new tools to configure, tune and audit which are essential to keep a modern database in the premiership. While I have done a few events on this theme in the London area, the TechNet...
29 Sep 2008
SQL Server 2008 Activity Monitor
Activity Monitor is a simple and quick way to see what’s happening right now in SQL Server, Not too much happening on my demo rig but you get the idea. It took me a few minutes to open this because my local books on line has an error in it on how to open it (it suggests expanding form the management...
25 Nov 2008
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...
24 Jun 2011
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...
9 May 2011
SQL Server 2008 sickness
Only in Microsoft could you get a job in evangelism without being religious. So I suppose I shouldn't be surprised that there are Microsoft clinics without doctors. Clinics do provide help and I found one called what's new in SQL server 2008 . It'll take a couple of hours to get the cure, but there isn...
26 Oct 2007
© 2015 Microsoft Corporation.
Privacy & Cookies