matt_whitfield.jpg

Matt Whitfield

Matt is the director of Atlantis Interactive, a provider of free SQL Tools, and a leading contributor to the Ask SQL Server Central website. He has over 13 years experience of working with SQL Server from versions 6.5 upwards.
http://www.atlantis-interactive.co.uk/blog/ http://www.atlantis-interactive.co.uk/blog/syndication.axd

A look at the basics of CLR integration with SQL Server, focusing on the nuts and bolts of CLR objects, followed by some practical examples.
A guide to the things that you should be doing if you use the CLR, as well as those that you shouldn't. Find out what you need to be aware of, with a cause-and-effect approach.
A look at the basics of CLR integration with SQL Server, focusing on the nuts and bolts of CLR objects, followed by some practical examples.

Blog posts RSS

Another step in the road 04 Oct 2012
So, I haven't really updated the blog a lot. At all. But I have been busy. When Atlantis initially started, one of the long term goals was to wrap all the Atlantis tools into a single IDE which brought the tools together seamlessly. That would have really hit the 'be integrated' part of the ...

Long time, no blog 09 Nov 2011
Ok, so it's been a while.We've just updated the Atlantis site to remove the necessity to log in before downloading the applications. I'm a bit sad about it, if I'm honest, because of two things:I liked seeing people go past, downloading the tools and getting value from something I'd made. Obviously ...

What's new in Denali CTP3, DMV-wise? 07 Aug 2011
Ok, so for researching what's new in Denali CTP3, and therefore what schema inspector has to cope with, I have had to look at the DMV differences between CTP3 and 2008. So, here's a summary of the differences. I'm not going to replicate BOL here, just provide a simple lookup for 'what's new?'.So, ...

A generic list for passing table-valued parameters to SQL Server 21 May 2011
In my current day job, one of the things I need to do is load log files from devices into SQL Server. Nothing out of the ordinary, but the data volume made for an interesting time - because each log file has maybe 100 or 200 rows. So not the sort of volume that you'd like to bulk load, and ...

T-SQL Tuesday #18 - CTEs - The permission hierarchy problem 10 May 2011
Recently, I was looking at a problem which involved an arbitrary tree structure for permissions. The idea was similar to NTFS security, in that the permission that was defined furthest from the root of the tree would apply to any items below it.So, consider the following ...