Bob Duffy's Blobby Blog

SQL Server | BI | Dot.Net | Office | Sharepoint | MCE | Database Stuff

Blog - About

About SQL Server, BI and Database Stuff

I've been around custom application development in Ireland for about 15 years. Currently I am focusing on helping enterprise customers with SQL Server, BI and dot.net technologies.

I live with my wife and four children (yes four all under 8!), in Sandyford my main hobbies are playing with SQL Server, wrestling with kiddies, playing and watching UFC, board games, strategy games. 

Hopefully I'll be posting articles that people might find interesting ;-)

  • Bob Duffy's Blobby Blog

    Bob Duffy passed MCM 2008 !

    • 0 Comments
    I just got the email to say I have passed the SQL 2008 MCM exam. http://www.microsoft.com/learning/en/us/certification/master.aspx . The six hour hands on lab is pretty gruelling. Luckily there is no need to fly to the lab in the states for it, with web...
  • Bob Duffy's Blobby Blog

    SQL Server Versions

    • 0 Comments
    I'm always installing SQL Server or talking to customers about installations and the topic comes up of which version am I on, or what version should I be on ? A fellow MVP, Bill Graziano has lovingly compiled and maintains a list of version numbers and...
  • Bob Duffy's Blobby Blog

    SQL Immersion: Dublin 2009

    • 0 Comments
    There is four weeks until the SQL Immersion event here in Dublin and I'm getting really excited. For anyone like me who career is based on SQL technology this is one not to miss. There has never before been an opportunity like this to learn from Paul...
  • Bob Duffy's Blobby Blog

    Epicenter on Wed 26th August

    • 0 Comments
    The largest Irish conference/ expo is starting this wed. the list of speakers and events is definitely worth checking out http://epicenter.ie/ It event combines four previous events in one: Java, Open Source, Microsoft and Web Technologies. I'll be presenting...
  • Bob Duffy's Blobby Blog

    is your Anti-Virus Strangling SQL Server?

    • 0 Comments
    Its very common when I arrive on site to do a performance review or some tuning that a good first place to look for is windows task manager and anti-virus. By selecting View-Select Columns we can add interesting counters such as Threads, Handles, I/O...
  • Bob Duffy's Blobby Blog

    Bob Duffy awarded MVP for SQL Server for 2009/2010

    • 2 Comments
    Just got the email announcing that I've been awarded an MVP for SQL Server for 2009/2010. The MVP award is for contribution to the technical community. I'm really chuffed to get this sort of recognition - the list of SQL Server MVP's includes some big...
  • Bob Duffy's Blobby Blog

    SQL Immersion: Dublin 2009 is open for registration

    • 0 Comments
    Kimberly Tripp and Paul Randal are coming to Dublin in September for a week of what promises to the be the deepest SQL Server training ever held in Ireland. If there is any SQL event to attend in Ireland this year I'm pretty sure this is the one. When...
  • Bob Duffy's Blobby Blog

    Project Gemini Preview

    • 0 Comments
    For anyone attending the SQL 2008 Academy on Friday (link here ) we are going to be showing some details on project Gemini technology included in SQL 2008 R2, which is probably the first look at this exciting new self service BI platform in Ireland. This...
  • Bob Duffy's Blobby Blog

    Get an MCM at a discount rate!!

    • 0 Comments
    I must get about 50 emails a week offering a degree for 50 bucks mail order, but here's an offer which is not bad. The Microsoft Certified Master Program is offering some $3,500 off the $18,500 ticket price. This has to be the best training on the planet...
  • Bob Duffy's Blobby Blog

    Kimberly Tripp and Paul Randal returning to Dublin

    • 0 Comments
    The rumours are true! We are helping to organise Paul Randal and Kimberly Tripp to return to Ireland to run a WEEK intensive SQL Immersion event in Dublin for the 21st to the 25th of September. The last time Paul and Kimberly were over the session was...
  • Bob Duffy's Blobby Blog

    SQL 2008 Academy - Analysis Services 101

    • 0 Comments
    I'm presenting a complimentary session for Microsoft SQL Academy entitled "Analysis Services 101" next Friday (26th June) here in Sandyford, Dublin. This session is aimed at people who are familiar with the relational engine, but just getting into Analysis...
  • Bob Duffy's Blobby Blog

    SCCM Reboot during OSD Install - "NO MP Certificates"

    • 3 Comments
    I just spent ages troubleshooting an annoying thing with SCCM. Every time I tried an OSD PXE installation the PXE would load and then just before the task started it would just reboot. I followed all the troubleshooting tips for Windows PE environment...
  • Bob Duffy's Blobby Blog

    Processor at 100% after Installing SCCM (or anything else).

    • 1 Comments
    I've recently been installing a lot of MS Server products into a lab. One thing I noticed is immediately after the install the server is nearly useless, especially if its a Virtual Server with only one core. The reason for me was after the install the...
  • Bob Duffy's Blobby Blog

    SSRS 2008 Event in Cork

    • 1 Comments
    If anyone is in Cork on Thursday 4th June, I'll be presenting a seminar on Reporting services 2008 Architecture and Report Builder 2.0 for the MTUG. Well be covering: - Key Engine Changes in 2008 - Rendering Improvements - A Walk through of how to sue...
  • Bob Duffy's Blobby Blog

    Troubleshooting AD Extension. The dreaded Error 8206

    • 1 Comments
    I’m a SQL/Apps dude, not an Infrastructure guy. My weakness is I love technology so much I dabble in things that I should definitely leave to more expert specialists: windows, active directory, Group Policy, Exchange, ISA Server, networking, patch management...
  • Bob Duffy's Blobby Blog

    DB Restore causes cache flush in SQL 2005

    • 1 Comments
    Ok, I’m sure many people already know this , but I just found out the hard way. When you perform a restore or certain reconfigure options, the entire plan cache is flushed – not only just the database. This might wreck havoc with shared environments or...
  • Bob Duffy's Blobby Blog

    Using a SAN to Initialize Replication

    • 1 Comments
    I've chatted to a few customers about the possibnility of using a SAN based snapshot to initialise transactional replication. This can be fantastic when you are using a replica to provide "near real time" reporting. Up until now, documentation has...
  • Bob Duffy's Blobby Blog

    Disk Partition Alignment De-Mystified

    • 1 Comments
    Jimmy May has compiled a great white paper on Disk Partition Alignment Best Practices for SQL Server along with Denny Lee http://msdn.microsoft.com/en-us/library/dd758814.aspx This is a must read for anyone configuring a disk subsystem for SQL Server...
  • Bob Duffy's Blobby Blog

    Dimensional Modelling and Cube Building 101

    • 1 Comments
    Thanks to everyone who came to the Dublin SQL users Group session on Tuesday. I hope that we addressed some aspects of “cube fear” that is common in even very experienced relational professionals. For me just being comfortable building that first cube...
  • Bob Duffy's Blobby Blog

    Bob the Cube Builder

    • 1 Comments
    One thing I do notice about Ireland is we have lots of people who have great knowledge about writing Stored Procedures, data modelling and application design. However when it comes to dimensional modelling and cube building/design getting started can...
  • Bob Duffy's Blobby Blog

    SQL 2008 SP1 Released

    • 1 Comments
    Hopefully everyone knows SP1 is released for SQL 2008 now ! One thing which is really nice is that we can slipstream the installs as well as the slightly longer chaining method. There is a blog with details here: http://blogs.msdn.com/petersad/archive...
  • Bob Duffy's Blobby Blog

    MS Tech Days in Belfast - Reporting Services 2008

    • 1 Comments
    I'll be delivering a session on SQL 2008 Reporting Services in Belfast for MS Tech-Days on 26th March, 2009. If you want to register here's the link http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032405487&Culture=en-IE We've only got...
  • Bob Duffy's Blobby Blog

    Why Not to Sysprep SQL Server

    • 5 Comments
    If you do a lot of installs its a good idea to have an automated process for provisioning SQL Server. A lot of people try to use "sysprep" Here's a few reasons why not to use sysprep. Its not supported by Microsoft CSS. SQL will not work properly...
  • Bob Duffy's Blobby Blog

    Troubleshooting SQL 2008 Installation (Access Denied)

    • 0 Comments
    I have to say that the improvements in the SQL 2008 installation have been pretty good to me. We have a Hyper-V lab with automated SQL installation based on configuration templates which works really well. We can get a box provisioned with SQL 2008 in...
  • Bob Duffy's Blobby Blog

    Problems Refreshing Excel Services Data Sources with SSAS

    • 0 Comments
    I just spent a day looking into why Excel Services could not refresh an Analysis Services 2005/2008 external data source. the message was "Data Refresh Failed... The data sources may be unreachable, may not be responding, or may have denied you access"...
Page 2 of 5 (106 items) 12345