I’m a Data Architect specializing in Data Warehouses and Analytics. I’ve been doing this for over 25 years now, starting with then SQL Server version 4.2. I pretty much stuck with it ever since 1996.
I’m a big fan of the SQL Server tools including DTS and Analysis Services that came out in version 7.0. I eventually became an expert in both. I’m a huge fan of the current SSIS and SSAS tools. That being said, I did like performing complex ETL in Perl and now Powershell because of their extensive regular expression library.
At the same time, I’ve done plenty of C/C++, Perl, Python, and then C#, ASP, ASP.NET. All of these complemented my implementation of data warehouses. It was always nice to be able to whip up a 20 line Perl script to parse some multi-format text file coming from a mainframe or to parse the error file coming from a failed BCP load into a nice neat HTML file.
As of late, I’ve been exploring all the things one can do to enhance the usefulness of data warehouses. In particular I’ve been concentrating on R and Microsoft’s R Server line of products. In this blog, I’ll be sharing all I can with you on what I see as one of the most exciting things to come out in years.
The reason I’m writing this blog is so that I can share some of this information I’ve learned over the years with all of you. I have many friends and ex-colleagues that call me every so often because they’re stuck on a problem or they want some general advice on a technical issue. I’m always happy to help – but I think it’ll be alot more fun if I can share this information with lots more people, whether I’ve had a chance to meet them or not.
I hope you’ll enjoy this blog and that you’ll get some information from it that’ll help you advance your work.