Sharing scripts

Most if not all SQL professionals will have heard of SQLServerCentral.com, if you haven’t it’s a great community site with it’s own SQL Server forum where you can ask questions and receive answers from your peers. The site has a contribution center feature where registered members can submit articles, scripts and even a “Question of the day”. In true community spirit I shared one of the scripts that I had been working on. [...]

My wife always said I was certifiable

Things have been a little quiet on the blog front in the last couple of weeks, the reason for this is that I’ve been spending my spare time studying for the SQL Server 2008 MCTS – Database Implementation and Maintenance exam.

Today was the big day, I’d never taken a Microsoft exam before so didn’t really know what [...]

Finding Files in ActiveX

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

Finding files in T-SQL

Richard Douglas shows how you could use the undocumented stored procedure xp_FileExists to start another process. [...]