Got non-production instances with different sets of users and permissions and want to automate putting them back in place with refreshes? PowerShell's got you covered. read more
Automating your database code deployments and data updates is good. Knowing what is actually being deployed or updated is even better. Here's something that might help. read more
If you're looking for the real "killer feature" of SQL Operations Studio, I'd wager this might be the one. Let's build a repository, connect to it, and push code. All in less than 15 minutes. read more
Thanks to the magic of PowerShell, JSON, and SQL Ops Studio custom configurations, you can quickly import your registered servers from SSMS. Here's a script to help you. read more
Thanks to SQL Server Operations Studio, insights into your servers have never been easier to create. Here's a quick demo on how to create custom dashboard visuals. read more
Since we did it on Ubuntu, let's keep the Linux party going: Here's how you can set up SQL Server Active Directory authentication with CentOS. read more
SQL Server on Linux is here, and if you want to use Active Directory authentication, there's a lot of steps involved to get it working. Let's walk through the configuration on Unbuntu! read more
If you work with SQL Server transactional replication, here are my top three replication-specific stored procedures that I think you should know about. read more
Let's explore the magical world of message queuing, and how you can leverage SQL Server Service Broker to put data changes into remote queues. including really cool demo using PowerShell and RabbitMQ. read more
Did you know that you can enable system-versioned temporal tables on something that's marked for replication, even though it isn't supported? Yeah, me either. Here's what happened, and how you can fix it. read more