If You’re The Smartest Person In The Room, You’re In The Wrong Room

This month's T-SQL Tuesday invitation comes from Jon Shaulis asking for experiences and triumphs with imposter syndrome Imposter Syndrome, the fear of being inadequate in your field, is something that has followed me through my career.  I consistently find myself in situations where I feel under-prepared and under-trained compared to my colleagues.  I'm here to tell… Continue reading If You’re The Smartest Person In The Room, You’re In The Wrong Room

Generate User Email List For SQL Server Logins

If you've ever performed some impactful maintenance on a SQL Server, you probably notified users. If you're great at documentation and already know exactly who to contact, this script isn't for you. If you don't have a user email list, this script will create it for you! I used to manage 500 SQL Server instances… Continue reading Generate User Email List For SQL Server Logins

Redirecting Standard In With PowerShell

Command Line Interface (CLI) tools can be very useful for interacting with certain applications. However, some CLIs do not let a user pass in parameters which makes it difficult to automate. Instead, they lock a user into an interactive session and force the user to enter commands. Fortunately, some programming languages allow for a redirection… Continue reading Redirecting Standard In With PowerShell

Dijkstra’s Algorithm in PowerShell and SQL Server Graph

In my previous post I shared a SQL Server 2017 graph database of US capitals. Graphs are a computer science core competency and present some interesting challenges for programmers. Most notable of these challenges is finding the shortest path between nodes. Dijkstra's algorithm is a commonly taught algorithm for finding shortest path. Dijkstra's is often… Continue reading Dijkstra’s Algorithm in PowerShell and SQL Server Graph

SQL Server Graph Database of US Capitals

SQL Server 2017 introduced graph database functionality. Graphs are a core concept in computer science and I was excited to hear of this new feature. Robert Sheldon has a great series on SQL Server's graph database here. If you're interested in learning about graphs in SQL Server, it's a great place to start. While there's… Continue reading SQL Server Graph Database of US Capitals