Category Archives: Uncategorized

Excel Connection Manager

I find myself needing to import files from time to time and usually use SSIS to import the data–normally to a temp table.  I did so the other day and got this error. SSIS package “MyTest.dtsx” starting. Information: 0x4004300A at … Continue reading

Posted in Uncategorized | Leave a comment

SQL Saturday 173 Washington DC

Saturday December 9th found me in Washington DC for SQL Saturday 173.  As we are planning an event in Richmond, I opted to volunteer more than I have in the past so I could be closer to the logistics and … Continue reading

Posted in Uncategorized | Leave a comment

Roanoke SQL Server Users Group

October 18th, I spoke at the Roanoke SQL Server users group.  While not a big group, there was a good comradery and I enjoyed meeting the people there.  I spent the night in Roanoke with the family and we enjoyed … Continue reading

Posted in Uncategorized | Leave a comment

SSMS default projects folder

I have a client that wants to ability to see the ad-hoc queries/scripts I write for them.  These aren’t things that go into production or a source control environment.  While it is only a couple of clicks, it became tediuos … Continue reading

Posted in Uncategorized | Leave a comment

Going on a SQL Cruise!

I have had a pretty good life on the D list as a DBA here in RVA and I am looking to bump it up a notch–you know, take it to a new level.  I have found so many different SQL Bloggers … Continue reading

Posted in Uncategorized | Leave a comment

Not all operating sytem builds are equal

I was trying to build out a virtual machine for my SQL Azure presentation to the Richmond SQL Server Users Group and I realized something I had taken for granted–ALL OS downloads from Microsoft’s MSDN are not created equally. I … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

SQL Saturday #173 in DC

I registered for the SQL Saturday in Washington DC on December 8th.  Should be a good one.  Hope to see you there.

Posted in Uncategorized | 1 Comment

SQL Saturday in Richmond

The Richmond SQL Server Users Group is trying to bring a SQL Saturday event to Richmond.  We are currently working with various locations to determine the best place for us and are looking for a date early next year.  If … Continue reading

Posted in Uncategorized | Leave a comment

Moving to a new home

I have moved my site from Google site to WordPress.com and hopefully this will allow me to provide better content for my potential customers.  I am in the process of trying to bring my old posts over and hopefully will … Continue reading

Posted in Uncategorized | Leave a comment

Grant access to tables

Often, when setting up database security where it hadn’t been before, there is a need to assign users to roles and then grant those roles permission to tables.  I was tasked with granting read access to all the tables in … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment