Today I was generating a typed DataSet, using the Data Source Configuration Wizard in Visual Studio (“Add New Data Source…” from the Data Sources window or Data menu). I had two stored procedures, accessing a linked server, in my database that I wanted added to my DataSet.

When it comes to writing T-SQL, one of my pet hates is the unnecessary use of loops and cursors. As we all know, SQL is a set based language and has been designed to work using sets of data. Far too often do I see people looping unnecessarily in their back-end code resulting in a slow user interface.

An attempt to clarify scenarios where Oracle Full Use licensing is required for testing.

Most businesses these days realise that in the current climate you cannot afford to let any opportunity slip... Here I am going to show how a techie tool for monitoring systems and alerting the Systems Administrator to potential issues may be used to improve performance in other areas of the business!

I recently had cause to re-visit a solution already deployed and in live production. The solution is a BizTalk application that accepts orders from our clients and then loads them into our Order Management System.

 If you are a Systems Administrator or responsible for systems in your organisation you are probably familiar with that gut-wrenching feeling that you get when a bunch of people arrive at your desk asking “Are you aware of any problems?” Of course it ain’t ever easy to answer such open ended questions - and the sad thing is that often the answer is “No!” in spite of the sudden arrival of evidence to the contrary...