Author Archives: Carlos Chacon

About Carlos Chacon

I am an independent SQL Server consultant in Richmond VA and enjoy working with different IT teams with any variety of data need. I can be reached at carlos.chacon@sqldatapartners.com.

First SQL Saturday Presentation

Posted on May 10, 2013

On April 13th, I had the opportunity to present at my first SQL Saturday event in beautiful San José, Costa Rica.  I also presented in Spanish, which was a challenge for me as I do not have much experience working … Continue reading →

Posted in Presentations, SQL Saturday | Leave a comment

Organizing SQL Saturday RVA

Posted on May 2, 2013

This is a little late in coming; however, I wanted to document my experience planning and putting on a SQLSaturday event.  While officially put on by the Richmond SQL Server Users Group, ‘my’ event took place March 9th, 2013 at … Continue reading →

Posted in Conferences, SQL Saturday | Leave a comment

Excel Connection Manager

Posted on April 19, 2013

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

Dropping a publisher when the distributor is down

Posted on March 29, 2013

Working on a new server, I came across a replication process that had been forgotten about and the pieces were disconnected.  The distributor server/process had been installed on another server and when I went to remove the publisher from the … Continue reading →

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

You can’t shrink a logfile when . . .

Posted on March 29, 2013

I was asked to look at a database server for the first time.  One of the tasks I was given was to shrink the log file of a database as the previous owner could not.  The DB was only 10 … Continue reading →

Posted in I learn something new everyday | Leave a comment

Importing or Exporting to Access

Posted on March 26, 2013

I had a client request to export some data to Access 2010 for their downstream use.  I have done this in the past and thought it a no-brainer; however, there is always a little trick–hence the post.  Because I had … Continue reading →

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

Upgrading SharePoint List Adapter in SSIS

Posted on February 27, 2013

A server upgrade prompted me to migrate some SSIS packages.  These packages were going from SQL 2008R2 to SQL 2008R2, so there was no change there; however, the new server had a different version of the SharePoint List Adapters, which allow you … Continue reading →

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

SQL Saturday RVA

Posted on February 27, 2013

SQL Saturday RVA is just under two weeks away and we have been busy trying to get everything in place.  I have had a great team with Wayne Sheffield (b|t) and Geoff Johnson (t) doing some heavy lifting.  Our event will … Continue reading →

Posted in SQL Saturday | Leave a comment

My Experience on SQL Cruise

Posted on February 11, 2013

Of the great aspects of the SQL Server community is the willingness of people to share what they know as they discuss resolutions to problems they face.  There are a variety of opportunities to engage these people–blogs, user groups, SQL … Continue reading →

Posted in Conferences, I learn something new everyday | Tagged | 5 Comments

SQL Server en Español

Posted on January 8, 2013

While I was born in the United States, my father is from Costa Rica and it was always a little weird being the only Carlos Chacón that didn’t speak Spanish–especially because I am the oldest on my dad’s side.  Luckily … Continue reading →

Posted in Presentations, SQL Saturday | Leave a comment