Barbarin David

⌨️ Senior Database Administrator 🇨🇵 🇨🇭 - #SQLServer #K8s #Azure #PowerShell #Linux #DevOps #Azure #GCP 📋 🗣 🔚

[Barbarin David @mikedavem]

@FranckPachot @PatHelland @SQLServer @PostgreSQL @OracleDatabase Yes but I had in mind optimized locking that improves writer <-> writer part https://t.co/xHz4jNbJeL . But most efficient MVCC implementation comes with in-memory tables

[Barbarin David @mikedavem]

#sqlhelp When using #Azure AD authentication + PIM with SSMS, it is boring to restart it to refresh permissions and get access to menus granted by the escalated privilege. Any tips for that ? cc @erinstellato

[Barbarin David @mikedavem]

Topic is not only for DBs by the way :)

[Barbarin David @mikedavem]

Interesting stuff and discussion today ... provisioning an #azure SQL DB with #IaC is easy but protecting against deletion is not (regarding the context) if you want to stay "agile" :)

[Barbarin David @mikedavem]

Finally, we got an answer from Microsoft that database copy to Az Sql behind PE work with AAD authentication and not SQL one.

[Barbarin David @mikedavem]

#sqlhelp I'm using CREATE DATABASE COPY AS OF with SQL Azure DBs behind private endpoints and according to my tests it works well. I didn't enable public access. The BOL (https://t.co/bAYvQdbRXp) seems to indicate the opposite. Any thoughts, feedback on this topic ?

[Barbarin David @mikedavem]

@browncspence @arpit_bhayani Mongodb only supports async replication. Easy to scale in this case but consistency is not guaranteed across nodes …

[Barbarin David @mikedavem]

@CFDevelop @Cameron10300 Performance is another topic but not the argument for splitting a monolith into microservices. By the way, big tables in our context is not a problem. At the opposite, one microservices db with few records (~100) is a very hot spot and good indexing strategy helps to scale

[Barbarin David @mikedavem]

@CFDevelop @Cameron10300 The only performance / scalability argument is probably not relevant here and we miss probably the real context. I work in a microservices environment with sqlserver dbs and main goal is to scale dev teams and reduce the time to market.

[Barbarin David @mikedavem]

@erinstellato Application intent=readonly ..

[Barbarin David @mikedavem]

@erinstellato Having an option for connecting to AG RO replica instead of putting the parameter in advanced section

[Barbarin David @mikedavem]

@FranckPachot Who is jocking here ? your kid or you ? :D

[Barbarin David @mikedavem]

@redgate sqlcompare and automation (with powershell) is very 👍. It saves lot of time to check if we miss some objects during database migration especially when there lot of databases …

[Barbarin David @mikedavem]

Finally challenge met : automated provisioning #Azure Sql VM and workgroup AG with terragrunt / #terraform and powershell DSC (through extension) . A good day ….

[Barbarin David @mikedavem]

Moving to the cloud has some advantages and gives priority to old requests and fix some tech debts that would cost in the cloud ^^

[Barbarin David @mikedavem]

#sqlhelp Does anyone knows how to get cause of warning with Azure Data Migration service ? I didn't find out any evidence of information so far . The data transfer is ok but I get a warning warning status at the end ...

[Barbarin David @mikedavem]

@jdanton ... and probably meets most of customer scenarios

[Barbarin David @mikedavem]

#Azure SQL IaaS vs PaaS makes really sense when it comes IaC ... Not the same effort for provisioning services... Expected but deserves to be reminded

[Barbarin David @mikedavem]

@jdanton Unfortunately ARM template seems to not address all the scenarios as far as I know (multi-subnet, workgroup AGs ...) but that's a good start for sure

[Barbarin David @mikedavem]

@jdanton Amount of code (terraform in my case) and settings to deal with for the same "kind of architecture" . SQL availability group is a good example (Azure SQL DB vs SQL MI vs Azure SQL VM)