BE SHARING

Microsoft Team

Azure Resource Inventory: Managed instance integration

25.10.2022 by Microsoft Team

Intro Let me present you in this Blog post a useful tool to asset your Azure environment and in a second step show you how to add Azure SQL managed instance in the assessment report. ARI presentation(…)

Database Administration & Monitoring

How SQL Server MVCC compares to Oracle and PostgreSQL

09.02.2020 by Microsoft Team

By Franck Pachot . Microsoft SQL Server has implemented MVCC in 2005, which has been proven to be the best approach for transaction isolation (the I in ACID) in OLTP. But are you sure that writers do not block readers(…)

Cloud

Provisioning a AKS cluster and KubeInvaders with Terraform

27.10.2019 by Microsoft Team

Provisioning a K8s infrastructure may be performed in different ways. Terraform has a connector called the Kubernetes provider but it doesn’t allow building and deploying a Kubernetes cluster. The cluster must be up and running before using the provider.

Database Administration & Monitoring

SQL Server 2019 Accelerated Database Recovery – Instantaneous rollback and aggressive log truncation

07.10.2019 by Microsoft Team

In my previous article about Accelerated Database Recovery (ADR), I wrote mostly about the new Persistent Volume Store (PVS), how important it was important in the new(…)

Database Administration & Monitoring

Using non-root SQL Server containers on Docker and K8s

29.09.2019 by Microsoft Team

This is something that I waited for a while, in fact since SQL Server 2017 … and the news came out on Wednesday 09th September 2019. Running(…)

Database Administration & Monitoring

When Read-Scale availability groups and Windows Failover Cluster are not good friends

20.09.2019 by Microsoft Team

A couple of days ago, with some fellow French data platform MVPS (@thesqlgrrrl and @Conseilit) we discussed an issue around Read-Scale availability groups(…)

Database Administration & Monitoring

How to get a big picture of K8s pods and PVs by script

14.09.2019 by Microsoft Team

A couple of weeks ago, during an internal dbi services workshop about Docker and K8s, I got an interesting question: is it possible to get a big picture of pods connected to one specific persistent volume(…)

Database Administration & Monitoring

Introducing Accelerated Database Recovery with SQL Server 2019

10.09.2019 by Microsoft Team

SQL Server 2019 RC1 was released out a few weeks ago and it is time to start blogging about my favorite core engine features that will be shipped with the next version of SQL Server. Things should not be completely(…)

Database Administration & Monitoring

Debugging SQL Server containers considerations

05.09.2019 by Microsoft Team

When it comes to troubleshooting processes or to get a deeper look of how SQL Server works internally , I always used debugging tools as windbg on Windows and since SQL Server is available on Linux, I switched to(…)

DevOps

Windows Docker containers, when platform matters

31.07.2019 by Microsoft Team

A couple of days ago, I got a question from a customer about an issue he ran into when trying to spin up a container on Windows.