One of the few universal truths when you make your living working with databases is that your career is what YOU make it. No one will hold your hand and walk you along the path stopping to open doors for you along the way. You pretty much have to make …
In my career I’ve had the opportunity to work with many recruiters. Quite frankly, some are better than others. Let me start by saying that I have the highest respect for anyone that chooses to spend their days helping people like me find work. Being a recruiter is not easy. …
From time to time I need to find all fields in a database that are varchar or nvarchar(max). Following is a little bit of code that I come back to time and again, sharing it for you (and so I can find it next time I need it!) . …
BIML from the ground up I’ve been doing a lot of BIML study recently. I’ve been a big fan of BIML for the last couple years, but haven’t had a lot of time to sit and really dive deep on how to write it or how to extend it with …
A lot of my blog posts in the near future will probably be short #til (today I learned) type posts. This post is about some weirdness I noticed when working with comments in BIML. To set the stage, I’m a big fan of writing helpful comments into the code as …
Yesterday I was working with a colleague on an interesting problem in BIML. We are using BIML to build one SSIS package per table in a database, each package has an execute SQL task. Depending on what table we are looking at we want to be able to have the …
I’m a big fan of both Redgate SQL Prompt and SQL Smash in SQL Server Management Studio, but when I’m writing BIML in SQL Server Data Tools I have less options for cool tools to help with things like making my code pretty. Today I learned a hotkey built into the IDE …
During the day I usually have Motown running on loop to keep me company. If you want to listen in with me , click here for my ‘Workin it playlist: Motown‘
As a guy that has done a lot of data warehouse work, I can say with confidence that the hardest part is building a road map of where you want to go with your data warehouse. If you get too detailed you fall into analysis paralysis, if you aren’t detailed …
Keyboard Shortcuts ROCK! I love a lot about editing code in SQL Server Management Studio (SSMS). There are so many cool keyboard shortcuts. When you bring a tool like Redgate SQL Prompt into the mix the things you can do just get crazy! THIS post however, highlights an editing feature …
