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
Monthly Archives: September 2012
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
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
Powershell in SQL Server
I have yet to really scratch the surface in using Powershell to manage my SQL Server; however, from time to time I have used a powershell script to delete files from the server on an ongoing process. Because I am … Continue reading
