Eitan Blumin's Blog

Should the Database and Application projects be in the same Repository?

Should your SQL Database project be in the same solution as the App project? Or maybe they should be in the same source control repository but separate solutions? Or maybe they should be in completely separate repositories?

Compare SQL Server Instance Properties

A few years ago, I created a couple of T-SQL scripts that can be used for comparing instance-level and database-level properties between two HA/DR replicas. Originally, this supported comparing only two servers. But recently, following a fan request, I upgraded the script to support an unlimited number of servers that you can compare to each other.

2022-06-062022-06-09

T-SQL

The Best Solution for SQL Server Partitioning Sliding Window

Turns out there’s a shortage of solutions online for easily managing partitioned tables in SQL Server. Well… I guess I’ll have to do it myself!

2022-05-302022-05-28

Life

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 […]

2022-05-082022-05-03

SQL Server Database Engine

Monitoring Heartbeats in SQL Sentry

SQL Sentry uses a service to monitor targets. But what if this monitoring service is down? Who will alert about the alerter not alerting? Who is watching the watchers? Who is monitoring the monitor?

2022-04-18

Tools and Scripts

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!

2022-03-292022-03-29

SQL Server Database Development

Filtered Indexes with TRY_CONVERT, ISNUMERIC, and other complex expressions

Who doesn’t like Filtered Indexes, am I right? They’re pretty great, honestly. If… of course… you’re able to actually create them and utilize them in your specific use cases. That… unfortunately, could often become a complicated, if near impossible, task. So, what if our use case is not trivial enough to allow for filtered indexes?

2022-03-10

T-SQL

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.

2022-02-012022-02-01

SQL Server Performance

Detect Low PAGE Compression Success Rates in all Databases

Thanks to Paul Randal and his recently published blog post: “The Curious Case of… tracking page compression success rates“, I finally discovered what was the purpose of the column page_compression_success_count from the system function sys.dm_db_index_operational_stats, and how to use it.

2022-01-172022-01-18

SQL Server Performance

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 […]

2021-12-27

Loading…

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