Insufficient data from Andrew Fryer
The place where I page to when my brain is full up of stuff about the Microsoft platform
Reporting Services, the Need for Speed
As I have mentioned before Reporting Services (SSRS) in SQL Server 2008 has been completely...
Author: Andrew.Fryer Date: 01/31/2009
Hardware for SQL Server 2008
I often get asked about hardware for SQL Server, especially now with momentum for SQL Server 2008...
Author: Andrew.Fryer Date: 01/30/2009
SQL Bits goes Fourth
The hugely successful SQL Bits event is coming to Manchester on 28th March. Hopefully the more...
Author: Andrew.Fryer Date: 01/20/2009
End User/ Self Service BI
The idea of letting users design their own BI fills many experts with equal dread and delight. ...
Author: Andrew.Fryer Date: 01/16/2009
Saying Goodbye to SQL Server 2000
I have published quite a few posts on how to upgrade from SQL 2000 to 2005/8 since I started...
Author: Andrew.Fryer Date: 01/14/2009
SQL Server Editions
I recently got a comment on my blog complaining about all of the editions of SQL Server, so why...
Author: Andrew.Fryer Date: 01/12/2009
Days of Christmas – where do I get the stuff
My wife Juliet asked me a stupid question about all those Christmas Videos Viral, James and I made.....
Author: Andrew.Fryer Date: 01/09/2009
Windows Server 2008 r2 Beta
What is with operating systems? Nothing for ages then two on the same day, Windows 7 Beta and now...
Author: Andrew.Fryer Date: 01/08/2009
12th Day of Christmas – Community Clips
In my final video of free stuff from Microsoft, Viral is showing my Community Clips a screencasting...
Author: Andrew.Fryer Date: 01/06/2009
11th Day of Christmas – Live Mesh
Live Mesh is the brainchild of Ray Ozzie and is cooler than the weather outside at the moment. ...
Author: Andrew.Fryer Date: 01/06/2009
10th Day of Christmas – Windows Live Sync
Viral has made another video for my Christmas series, this time on Windows Live Sync, which allows...
Author: Andrew.Fryer Date: 01/05/2009
8th Day of Christmas – ThumbTack
The OfficeLabs guys have been busy in the run up to Christmas and have release a gizmo called...
Author: Andrew.Fryer Date: 01/01/2009
7th Day of Christmas Tagging
Properly indexing databases is generally seen as a good thing, and is one of the top causes of poor...
Author: Andrew.Fryer Date: 12/31/2008
6th Day of Christmas – Armchair Astronomy
I still love to watch the Royal Institute Lectures at Christmas, and I am please to see Microsoft...
Author: Andrew.Fryer Date: 12/30/2008
5th Day of Christmas – Deep Zoom
Deep Zoom actually does what it says on the tin. However while many people have seen demos of...
Author: Andrew.Fryer Date: 12/29/2008
4th Day of Christmas
I love PC Gaming, so I haven’t got an XBox 360 yet. However there’s no denying its popularity...
Author: Andrew.Fryer Date: 12/28/2008
3rd day of Christmas – Ducks in a Row
This blog is written using Windows Live Writer as are many of the others on TechNet and MSDN. ...
Author: Andrew.Fryer Date: 12/27/2008
2nd Day of Christmas – Brighton 360
Although Photosynth has been widely publicised in the general and IT press I still come across load...
Author: Andrew.Fryer Date: 12/26/2008
1st Day of Christmas – Looking for Vulcans
I hope you like the card (a result of a miss spent youth at Art College) and are enjoying your well...
Author: Andrew.Fryer Date: 12/25/2008
SQL Server Advent Calendar 24 – Upgrade
It’s Christmas Eve and the last day of my virtual advent calendar on SQL Server 2008.. Hopefully the...
Author: Andrew.Fryer Date: 12/24/2008
SQL Server Advent Calendar 23 - Filestream
Day 23 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Filestream isn’t one...
Author: Andrew.Fryer Date: 12/23/2008
SQL Server Advent Calendar 22 – Spatial Data
Day 22 of my virtual advent calendar, about stuff I like in SQL Server 2008.. SQL Server 2008 now...
Author: Andrew.Fryer Date: 12/22/2008
SQL Server Advent Calendar 21 - Consolidation
Day 18 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Consolidation has...
Author: Andrew.Fryer Date: 12/21/2008
SQL Server Advent Calendar 20 – Accidental DBA’s
Day 20 of my virtual advent calendar, about stuff I like in SQL Server 2008.. The accidental DBA is...
Author: Andrew.Fryer Date: 12/20/2008
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...
Author: Andrew.Fryer Date: 12/19/2008
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...
Author: Andrew.Fryer Date: 12/18/2008
SQL Server Advent Calendar 17 – Change Tracking
Day 17 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Today’s topic is the...
Author: Andrew.Fryer Date: 12/17/2008
SQL Server Advent Calendar 16 – Change Data Capture
Day 16 of my virtual advent calendar, about stuff I like in SQL Server 2008.. One of the main...
Author: Andrew.Fryer Date: 12/16/2008
SQL Server Advent Calendar 15 – Integration Services Profiling
Day 15 of my virtual advent calendar, about stuff I like in SQL Server 2008.. If there were no...
Author: Andrew.Fryer Date: 12/15/2008
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...
Author: Andrew.Fryer Date: 12/14/2008
SQL Server Advent Calendar 13 – Grouping Sets
Day 13 of my virtual advent calendar, about stuff I like in SQL Server 2008.. The SQL Group by...
Author: Andrew.Fryer Date: 12/13/2008
SQL Server Advent Calendar 12 - Tablix
Day 12 of my virtual advent calendar, about stuff I like in SQL Server 2008.. One of the...
Author: Andrew.Fryer Date: 12/12/2008
SQL Server Advent Calendar 11 – Report Builder v2
Day 11 of my virtual advent calendar, about stuff I like in SQL Server 2008.. …and I mentioned...
Author: Andrew.Fryer Date: 12/11/2008
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...
Author: Andrew.Fryer Date: 12/10/2008
SQL Server Advent Calendar 9 – Management with Powershell
Day 9 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Many SQL Server...
Author: Andrew.Fryer Date: 12/09/2008
SQL Server Advent Calendar 8 – Analysis Services Named Sets
Day 8 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Analysis Services...
Author: Andrew.Fryer Date: 12/08/2008
SQL Server Advent Calendar 7 – Partitions & Indexed Views
Day 6 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Indexed Views allow...
Author: Andrew.Fryer Date: 12/07/2008
SQL Server Advent Calendar 6 – Hierarchy Data Type
Day 6 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Using a relational...
Author: Andrew.Fryer Date: 12/06/2008
SQL Server 2008 - Hierarchy ID Data Type
To show this we need to create a table with the new data type.. create table [dbo].Organisation (...
Author: Andrew.Fryer Date: 12/05/2008
SQL Server Advent Calendar 5 – Analysis Services Performance
Day 5 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Over 80% of the budget...
Author: Andrew.Fryer Date: 12/05/2008
SQL Server Advent Calendar 4 – Filtered Indexes
Day 4 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Filtered indexes are...
Author: Andrew.Fryer Date: 12/04/2008
SQL Server Advent Calendar 3 – Analysis Services Backup
Day 3 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Backing up of analysis...
Author: Andrew.Fryer Date: 12/03/2008
SQL Server Advent Calendar 2 – Time
Day 2 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Following on from my...
Author: Andrew.Fryer Date: 12/02/2008
SQL Server Advent Calendar 1 – Dates
There is no possible connection between databases and Christmas, so I simply wanted to share 24 my...
Author: Andrew.Fryer Date: 12/01/2008
High Availability Integration Services in SQL server
I see a lot of people asking about how to make integration services highly available and there isn’t...
Author: Andrew.Fryer Date: 11/28/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...
Author: Andrew.Fryer Date: 11/25/2008
Rename the SQL Server sa account
Another good thing that’s done at the SQL Server community evenings is a 5 minute slot where anyone...
Author: Andrew.Fryer Date: 11/24/2008
When to Upgrade to SQL Server 2008
Among the interesting stuff discussed at last nights SQL community meeting at the Microsoft...
Author: Andrew.Fryer Date: 11/21/2008