
New Upcoming Session – Troubleshooting Common SSDT Errors
As a spiritual “part 4” in my ongoing series of webinars titled “CI and CD with SSDT”, I will be delivering an entirely new session called “Troubleshooting Build and Deployment of SSDT Projects for SQL Server DevOps” (or “Troubleshooting Common SSDT Errors” for short).

T-SQL Tuesday #152 – Which version of my database was deployed? It depends!
One of the things that are not so clear about SSDT specifically and database versioning in general, is how should one identify which “version” of your database project was last deployed to your server?
There are many ways to go about doing this. Which is the best one?
In this article, I hope to review several interesting methods of achieving “database versioning”. Some are well-known and obvious, and some are less so. Either way, it should be interesting.

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?
Read more to find out!

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.

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!

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

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?

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!

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?

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.
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:
Archives
- July 2022 (3)
- June 2022 (1)
- May 2022 (2)
- April 2022 (1)
- March 2022 (2)
- February 2022 (1)
- January 2022 (1)
- December 2021 (1)
- October 2021 (2)
- August 2021 (1)
- July 2021 (2)
- June 2021 (2)
- May 2021 (1)
- April 2021 (2)
- March 2021 (2)
- February 2021 (2)
- January 2021 (2)
- December 2020 (2)
- November 2020 (2)
- October 2020 (3)
- September 2020 (3)
- August 2020 (2)
- July 2020 (3)
- June 2020 (3)
- May 2020 (3)
- April 2020 (3)
- March 2020 (3)
- February 2020 (2)
- January 2020 (2)
- December 2019 (4)
- November 2019 (1)
- October 2019 (1)
- September 2019 (3)
- May 2019 (3)
- April 2019 (1)
- January 2019 (2)
- November 2018 (6)
- October 2018 (14)