-
Improving reliability and resiliency of SQL Server estates with Azure Chaos Studio
Azure Chaos Studio is a fully managed, chaos testing service from Microsoft. And one of those services, I’ve been planning to test drive for a while now. It’s currently in preview, and as such, can be used for free. It has been around since November 2021, and to my understanding, is planned for GA early…
Posted by
-
Babelfish for PostgreSQL, what the heck is that?
A short answer is: Babelfish is an extension for PostgreSQL, that allows your SQL Server applications to speak to PostgreSQL in their native language. The next question you probably have is: “Why would I ever want my applications to do that?” And it’s a valid question, to which the answer would be, to modernize your…
Posted by
-
Musings of the accidental (ex-)manager about leadership
I recently noticed that it’s been awhile since I did a non-technical post, and I’ve been trying to think of a good topic for one. Luckily enough, an opportunity presented itself to write about a personally relevant topic, leadership. So, what makes it relevant for me? As of 1st of February 2023, I became an…
Posted by
-
Open-source vs. commercial database systems
While SQL Server has been one of the cornerstones of my 25+ years career in IT, I’ve occasionally wandered out of my commercial databases comfort zone to the open-source database space (PostgreSQL and less frequently MySQL). These forays to the open-source database systems have definitely become more common as I started working with the public…
Posted by
-
Are we ready for database containers yet?
Containers are a popular way to virtualize and package applications, but when it comes to database workloads, the adoption has definitely been much slower. The technology has been around for a long while (at least in the IT-industry or dog years), and I wondered if we’re ready to use it widespread for databases. And if…
Posted by
-
The Managed Instance that couldn’t be deleted
I’ve written quite a few posts previously about creating Azure infrastructure, and it’s something that I do rather frequently. Typically, it’s to test the templates that I’ve created, after I’ve changed them somehow. While I fully expect my code to sometimes (often) fail, I usually don’t expect the removal of the Azure resources to fail.…
Posted by
-
IaC Database Deployments
Copy-pasting code snippets from StackOverflow isn’t (always) the best way to do infrastructure as a code (IaC) database deployments. In fact, if you’re ever planning to deploy more than two database services, you should probably consider building your own infrastructure as a code templates and repositories. Having IaC repositories and templates gives you the ability…
Posted by
SQLStarters
Recipes for Cloud Database Experts
Categories
- AWS (11)
- Azure (36)
- Blockchain (1)
- Career advice (5)
- Containers (1)
- Databases (42)
- DevOps (4)
- DMV (4)
- Failover Clustering (5)
- Ignite (1)
- Microsoft (13)
- PASS Summit 2013 (5)
- PASS Summit 2014 (2)
- PASS Summit 2015 (5)
- PASS Summit 2016 (1)
- PASS Summit 2017 (1)
- PerfMon (6)
- Performance Monitor (6)
- Performance troubleshooting (8)
- Security (16)
- SQL Server (76)
- SQL Server Administration (78)
- SQL Server DBA (72)
- SQL Server Service Packs (2)
- TCP Chimney Offload (1)
- Tools and Utilities (15)
- Uncategorized (12)
- Windows Administration (11)
- Windows Networking Features (7)
- Windows Server Management (16)
Find me in social media
Search by tag
#automation #azure #azurevm #db2 #opensourcedb #oracle #sqlserver AWS Azure Azure Cloud VM Backups Cluster Validation Database Design Dynamic Management Views IaaS IPSEC Managed Instances Monitoring NETSH PerfMon Powershell Query Tuning SQL Database SQL Database SQL PASS sqlserver SQL Server SSL T-SQL Testing