About Me
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.
View Full Profile →
Follow Me
-
Recent Posts
Archives
Category Archives: I learn something new everyday
Dropping a publisher when the distributor is down
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
You can’t shrink a logfile when . . .
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
Importing or Exporting to Access
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
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
My Experience on SQL Cruise
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
Coalesce instead of Max
I was asked to tune a query which was used in an export of registration data. A person registers for an activity and they answer questions about this. This query pulls from 19 tables–one of which is a one to … Continue reading
Emailing the operator
Not sure why I just now stumbled into this but . . . . I learn something new everyday. You set up a SQL agent job and want to be notified when it fails, so you click on the Notifications … Continue reading
SQL 2008 client tools install
I am not sure why I am writing about this in 2012, but I found myself needing to install the SQL 2008 R2 client tools on a Windows XP client machine. I am at a client that is still running … Continue reading
Recursive CTE Query
A client came to me and had the similar to data set below. Create Table product ( productid INT, typeid INT, typeDesc VARCHAR(15) ) INSERT INTO product VALUES (1,2,‘Male’), (1,2,‘Female’), (1,3,‘Red’), (1,3,‘Green’), (1,3,‘Blue’), (1,4,‘Small’), (1,4,‘Medium’), (1,4,‘Large’), (2,5,‘Small’), (2,5,‘Medium’), (2,5,‘Large’) They … Continue reading
T-SQL Tuesday #34: Help! I Need Somebody!
As I am really just starting to blog on a regular basis, I thought this T-SQL Tuesday topic on someone who has helped you would be a good first topic to write about in this wonderful SQL community. I took two … Continue reading
