Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

Browse by Tags

Related Posts
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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,...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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. ...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...