Latest Posts

T-SQL Tuesday #150 – My First Tech Job

This month’s #tsqltuesday is hosted by Kenneth Fisher (b|t), who wants us to share stories about our first tech job (or first job ever if it makes for a good story). My first job ever was delivering a magazine door-to-door in one neighborhood. It doesn’t actually make for a good story as it’s pretty bland […]

I got the Power: Remote Execution using Powershell and SQL Server

As part of my journey to get better at Powershell, I gave myself a task: Create a project utilizing Powershell at its core, to solve a complicated problem as elegantly as possible.

A complicated problem indeed presented itself: How to remotely control multiple computers without having to log into them? Make them perform any task that could possibly be needed? Control them from one central location? And make the solution as easily scalable as possible?

I present to you, the Framework for Remote Execution using Powershell and SQL Server!

Detect Weak Passwords in SQL Server

This is a T-SQL script that I’m cross-publishing with the official Madeira Data Solutions blog. This script generates various permutations and variations of common and weak passwords and uses the PWDCOMPARE function to check whether there are any enabled SQL logins that have these passwords.

Performance Tuning Like a Pro – with Hypothetical Indexes

Every once in a while there comes an opportunity to “upgrade” your abilities with newly acquired knowledge that lets you “step up your game” and possibly add some “wow factor” to your work, leaving your peers awe-struck by your amazing new “magic trick”. As a SQL Server consultant, one such opportunity that I had in […]

It is 10 PM, do you know where your pages are?

Back in April 2020, I created an open-source project called “SQL Server Page Allocation Reports“. It consisted of a set of SQL queries and some Power BI reports that can be used for visualizing the size and locations of your data and transaction log pages. Well, recently I also added SSMS Custom Reports into the […]

The Simplest Alternative to sp_MSforeachdb

Which drawbacks are there to using the built-in sp_MSforeachdb stored procedure? What other alternatives are out there? Is there a simpler solution? Find out all this and more in this short post.

Loading…

Something went wrong. Please refresh the page and/or try again.


Follow My Blog

Get new content delivered directly to your inbox.

Other ways to find me: