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 …
Tableau and cubes I love Tableau, I do NOT however, love working with Tableau when it is connected to an OLAP cube (like Microsoft SQL Server Analysis Services). I don’t enjoy working with cube data in Tableau because basically all the coolest parts of Tableau won’t work or won’t work …
Yesterday I went on a long bike ride with my 14-year-old son Trevor. We planned on going 35 miles (due to oncomming storms we stopped at 31 miles). We are in training to ride together in the MS 150 this year. The MS 150 is a 150 miles ride from …
