Finding Files: Part 2 ActiveX

The second part of this series on finding files in SQL Server introduces the FileSystemObject.

SQLBits review

It’s now been a week since SQLBits V started in Newport, Wales, so it’s about time I wrote a little on it. First of all I have to say a big thank you to all the organisers, speakers and sponsors without whom the event would not have been possible. The facilities at the conference centre […]

SQLBits V session agenda now online

For those of you that have registered the agenda’s for SQLBits V is now available online. Hope to see a few of you there! Richard DouglasMore Posts – Website Follow Me: Related posts: SQLBits: I’ve registered, have you?

SSMS scripting editor

Thanks go to Tony Rogerson and Justin Langford for a great evening at Reading last night. It was the first time I had been to the Microsoft Campus┬áso was a bit in awe of everything. Justin and Tony both gave great sessions, but the tip I am going to talk about was almost a throwaway […]

User Group Reminder: Reading

There is a SQL user group meeting in Reading tomorrow night hosted by MVP Tony Rogerson and Justin Langford. Tony will be covering “An Introduction to the SQL Server architecture and also High Availability (Partitioning and File Groups (backup, restore, partial restore))” while Justin will be resenting a session on Virtualising SQL Server. Click here┬áto […]

Let SSIS notify you of it’s own errors

One of the things I love best about SQL Server Integration Services (SSIS) is how powerful expressions are. In this blog I will talk about how you can enable SSIS to email you when a step has gone wrong. Pretty normal stuff you might think I could do that in DTS in truth yes you […]

SSIS Overflowed Disk I/O Buffer

This morning I had a wake up call from a colleague saying that there had been a problem with one of the processes and could I take a look at it. So out comes the laptop, on goes the router, hunt around for my code fob and off we go (even though I’m not on […]