SSIS Layout Formatting Options

Most folks I know go to one extreme or the other when it comes to the visual layout of SQL Server Integration Services packages: either they don’t care a tiny bit about the appearance, or they insist on an easy-to-read SSIS layout before a project is considered complete. I am definitely in the second group, and will almost always spend…


Right-Click File Options in SSMS and SSDT

Ordinarily I wouldn’t blog solely about a set of right-click options in an application, but in this Eleven Days of Festivus series I’m sharing some quick tips that have helped me in SQL Server Management Studio (SSMS) and SQL Server Data Tools (SSDT). When working in Management Studio, you can access several handy functions by right-clicking any open file in…


SSMS Tip: Regular Expressions in SSMS

Regular expressions (or simply regex for short) have long been used by system administrators and data professionals for searching and manipulating text. Regular expressions allow the user to find, replace, and manipulate text based on the pattern they define in the expression. While every text editor allows simple search-and-replace capabilities, regex allows for searching for partial matches, using wildcards, and…


SSMS Tip: Portable User Settings

I’m a creature of habit. With the software tools that I use, I like to have everything in the same place every time, even if I’m working on a machine I don’t normally use. That’s especially true with SQL Server Management Studio, where the sheer number of buttons and options can force one to hunt for the feature they need….


SQL Server Management Studio Script Projects

Did you know that SQL Server Management Studio can help you arrange your SQL scripts into logical groupings? SSMS includes the ability to associate multiple code files together into projects for better clarity and ease of maintenance. In this post, I’ll show you the basics of SQL Server Management Studio script projects. SQL Server Management Studio Script Projects For those…


SSMS Tip: Vertical Text Selection

Occasionally, I’ll stumble across one of those neat tricks that makes me ask myself, “Why didn’t I know about this years ago?”. This was one such discovery, and has been a huge time saver for me. Vertical Text Selection in SSMS Typically, selecting blocks of text is done in a left-to-right, top-to-bottom order. If you use your mouse to select…


SSMS Tip: Beep When Query Completes

I’m old enough to remember when multitasking was considered a good thing. From the same mouths that brought you “work smarter, not harder” came the advice to always be working on multiple things at once to improve efficiency. However, we’ve since learned that deep focus is more serial than parallel, and that trying to focus on multiple things at once…


The Eleven Days of Festivus 2019

The weather is turning cooler, there is holiday music everywhere, and the relatives are all excited to get together and talk about politics. That can only mean one thing: it’s almost time for Festivus! For the last three years, I have spent the 11 days leading up to Festivus writing a blog post each day, and I’m delighted to continue…


PASS Summit 2019 – Day 1 Keynote

Today is the first full day of the PASS Summit, and this morning we kicked things off with a 2-hour opening ceremony and keynote. Networking and Growth PASS president Grant Fritchey starts things off appropriately by focusing on networking and career growth. We say it every year, but it bears repeating: the most important thing you’ll get out of being…


Using the SSIS Error Output On the Data Flow

When working in the SSIS data flow, you’ll notice that many sources and transformations and some destinations have a built-in output to handle errors. The error output allows the SSIS developer to create a separate path through which error rows can be directed. In this SSIS Basics post, we’ll briefly discuss the essentials and design patterns for using SSIS error…