Insufficient data from Andrew Fryer
The place where I page to when my brain is full up of stuff about the Microsoft platform
Windows Server 2008 Hyper-V – is it any good?
I was presenting SQL server 2008 at a NextGen community event and there was a Windows Server 2008...
Author: Andrew.Fryer Date: 06/12/2008
Using Full Text Searching SQL Server 2008
I have now got SQL Server 2008 RC0 running in my Hyper-V 64-bit virtual machine, complete with the...
Author: Andrew.Fryer Date: 06/11/2008
Installing SQL Server 2008 rc0
Installing SQL Server 2008 RC0 on windows server 2008 is very straightforward, except that I...
Author: Andrew.Fryer Date: 06/10/2008
Running SQL Server on Windows Server 2008
I pulled down SQL Server 2008 RC0 over the weekend and I thought it would be good to get this...
Author: Andrew.Fryer Date: 06/09/2008
SQL Server 2008 RC0
I was going to post about how to search full text in SQL server 2008, but hold the phone SQL Server...
Author: Andrew.Fryer Date: 06/06/2008
A rough guide to Full Text Search in SQL Server 2008
Full text search has been around in SQL Server since the 2000 edition and has gradually evolved in...
Author: Andrew.Fryer Date: 06/05/2008
Microsoft SQL Server Community Utilities
As well as the independent SQL communities, there is also a Microsoft run one, the Microsoft SQL...
Author: Andrew.Fryer Date: 06/04/2008
Analysis Services debugging& tuning
I keep recommending IT Professionals to check out codeplex for the various samples that are on there...
Author: Andrew.Fryer Date: 06/03/2008
Using TinyInt as keys in Analysis Services
Fact tables should be narrow and deep. If you are recording every debit card transaction for...
Author: Andrew.Fryer Date: 05/30/2008
Data Mining Epiphany
Data Mining is like Web 2.0, everyone has their own idea of what it is, and there are loads...
Author: Andrew.Fryer Date: 05/29/2008
Server Quest
The word is out that I am the PC Gamer in Eileen’s team. I started on a Pr1me computer that had a...
Author: Andrew.Fryer Date: 05/28/2008
SQL Server 2008 Community Launch
The London SQL Server Community have a SQL Soiree on 19th June at Cardinal Place from 6-9pm. This is...
Author: Andrew.Fryer Date: 05/27/2008
Deprecated Features in SQL Server 2008
My first ever post was about the features in SQL Server 2000 that were deprecated in SQL Server 2005...
Author: Andrew.Fryer Date: 05/27/2008
SQL Server 2008 Filtered Indexes vs Index Views
SQL Server 2008 has a new feature called filtered indexes which are like normal table indexes only...
Author: Andrew.Fryer Date: 05/22/2008
Open Business Intelligence, spoilt for choice
Let me start with a little history of Microsoft BI. Microsoft acquired an OLAP tool from a company...
Author: Andrew.Fryer Date: 05/21/2008
PASS Meeting 26th June
The Professional Association for SQL Server (PASS), is holding it's next meeting on 26th June from...
Author: Andrew.Fryer Date: 05/20/2008
Art for Arts Sake
A little while ago James discovered a fun little app (SP-Studio) for SouthParking...
Author: Andrew.Fryer Date: 05/19/2008
SQL Server 2008 – Annoyingly Helpful
One of the features that has often been asked for is intellisense for T-SQL and this is now...
Author: Andrew.Fryer Date: 05/16/2008
Are we spending too much time with Excel?
Despite my love of SQL Server and my respect for Oracle, and MySQL the worlds number one database is...
Author: Andrew.Fryer Date: 05/15/2008
Vista sp1 vs XP sp3
When I am not playing with SQL Server, I play PC games, such as Gears of War and Flight Simulator X,...
Author: Andrew.Fryer Date: 05/12/2008
Primary keys and Clustered Indexes
One of the many great SQL Server resources out there is SQL Server Central, and this article on...
Author: Andrew.Fryer Date: 05/11/2008
SQL Server 2008 Back to Basics
With all of the BI stuff in SQL Server , the new data types like filestream and geography, it is is...
Author: Andrew.Fryer Date: 05/08/2008
SQL Server 2008 Performance
It is already possible to get an indication of how well SQL Server 2008 will perform before it is...
Author: Andrew.Fryer Date: 05/07/2008
Virtualized SQL Server
[Note the information in this post is now way out of date, so please refer to my post here instead.....
Author: Andrew.Fryer Date: 05/07/2008
Better Data with Metadata
Metadata (data about data) is becoming increasingly popular not just to meet ever more stringent...
Author: Andrew.Fryer Date: 05/06/2008
Windows Server 2008 and SQL Server 2005
One way to speed up SQL Server 2005 is to upgrade the underlying operating system to Windows 2008....
Author: Andrew.Fryer Date: 05/02/2008
SQL Server 2008 & Windows Server 2008 RODC
One of the many interesting new features in Windows Server 2008 is the Read Only Domain Controller...
Author: Andrew.Fryer Date: 04/30/2008
The Technology Garden
I’m at the Insight Architects Conference today and I have just been sitting in on the keynote from...
Author: Andrew.Fryer Date: 04/29/2008
Big Dimensions – Just because you can …
One of the limitations of Analysis Services in SQL Server 2000 (AS 2000) was that a member in a...
Author: Andrew.Fryer Date: 04/28/2008
TechNet Subscription- Shameless Plug
One of the challenges of modern working life is reconciling individual effort with team achievement....
Author: Andrew.Fryer Date: 04/27/2008
SQL Server Starvation
During our current round of TechNet road shows we are focusing on Windows Server 2008 and I open my...
Author: Andrew.Fryer Date: 04/25/2008
SQL Server Home Grown
It seems very fashionable to buy in technology these days, and some of you must if anyone is...
Author: Andrew.Fryer Date: 04/24/2008
SQL Server Disk I/O on Windows Server 2008
Imagine you work in a library and it’s your turn to put the books away that have just been...
Author: Andrew.Fryer Date: 04/21/2008
SQL Community and the Curse of The Cursors
So following form my last post, Eric Alsop’s session for the SQL Community last night was on cursors...
Author: Andrew.Fryer Date: 04/18/2008
The Cursors of SQLStein
The wacky title of this post is courtesy of a friend of mine Eric Alsop of IMGroup; it's the...
Author: Andrew.Fryer Date: 04/16/2008
Using Oracle data with Microsoft Business Intelligence
Before I joined Microsoft, I was working on a large project to build SQL Server 2005 analysis...
Author: Andrew.Fryer Date: 04/15/2008
Upgrading to SQL Server 2008
Back on 19th March I did a presentation on upgrading to SQL Server 2008, as part of the UK Launch...
Author: Andrew.Fryer Date: 04/14/2008
Encryption Everywhere
I often show the Transparent Data Encryption (TDE) feature in SQL Server 2008, and then I get asked...
Author: Andrew.Fryer Date: 04/11/2008
2008 Launch Videos
Blogging is easy to do, there’s no one watching you and you can martial your thoughts. ...
Author: Andrew.Fryer Date: 04/10/2008
End of mainstream support for SQL Server 2000
My first ever blog post was about the features of SQL Server 2000 that won’t work in SQL Server...
Author: Andrew.Fryer Date: 04/08/2008
SQL Server Consolidation
Whether you are into virtualisation or not, most organisations want to reduce the number of SQL...
Author: Andrew.Fryer Date: 04/07/2008
SQL Server 2008 Policy Management Blogcast
Here’s another SQL Server 2008 blogcast on manageability, this time on using Policy Management, to...
Author: Andrew.Fryer Date: 04/04/2008
SQL Server 2008 Configuration Servers – Blogcast
Following on form my post on configuration servers in SQL Server 200, I thought you might like to...
Author: Andrew.Fryer Date: 04/03/2008
Microsoft Licensing
Along with particle physics and rail travel, software licensing is at the forefront of modern...
Author: Andrew.Fryer Date: 04/02/2008
SQL Server 2008 editions
One of the things I think is odd about Microsoft is the hard line placed between developers and IT...
Author: Andrew.Fryer Date: 04/01/2008
SQL Server 2008 Configuration Servers
Following on from my last post, when DBA’s have to manage multiple SQL Server 2000 instances...
Author: Andrew.Fryer Date: 03/31/2008
SQL Server 2008 Best Practice
In SQL Server 2000 and 2005 there is a really useful utility called the Best Practice Analyzer which...
Author: Andrew.Fryer Date: 03/30/2008