Bob Duffy's Blobby Blog
SQL Server | BI | Dot.Net | Office | Sharepoint | MCE | Database Stuff
Problems with Virtual machine Bus in Hyper-V
I've just about finished transferring must of the old Virtual server images to Hyper-V on some of...
Author: MSDN Archive Date: 12/18/2008
Sneak Peak of Management in SQL 2010
Dan Jones gives a sneak preview of the sexy new management features in "Kilimanjaro"due in...
Author: MSDN Archive Date: 12/16/2008
Enterprise Connectivity to Oracle and Teradata for SSIS 2008
One of the biggest complaints about SSIS is the lack of performance when reading or writing to...
Author: MSDN Archive Date: 12/13/2008
SQL Academy - Upgrading to SQL 2008
I'm delivery the SQL Academy session on Upgrading to SQL 2008 this Thursday (4th December) - just...
Author: MSDN Archive Date: 12/01/2008
Optimising Procedural Code with Kimberly Tripp
Just in case anyone isn't aware - Kimberly Tripp is back to Dublin this Thursday - 4th December at...
Author: MSDN Archive Date: 12/01/2008
A domain controller could not be contacted for the domain that contains an account for this computer
Sorry no blog posts for a while. I have been pretty busy getting my hands dirty on some projects and...
Author: MSDN Archive Date: 11/24/2008
SQL Server BI Academy
I'll be delivering a whole day on Business Intelligence for the SQL Server 2008 Academy in Dublin on...
Author: MSDN Archive Date: 11/06/2008
SQL Server Goes Scale Out
In case anyone missed the acquisition: Microsoft acquired DATAllegro back in July. Press is here...
Author: MSDN Archive Date: 08/11/2008
Inoculation Against SQL Injection
Anyone on the database scene would have noticed a big surge in SQL Injection attacks around April...
Author: MSDN Archive Date: 08/07/2008
SQL Server 2008 RTM is here
If you are a TechNet or MSDN customer (and who isn't!), you can download the final RTM of SQL Server...
Author: MSDN Archive Date: 08/07/2008
Paul and Kim come to Dublin - Data Dudes Rejoice
Paul Randall and Kimberly Tripp are probably the foremost speakers on SQL Server and they are coming...
Author: MSDN Archive Date: 08/05/2008
Configuring Max Worker Threads in SQL 2005
One of the changes in SQL 20005 is that the default value of Max Worker Threads has changed from 255...
Author: MSDN Archive Date: 05/17/2008
Using Windows 2008 on a Laptop
I've taken the plunge and installed Windows 2008 64-bit on my laptop after a re-imaging...
Author: MSDN Archive Date: 05/09/2008
Last Exam to Go on SQL Ranger 04!!
Out last written exam tomorrow!!! There was definitely a sense of the end of a long journey when we...
Author: MSDN Archive Date: 04/02/2008
What Does Lock Pages in Memory Do
I thought I would post some clarification on what the famous "Lock Pages in Memory" policy...
Author: MSDN Archive Date: 04/02/2008
SQL Ranger Class goes Carting
After the third exam, we only had a few sessions today and then carting for the first down time some...
Author: MSDN Archive Date: 04/01/2008
How to set MAX_SERVER_MEMORY
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...
Author: MSDN Archive Date: 03/30/2008
SQL Server Memory Architecture. Myth Busting and how sad is AWE/32 bit.
I have a little picture below to show how memory is broken up in the SQL Server Working set. Some...
Author: MSDN Archive Date: 03/30/2008
The Pressure of the MCA/Ranger Course
Exam #3 at the SQL Ranger course is tomorrow and a few of the candidates and Instructors have spoken...
Author: MSDN Archive Date: 03/30/2008
The SQL Server Disaster Game
I have been doing a great course with Paul Randal on disaster recovery for SQL Server. He has a...
Author: MSDN Archive Date: 03/30/2008
Mid Way Through Ranger 03
I've just survived week 3 of the SQL Ranger Rotation 04 here in Redmond. Whats its been like: a...
Author: MSDN Archive Date: 03/29/2008
Managing SQL Server for MOSS
There is a new white paper available on managing SQL Server for MOSS environments....
Author: MSDN Archive Date: 03/07/2008
Off to Ranger/MCA Training
I'll be off to the states for the four week MCA:Database training....
Author: MSDN Archive Date: 03/07/2008
My Trip to the land of XML Messaging
Sorry I've been off the radar a while. I've been working as a Solution Architect on a large telco...
Author: MSDN Archive Date: 03/07/2008
Do I Need 64 Bit SQL Server
When moving to SQL 2005 from 2000, some customers are asking what real benefit 64 bit brings. The...
Author: MSDN Archive Date: 02/14/2008
Improving SQL Disk Performance #2 Windows Stripe Size
There are some urban legends around the Windows stripe size that you should set for SQL Server. I...
Author: MSDN Archive Date: 01/26/2008
Improving SQL Disk Performance #1 Partition Alignment
There is a great article that you should read before configuring a disk subsystem for SQL Server....
Author: MSDN Archive Date: 01/26/2008
SQL 2008 Questions from Users Group
Thanks to everyone who attended the SQL Ireland Users group. We discussed some of the main new...
Author: MSDN Archive Date: 01/24/2008
Why Should I use SQL Enterprise Edition?
A lot of customers have been asking me if they need to use Enterprise Edition. the basic answer is...
Author: MSDN Archive Date: 01/24/2008
2008 Launch Tour
I've been a bit off radar: up to my neck in a large sql server / dot.net project and some time...
Author: MSDN Archive Date: 01/16/2008
JDBC: When Good Prepared Statements go Bad
I've been doing some performance comparisons of JDBC from Java with ADO.Net from Dot.net. One key...
Author: MSDN Archive Date: 11/11/2007
Providing Feedback on the Microsoft JDBC Driver
Thanks to everyone who was the the first Irish Java Developers Conferance...
Author: MSDN Archive Date: 11/11/2007
Remote Desktop 201 - Group Policy and auto log off
Just got this link to an article on using Group Policy to auto log off users and a whole rake of...
Author: MSDN Archive Date: 11/07/2007
Remote Desktop Tip 101
If like me you use remote desktop a lot and are constantly hitting the two user limit, here's a...
Author: MSDN Archive Date: 11/07/2007
The SQL CAT Team finds a new home
At last one of the most important blogs for those interested in VLDB has a dedicated...
Author: MSDN Archive Date: 11/05/2007
Microsoft MVC Framework.
Scott Guthrie just recently announced the ASP.NET MVC Framework. Which is promises to bring similar...
Author: MSDN Archive Date: 11/03/2007
Grails, Jasper and SSIS and err Meta Data Development
I'be been looking at Grails and I have to say it rocks, just off to buy the T-shirt now. I'm not...
Author: MSDN Archive Date: 11/03/2007
Fog Creek Comes to Dublin
There's a great guest speaker coming to the IJTC (Joel Spolsky) who must be one of the most famous...
Author: MSDN Archive Date: 11/03/2007
The Irish Java Technologies Conference
The Irish Java Technologies Conference is running in Parnell Cinemas from wed 7th Nov to Fri 9th...
Author: MSDN Archive Date: 10/28/2007
IIS 7.0, and the LongHorn Application Platform
Hi, Thanks to Dave for a great session last week - I really enjoyed the demos, especially PHP...
Author: MSDN Archive Date: 10/28/2007
Its about time too
Being a huge fan of Chris Taylor and the orignal Total annihilation (yes we forgive you for TA...
Author: MSDN Archive Date: 06/09/2007
The Demo God Retires
I was just back from the first Irish Microsoft Technologies Conference https://imtc.firstport.ie/ I...
Author: MSDN Archive Date: 06/08/2007
Whassup with my SQL Server
Technorati tags: SQL SQL Server 2005 includes some great new dynamic management views and functions...
Author: MSDN Archive Date: 06/08/2007
How not to use Power Point
Came across this great link on improving your power point skills:...
Author: MSDN Archive Date: 06/08/2007
Smart Indexing Part II - Conditional Rebuilding
The Maintenance plan Wizard in SQL Server 2005 allows us to create an SSIS package that ReIndexes...
Author: MSDN Archive Date: 06/08/2007
Smart Indexing Part I - Analyzing Indexes
Introduction There are three items that any SQL Server maintenance plan should cover at a minimum:...
Author: MSDN Archive Date: 06/08/2007
The Humble Desktop Reaches a Terra
Hitachi have released a 1TB SATA II drive. What is more impressive than the size is the fact that...
Author: MSDN Archive Date: 05/16/2007
Flash - aha Saviour of the Database
A new wave of tecnology is about to hit enterpise SQL SAN's. The humble flash disk scaled up to 1TB....
Author: MSDN Archive Date: 05/16/2007
Extending SSRS Data Sources
Introduction SQL Server Reporting Services comes out of the box with a good few data sources....
Author: MSDN Archive Date: 05/16/2007
SQL 2005 Performance Dashboard on the Web
One of the most exciting things to come out of SP2 is the availability of the performance dashboard....
Author: MSDN Archive Date: 05/04/2007