Insufficient data from Andrew Fryer
The place where I page to when my brain is full up of stuff about the Microsoft platform
SQL Server Upgrade Assistant
I want to mention another tool for obtaining a more thorough analysis of upgrade issues developed in...
Author: Andrew.Fryer Date: 03/29/2008
Upgrading SQL Server Business Intelligence
Continuing my series of posts on upgrade, I thought it might be good to have a look at the business...
Author: Andrew.Fryer Date: 03/28/2008
SQL Server Upgrade Advisor
One of the things that made me smile at my launch presentation on upgrading SQL Server was that when...
Author: Andrew.Fryer Date: 03/26/2008
SQL Server Compatibility Mode
I drew the short straw at the 2008 Launch event last week in Birmingham; speak for one hour on...
Author: Andrew.Fryer Date: 03/25/2008
SQL Server Jobs
After the tax man, probably the most hated profession in the IT industry is the recruitment...
Author: Andrew.Fryer Date: 03/17/2008
SQL Server 2008 on Windows Server 2008
I am a huge fan of Windows Server 2008. I am lucky enough to have a laptop that...
Author: Andrew.Fryer Date: 03/14/2008
Word Reports from SQL Server 2008
I was doing a demo to the final year business students Aston University today , and I noticed that...
Author: Andrew.Fryer Date: 03/13/2008
European PASS Conference 2008
If you can't make the launch, and weren't at SQL Bits a couple of weeks ago then why not convince...
Author: Andrew.Fryer Date: 03/12/2008
Upgrading Data Transformation Services (DTS)
One of the biggest headaches in migrating away from SQL Server 2000 is Data Transformation Services...
Author: Andrew.Fryer Date: 03/12/2008
Excel OLAP add-in
Excel already has always had excellent support for analysis services, but to get the best form it...
Author: Andrew.Fryer Date: 03/10/2008
SQL Server 2008 Resource Kit
I was at an evening event to kick of specialist Finance based chapter of PASS (Professional...
Author: Andrew.Fryer Date: 03/10/2008
SSDS
A quick scan of the web will pick up meanings for SSDS: Secure Software Distribution System Self...
Author: Andrew.Fryer Date: 03/06/2008
Zune?
Occasionally in the dark corners of e-bay, and amazon you'll find this odd mp3 player for sale...
Author: Andrew.Fryer Date: 03/04/2008
SQL Server Reporting Services - Report Designer
I was at SQL Bits (the SQL) at Aston University on Saturday and as usual if I can't answer a...
Author: Andrew.Fryer Date: 03/03/2008
SQL Server 2008 Sparse Columns
Sparse Columns are another new feature of SQL Server 2008 and are included in the February CTP...
Author: Andrew.Fryer Date: 02/28/2008
SQL Server Schema Design
I have seen some strange schemas in my time which look like a good idea on paper but not on disk. A...
Author: Andrew.Fryer Date: 02/27/2008
Performance Point Evolution
I thought you might find this article in the Data Warehousing Institute (TDWI) interesting. ...
Author: Andrew.Fryer Date: 02/25/2008
Management Reporter - the new FRx
One of the worst reporting headaches is producing output for the finance department. ...
Author: Andrew.Fryer Date: 02/25/2008
SQL Server 2008 Filtered Indexes
I have seen the filtered indexing in SQL Server 2008 mentioned a couple of times over the last...
Author: Andrew.Fryer Date: 02/21/2008
SQL Server 2008 CTP6 now available
CTP6 is now available for download here. This has all the functionality of the final product and...
Author: Andrew.Fryer Date: 02/20/2008
SQL Server 2008 ctp6
I have been to lots sessions on SQL Server 2008 at Microsoft's internal technical training fest...
Author: Andrew.Fryer Date: 02/18/2008
TechNet Mile High Club
British Airways not only run Vista for the in flight entertainment system, They also serve up...
Author: Andrew.Fryer Date: 02/18/2008
TechReady - Vista sp1 Testing
The geeks in Microsoft have taken over down town Seattle for the week as we all get our six monthly...
Author: Andrew.Fryer Date: 02/14/2008
Analysis Services and Excel Pivot Tables
Excel is the number one business intelligence tool; It fronts Hyperion, Cognos Financial...
Author: Andrew.Fryer Date: 02/12/2008
Compliance in SQL Server
I often get asked about whether SQL server is compliant with some standard or other e.g....
Author: Andrew.Fryer Date: 02/10/2008
SQL Server 2008 BI, Perception & Reality
Following all the acquisition mania in the BI marketplace last year, it's interesting to see that...
Author: Andrew.Fryer Date: 02/08/2008
SQL Server 2008, 9 or 10?
I am in soggy Seattle this week with a bunch of like minded SQL squirrels, so our super Tuesday was...
Author: Andrew.Fryer Date: 02/07/2008
SQL Server 2008 Geo-Spatial functions and indexes
SQL Server 2008 enables the use of geo-spatial data or location intelligence in four ways: a new...
Author: Andrew.Fryer Date: 02/05/2008
SQL Server 2008 Geometry Data
One of the problems with our TechNet road shows is getting at the content after the event. Of course...
Author: Andrew.Fryer Date: 02/04/2008
SQL Server 2008 & Virtual Earth
There's a lot of buzz around Software plus Services (S+S) from Microsoft and others. It's all...
Author: Andrew.Fryer Date: 02/01/2008
SQL Bits Conference Calling
This is a short post to say thanks to all the MVP's working hard to organise the next SQL Bits...
Author: Andrew.Fryer Date: 01/31/2008
Monitoring Reporting Services
Reporting services, like many services, logs what is going on to to a log file, in this case the RS...
Author: Andrew.Fryer Date: 01/31/2008
SQL Server 2008 RTM Date
There's no easy way to write this but SQL Server 2008 won't be released (RTM) until Q3 of 2008,...
Author: Andrew.Fryer Date: 01/30/2008
Peas and Carrots are off
Unfortunately, the You Tube link in my previous post has been pulled. For those that didn't...
Author: Andrew.Fryer Date: 01/28/2008
Peas and Carrots
I hate vegetables, and I have many happy memories of implementing business intelligence solutions in...
Author: Andrew.Fryer Date: 01/25/2008
2008 Launch Wave
The official launch of Windows Server 2008, SQL Server 2008 and Visual Studio 2008 will happen on...
Author: Andrew.Fryer Date: 01/24/2008
Many to Many Dimensions
One of the many cool things that's already in Analysis Services in SQL Server 2005 (SSAS) is the...
Author: Andrew.Fryer Date: 01/22/2008
SQL Server BI Everywhere
Nearly everything Microsoft brings out these days has a SQL Server back-end, except Exchange as...
Author: Andrew.Fryer Date: 01/22/2008
Champion IT
Georgina (aka Curious George) and Faith who look after all things TechNet have this Champion IT...
Author: Andrew.Fryer Date: 01/16/2008
SQL Server for Data Mining
SQL Server 2005/2008 has a number of data mining algorithms built in to discover hidden...
Author: Andrew.Fryer Date: 01/15/2008
Data Mining - Good for Your Health?
Using Data Mining techniques to establish and predict trends is a black art with as many myths and...
Author: Andrew.Fryer Date: 01/14/2008
Evangelism Evangelism Evangelism
The IT Pro Evangelist team are all at a huge education event , BETT, this week. Viral, Steve,...
Author: Andrew.Fryer Date: 01/10/2008
A Funny Thing Happened on the Way to the TechNet Forum
Forums (fora for Latin geeks) date back to well before Microsoft and even Frankie Howerd. TechNet...
Author: Andrew.Fryer Date: 01/09/2008
SQL Bits the SQL
Following the huge success of SQL Bits last year Tony Rogerson and the UK SQL Server Community have...
Author: Andrew.Fryer Date: 01/08/2008
Data Mining in SQL Server 2005, 2008
Data Mining like every other term in business intelligence seams to mean different things to...
Author: Andrew.Fryer Date: 01/07/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...
Author: Andrew.Fryer Date: 01/05/2008
On the Eleventh Day of Christmas an IT Pro sent to me...
Eleven Pipelines Piping Screensavers I have known and loved! Technorati Tags: fun
Author: Andrew.Fryer Date: 01/04/2008