Insufficient data from Andrew Fryer
The place where I page to when my brain is full up of stuff about the Microsoft platform
Mini Computing Performance
Performance Management doesn’t just apply to SQL Server, it is just as important in all aspects of...
Author: Andrew.Fryer Date: 08/28/2008
SQL Server 2008 Report Builder v2.0 RC1
As I mentioned a few weeks ago the end user reporting tool for SQL Server 2008, Report Builder v2...
Author: Andrew.Fryer Date: 08/26/2008
Career Limiting Move, SQL Server 2008 Transparent Data Encryption
Transparent data encryption (TDE) in SQL Server 2008 enterprise edition is a great tool for...
Author: Andrew.Fryer Date: 08/26/2008
SQL Server Databases and Cubes on one Server
I have put Business Intelligence into a number of small businesses and these guys typically have one...
Author: Andrew.Fryer Date: 08/22/2008
Dimension Jumping in Analysis Services
Every now and then I see an internal mail with a query and I think “What were they thinking?” In...
Author: Andrew.Fryer Date: 08/21/2008
Analysis Services Backup
Backing up a cube is not an ideal experience in SQL Server 2005 for two reasons, it’s a manual...
Author: Andrew.Fryer Date: 08/20/2008
Managing SQL Server 2008
There are loads of add-ins and management stuff from Microsoft and other vendors to make taking care...
Author: Andrew.Fryer Date: 08/19/2008
Hopping Mad with Kerberos
Like Heracles, many an IT Pro has had to wrestle with Kerberos, and for those that don’t have...
Author: Andrew.Fryer Date: 08/18/2008
Flying with Small Business and Essential Business Server
Small Business Server (SBS) is like flying a single engined aircraft. There’s a lot of stuff...
Author: Andrew.Fryer Date: 08/15/2008
Licensing in a Virtual World
Even if you work for Microsoft licensing can be complicated. I am pretty confident on what’s what...
Author: Andrew.Fryer Date: 08/13/2008
SQL Server 2008 not just for DBAs
I am sure SQL Server is administered by many ‘accidental’ DBAs i.e. IT Professionals who get saddled...
Author: Andrew.Fryer Date: 08/12/2008
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...
Author: Andrew.Fryer Date: 08/11/2008
SQL Server 2008 Unleashed
Although the official UK launch of SQL Server 2008 merged in with the launches of Windows Server...
Author: Andrew.Fryer Date: 08/11/2008
Who stole my Report Builder
Anyone who has tried Report Builder v2, aka Report designer Preview, blue etc. will have noticed...
Author: Andrew.Fryer Date: 08/08/2008
SQL Server 2008 Released
I hope you are sitting down, and don’t have a coffee in your hand when you read this, but SQL Server...
Author: Andrew.Fryer Date: 08/06/2008
Must have tool for Migrating Access to SQL Server
I have a love hate relationship with Access for the same reason, it’s seductive simplicity. ...
Author: Andrew.Fryer Date: 08/06/2008
SQL Server Migration
I knew that there was a toolkit to help move an application from Oracle to SQL Server, but I hadn’t...
Author: Andrew.Fryer Date: 08/05/2008
SQL Server 2008 TechNet Webcasts
If you can’t find anything to watch on the telly tonight… TechNet Webcast: Security Enhancements in...
Author: Andrew.Fryer Date: 08/04/2008
Reporting Services drill-through for a matrix report
One of the great things about working in Microsoft is the huge e-mail threads with where we share...
Author: Andrew.Fryer Date: 07/31/2008
SQL Bits - Don’t be square be cubed
The UK SQL community are doing their next SQL Bits cubed on Saturday 13th Sept at Hatfield...
Author: Andrew.Fryer Date: 07/31/2008
SQL Server Under New Management
I am now hard at work on the events that will occur around the release SQL Server 2008. This time...
Author: Andrew.Fryer Date: 07/29/2008
Oh no it’s the BI Acquisition..
My first experience of ‘proper’ databases was using Ingres back in 1994 while working for an obscure...
Author: Andrew.Fryer Date: 07/28/2008
Install SQL Server 2008 Advanced Services
Having got past the pre-installation issues in my last post I am now ready to install SQL Server...
Author: Andrew.Fryer Date: 07/21/2008
SQL Server 2008 RC0 Express on Vista
I wanted to get Express installed on my machine and so I downloaded the RC0 (of Express with...
Author: Andrew.Fryer Date: 07/17/2008
SQL Server 2008 End User Reporting
I have been seeing a fair bit of confusion about the new end user reporting tools in SQL Server...
Author: Andrew.Fryer Date: 07/16/2008
SQL Server 2008: where’s my stuff?
For those of us who have been tracking the evolution of SQL Server 2008 through it’s long gestation...
Author: Andrew.Fryer Date: 07/16/2008
Business Intelligence 101
Despite the Business Intelligence being the top priority for for CIO’s for the last three years, and...
Author: Andrew.Fryer Date: 07/15/2008
Licensing SQL Server Client Tools
Ever since I have been using SQL Server you have had the ability to manage SQL Server from another...
Author: Andrew.Fryer Date: 07/14/2008
SQL Server Consolidation Options
Consolidation of server is a very hot topic as server rooms fill up and cooling becomes ever more...
Author: Andrew.Fryer Date: 07/11/2008
SQL Server 2008, no definite release date
There is some buzz around about SQL Server 2008 being out in August e.g. on SQL Server Central,...
Author: Andrew.Fryer Date: 07/10/2008
SQL BITS Cubed
Planning for SQL Bits cubed (13th September in Hatfield) is moving along but the organisers need...
Author: Andrew.Fryer Date: 07/08/2008
Vista Chick Magnet
I got one of my neighbour’s sons onto our one week work experience program this week, so I thought I...
Author: Andrew.Fryer Date: 07/06/2008
Computer Weekly Blogging Awards
Somebody out there is reading this, and thinks that my stuff is worth voting for and so I have...
Author: Andrew.Fryer Date: 07/04/2008
Beyond relational data in SQL Server 2008 Express
I was in a customer meeting today with David Portas of Conchango who is hard at work doing battle...
Author: Andrew.Fryer Date: 07/02/2008
SQL Injection
Fuel injection is generally considered to be a good thing for cars, while IT professionals consider...
Author: Andrew.Fryer Date: 07/01/2008
Migrating a virtual machine from Virtual PC to Hyper-V
Now that hyper-v is released I though it would be good to go through a little glitch I found moving...
Author: Andrew.Fryer Date: 06/30/2008
Dr Michael Rys – meet the expert.
For those that don’t know him Michael Rys is the principal program manager lead for SQL Server’s...
Author: Andrew.Fryer Date: 06/25/2008
Analysis Services 2000 to 2008
Analysis Services 2000 was my life for several years and like a good friend you tried to...
Author: Andrew.Fryer Date: 06/24/2008
What do Evangelists do at the Weekend?
This weekend the Microsoft evangelists were out in force at the BBC Mashed, a hack event at...
Author: Andrew.Fryer Date: 06/23/2008
SQL Bits Logo design
I have heard it said by many developers that DBAs are all artists, so please can you direct your...
Author: Andrew.Fryer Date: 06/20/2008
SQL Server & Open Source Interoperability
You needed to understand two acronyms In the Microsoft vs Open Source debate until recently: LAMP:...
Author: Andrew.Fryer Date: 06/18/2008
Chat to Us about SQL Server
Why do so many SQL Server people make the effort to come to evening and weekend events? These...
Author: Andrew.Fryer Date: 06/16/2008
SQL Server 2008 RC0 feature pack
The sharp eyed amongst you will have noticed that there are a few things missing in RC0 that were in...
Author: Andrew.Fryer Date: 06/13/2008
Windows Server 2008 – Branch Office Deployment
In the final part of my interview with Alun Rodgers of Risual, we discuss the rollout out of Windows...
Author: Andrew.Fryer Date: 06/12/2008
Windows Server 2008 – Terminal Services
In the second part of my interview with Alun Rodgers of Risual, we discuss what’s new in Terminal...
Author: Andrew.Fryer Date: 06/12/2008