If you've bought SuperBowl squares this year, you may be wondering... Are my numbers any good? 7 is good right? 3? What about the rest? I've looked at the last 3 years of football scores and calculated the distribution, with Python, here's your chances...
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
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
When managing a small amount of databases, a simple database growth chart is an effective tool for capacity planning. However, as an environment grows into the 100s or 1000s of databases, performing chart based capacity planning can be very tedious. Machine learning is an effective tool for automatically calculating growth trends and predicting database growth.
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
One challenge with SQL Server database automation is that eventually you're going to have to execute a native TSQL statement. There are some very trendy tools out there, ie. Puppet, Ansible, etc... and it can be a challenge to accomplish everything using their native framework. Have you ever seen a linked server resource type in… Continue reading Installing SQLCMD on Linux
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 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
When a SQL Server instance has a large number of databases (100s or 1000s), it can be very challenging to complete backups in a timely manner. Using common methods such as Ola Hallengren scripts or native maintenance plans often take a long time due to serial processing (1 processor). So the question becomes, how do… Continue reading Parallel Ola Hallengren Backups
This month's TSQLTuesday is hosted by Steve Jones on the topic of triggers! In a large enough environment, eventually the question will be asked "is this database still being used?" There's a few technologies available to help you answer this question and by far the worst is logon triggers. I work in a large mixed… Continue reading Logon Trigger Woes