Bob Duffy's Blobby Blog

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

March, 2008

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

    How to set MAX_SERVER_MEMORY

    • 0 Comments
    OK I'm on a roll here blogging as my brain is full up on the MCA course. Here's a good tip on how to calculate the MAX_SERVER_MEMORY a) calculate worker threads (assuming set correctly, as default max 255 may be too low for huge beasts) select max_workers_count...
  • Bob Duffy's Blobby Blog

    SQL Server Memory Architecture. Myth Busting and how sad is AWE/32 bit.

    • 2 Comments
    I have a little picture below to show how memory is broken up in the SQL Server Working set. Some key Myths to dispel: a) The Max Memory Setting only sets the target memory for the buffer pool not for the whole of SQL Server working set. So do not set...
  • Bob Duffy's Blobby Blog

    The Pressure of the MCA/Ranger Course

    • 1 Comments
    Exam #3 at the SQL Ranger course is tomorrow and a few of the candidates and Instructors have spoken about the huge pressure on Candidates. Most people come from a community where they ARE the SQL experts and highest authority. Their managers, co-workers...
  • Bob Duffy's Blobby Blog

    The SQL Server Disaster Game

    • 0 Comments
    I have been doing a great course with Paul Randal on disaster recovery for SQL Server. He has a great blog on just about everything to do with DBCC and disk structures and recovery. See http://www.sqlskills.com/blogs/paul/default.aspx Here is a little...
  • Bob Duffy's Blobby Blog

    Mid Way Through Ranger 03

    • 1 Comments
    I've just survived week 3 of the SQL Ranger Rotation 04 here in Redmond. Whats its been like: a break neck sprint through level 300-500 content on SQL nearly every aspect of SQL. Man I thought I was good on SQL Server until Paul Randal started explaining...
  • Bob Duffy's Blobby Blog

    Managing SQL Server for MOSS

    • 1 Comments
    There is a new white paper available on managing SQL Server for MOSS environments. http://go.microsoft.com/fwlink/?LinkId=111531&clcid=0x409 Great tips on Index defragging and use of DBCC. One thing that I'm not sure I entirely agree with is the adding...
  • Bob Duffy's Blobby Blog

    Off to Ranger/MCA Training

    • 1 Comments
    I'll be off to the states for the four week MCA:Database training. http://www.microsoft.com/learning/mcp/architect/database/default.mspx Speaking to people who have been on the course before this is really exciting. We get to spend four weeks in training...
  • Bob Duffy's Blobby Blog

    My Trip to the land of XML Messaging

    • 1 Comments
    Sorry I've been off the radar a while. I've been working as a Solution Architect on a large telco solution. I'm very happy with the results, We managed to make good use of lots of SQL Server programmability features such as XML, service broker, SQL CLR...
Page 1 of 1 (8 items)