Monthly Archives: August 2012

sp_executesql

I don’t normally have a need to do dynamic sql; however, I found myself at a client site and we were doing a dynamic query where we wanted to capture the return value.  They dynamic nature of the query was … Continue reading

Posted in I learn something new everyday | Tagged , | 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

Azure SQL Presentation

Last night I presented at the Richmond SQL Server Users group meeting on Windows Azure.  I had a few jitters and a couple of minor technical issues–which the crowd helped me through and all in all it went well.  I … Continue reading

Posted in Presentations | 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

Bikes for Kids

During the school year, I was proud to support the 2nd annual Bikes for Kids project sponsored by the Eastern Henrico Business Association.  As and incentive to prepare for their SOL exams, the business association is looking to secure two … Continue reading

Posted in Because I have been given much | Tagged | 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

Using SSIS to write to SharePoint

I was experimenting with the new (to me) SharePoint Source and Destination utilities available in SSIS and came across this error Error: 0×0 at Data Flow Task, SharePoint List Destination: Error on row ID=”2″: 0×81020016 – List item referred to … Continue reading

Posted in Uncategorized | Tagged , , , | Leave a comment

IIS Log Import

A client asked me about extracting some data from an IIS log.  I thought it would be straightforward; however, the trick was the file is delimited in two ways.  Most of the columns are tab delimted, but one column–cs-uri-query is … Continue reading

Posted in I learn something new everyday | Tagged , | Leave a comment