SQL Server 2005 Webcasts

Just thought I’d plug the SQL Server 2005 webcasts which are due to launch from the beginning of December.  If you’d like to know more, go here to register: http://msdn.microsoft.com/SQL/2005/2005Webcasts/default.aspx

0

General ravings…IDW9….

Hello again I’m pleased to announce that the latest build of SQL Server 2005 includes two new T-SQL commands, INTERSECT and EXCEPT.  I’ll talk about these a little later. I’ve just been on a great 2005 training course delivered by Niels Berglund of developmentor.  Niels has introduced me to some great features which I’ll talk about in this blog. …

1

SQL Server 2005 Extended Triggers

Ok, I am impressed with everything in SQL Server 2005, especially extended triggers to capture DDL actions.  I was playing around with these today and I can see how this will be a nice feature, especially for audit trails.  I’ve included a simple script below. — create sample dbcreate database trigtestdbgo use trigtestdbgocreate table tblextrig…

4

I’ve been gone a while but I’m back….

Hi all Apologies for not updating my blog as often as possible – I’ve been on vacation for the past couple of weeks and managed to lose most of my possesions when the villa was broken into!  Fortunately, my wallet and passport has been recovered in Valencia last week – they were found dumped in…

1

A DTS problem which is bothering me…

I can’t believe it’s almost July and it’s pouring down with rain.  I’ve been thinking about a problem a customer asked me about last week regarding DTS and the lack of interoperability between SQL Server 7 and 2000.  To cut a long story short, I was asked to document the known DTS bugs for each…

0

Hello & Let’s talk about SQL Server

Welcome to my blog – I’m going to use this site to share my thoughts, ideas and experiences with SQL Server & some VB/C#.NET.  I’ll most likely concentrate on the current 2000 and pending 2005 release which should be with us soon.  The second beta is just round the corner.   I’m particularly interested in the…

1