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

    Improving SQL Disk Performance #2 Windows Stripe Size

    • 1 Comments
    There are some urban legends around the Windows stripe size that you should set for SQL Server. I have seen recommendations of 64k for both data and log internally at Microsoft by some heavy hitting data Dudes, so that is good enough for me ;-) Generally...
  • Bob Duffy's Blobby Blog

    Improving SQL Disk Performance #1 Partition Alignment

    • 8 Comments
    There is a great article that you should read before configuring a disk subsystem for SQL Server. Predeployment I/O Best Practices . As mentioned, one of the common pitfalls is not ensuring that the offset of the first block is "64k" or a multiple...
  • Bob Duffy's Blobby Blog

    SQL 2008 Questions from Users Group

    • 0 Comments
    Thanks to everyone who attended the SQL Ireland Users group. We discussed some of the main new features in SQL 2008: compression encryption business continuity Resource Governor Entity Data Model Synchronisation Framework DWH Improvements Change Data...
  • Bob Duffy's Blobby Blog

    Why Should I use SQL Enterprise Edition?

    • 3 Comments
    A lot of customers have been asking me if they need to use Enterprise Edition. the basic answer is that EE is sold mainly on the enhanced features which can be compared at: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx You will...
  • Bob Duffy's Blobby Blog

    2008 Launch Tour

    • 1 Comments
    I've been a bit off radar: up to my neck in a large  sql server / dot.net project and some time off for Christmas. Believe it or not I managed to get my thumb trapped in a Transformer on Christmas day and an ensuing infection - so if you see a consultant...
  • Bob Duffy's Blobby Blog

    JDBC: When Good Prepared Statements go Bad

    • 2 Comments
    I've been doing some performance comparisons of JDBC from Java with ADO.Net from Dot.net. One key thing that jumps out at me is JDBC tends to make more use of prepared statement, even to the point of abusing the poor thing.  I see some mid-tier manufacturer...
  • Bob Duffy's Blobby Blog

    Providing Feedback on the Microsoft JDBC Driver

    • 3 Comments
    Thanks to everyone who was the the first Irish Java Developers Conferance ( http://ijtc.firstport.ie ). Hopefully there will be a repeat performance next year. Many people were surprised to see Microsoft at the event, I guess this is a sign of the times...
  • Bob Duffy's Blobby Blog

    Remote Desktop 201 - Group Policy and auto log off

    • 1 Comments
    Just got this link to an article on using Group Policy to auto log off users and a whole rake of other settings - nice ;-) On something like a SQL Server I think this should be in a standard build. http://www.msterminalservices.org/articles/Managing...
  • Bob Duffy's Blobby Blog

    Remote Desktop Tip 101

    • 1 Comments
    If like me you use remote desktop a lot and are constantly hitting the two user limit, here's a great tip. Add a second copy of the remote desktop to icon captioned "Remote Console" with the same path but an extra flag "/console". This will allow you...
  • Bob Duffy's Blobby Blog

    The SQL CAT Team finds a new home

    • 1 Comments
    At last one of the most important blogs for those interested in VLDB has a dedicated site http://sqlcat.com/Default.aspx If you are implmenting a TB plus DWH or BI solution make sure you check out this site. The Customer Advisory Team is involved in...
  • Bob Duffy's Blobby Blog

    Microsoft MVC Framework.

    • 0 Comments
    Scott Guthrie just recently announced the ASP.NET MVC Framework. Which is promises to bring similar benefits to Ruby on Rails, but looks to be mega extensible of of course be build completely on dot.net 3.5 Great video: http://weblogs.asp.net/scottgu...
  • Bob Duffy's Blobby Blog

    Grails, Jasper and SSIS and err Meta Data Development

    • 1 Comments
    I'be been looking at Grails and I have to say it rocks, just off to buy the T-shirt now. I'm not sure if there is something quite as sexy in the dot.net world yet for RAD (someone flame me if there is !). The concepts of "Dont Repeat Yourself" is something...
  • Bob Duffy's Blobby Blog

    Fog Creek Comes to Dublin

    • 1 Comments
    There's a great guest speaker coming to the IJTC (Joel Spolsky) who must be one of the most famous bloggers full stop. He wil be delivering the Key Notes for the IJTC event starting on the 8th. Even better there a raffle for a champagne reception...
  • Bob Duffy's Blobby Blog

    The Irish Java Technologies Conference

    • 1 Comments
    The Irish Java Technologies Conference is running in Parnell Cinemas from wed 7th Nov to Fri 9th November. There is some pretty heavy hitting speakers on all things to do with Java, and the venue is excellent - beer, snacks comfy chairs and you can maybe...
  • Bob Duffy's Blobby Blog

    IIS 7.0, and the LongHorn Application Platform

    • 1 Comments
    Hi, Thanks to Dave for a great session last week - I really enjoyed the demos, especially PHP running xxx times faster on II7.0 - the new FastCGI and compression in IIS 7.0 rocks!! I wont publish the results as you have to see Daves demo to believe...
  • Bob Duffy's Blobby Blog

    Its about time too

    • 0 Comments
    Being a huge fan of Chris Taylor and the orignal Total annihilation (yes we forgive you for TA kingdoms, Gnugs rule and I married She-Devil), I'm currently playing Supreme Commander http://www.supremecommander.com/ It had been thought that this would...
  • Bob Duffy's Blobby Blog

    The Demo God Retires

    • 2 Comments
    I was just back from the first Irish Microsoft Technologies Conference http://imtc.firstport.ie/ I hope the video gets posted up. Rob Burke went out in style with the Demo to end all Demos. We had XNA, PC's XBoxes, WII controllers, Scottish Monsters controlled...
  • Bob Duffy's Blobby Blog

    Whassup with my SQL Server

    • 1 Comments
    Technorati tags: SQL SQL Server 2005 includes some great new dynamic management views and functions to help find out what is going on. These three in particular work quite well together. View/function Type Description sys.dm_exec_requests...
  • Bob Duffy's Blobby Blog

    How not to use Power Point

    • 0 Comments
    Came across this great link on improving your power point skills: http://www.davidairey.com/how-not-to-use-powerpoint/ very funny ;-)
  • Bob Duffy's Blobby Blog

    Smart Indexing Part II - Conditional Rebuilding

    • 5 Comments
    The Maintenance plan Wizard in SQL Server 2005 allows us to create an SSIS package that ReIndexes all Indexes. This is great for smaller systems, but on larger systems (over 10GB or so), the re-indexing can take a long time reducing the maintenance window...
  • Bob Duffy's Blobby Blog

    Smart Indexing Part I - Analyzing Indexes

    • 0 Comments
    Introduction There are three items that any SQL Server maintenance plan should cover at a minimum: Backup, DBCC and ReIndexing. Indexes much like your old laptop disk drive will become fragmented. As data is inserted a “page split” may put data...
  • Bob Duffy's Blobby Blog

    The Humble Desktop Reaches a Terra

    • 0 Comments
    Hitachi have released a 1TB SATA II drive. What is more impressive than the size is the fact that according to Toms Hardware Guide it benchmarks as well as the famous Raptor drives. One of which I have lovingly in my development box at home, having replaced...
  • Bob Duffy's Blobby Blog

    Flash - aha Saviour of the Database

    • 0 Comments
    A new wave of tecnology is about to hit enterpise SQL SAN's. The humble flash disk scaled up to 1TB. In theory this gives incredibiliy low IO latency and eliminates the descrepancies between random/sequential IO and slowness due to a disk filling up!...
  • Bob Duffy's Blobby Blog

    Extending SSRS Data Sources

    • 1 Comments
    Introduction SQL Server Reporting Services comes out of the box with a good few data sources. Microsoft SQL Server and Microsoft Analysis Services are the main ones I use, and you can pretty much connect to any other database product using OLEDB/ODBC...
  • Bob Duffy's Blobby Blog

    SQL 2005 Performance Dashboard on the Web

    • 0 Comments
    One of the most exciting things to come out of SP2 is the availability of the performance dashboard. This allows a one page overview of you SQL 2005 server and raises SQL 2005 trouble shooting from black art involving complex dynamic management views...
Page 4 of 5 (106 items) 12345