Microsoft SQL Server in practice: installation, Always On availability groups, backup and restore, performance tuning, security, PowerShell automation, SQL Server on Linux and upgrades.
In this blog I will show you some important powershell commands to prepare a Failover Cluster for AG configuration. Please keep in mind, this is a test environment and I will not talk about firewall rules. Our objective is to configure a failover cluster with two nodes for a AlwaysOn Availability Group (AG) configuration. As this is for my tests…
Since Azure (or AzureRM) module is marked as deprecated some years ago, AZ module is the official replacement to manage Azure resources with PowerShell. This module is running with at least PowerShell 7.0.6 LTS (Long Term Support) or PowerShell 7.1.3, but higher versions are recommended. When PowerShell from 1.0 to 5.1 are component of Windows operating systems, PowerShell 7 is…
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 Azure Resource Inventory is an open-source project developed in PowerShell that allows you to quickly generate a complete Excel report of your Azure…
Today the Data Platform Virtual Summit begin at 09:30 am with the keynote: Creating a Data Culture… My schedule for the day: D4B1 – SPHINX – Configure SQL Server for efficient troubleshooting – Intermediate – Christophe Laporte D4B2 – HYDRA – Unleash the testing of your CI/CD pipelines for SQL Server deployments in Azure DevOps – Advanced – Kevin Chant…
Today the Data Platform Virtual Summit begin at 06:00 am for us…It’s in our time offset, this time better to wake up! 😉 My schedule for the day: D3B1 – KATMAI – SQL MI on Kubernetes – Intermediate – Dhananjay Mahajan D3B2 – KATMAI – Extent and Page Management in Microsoft SQL Server – Expert – Torsten Strauß D3B3 –…
Today the Data Platform Virtual Summit begin at 03:30 am for us… It’s a little bit early but better than yesterday. My schedule for the day: D2B1 – HYDRA – Overview of SQL Server 2022 – Intermediate – Bob Ward & Ajay Jagannathan D2B2 – HYDRA- SQL Server 2022 IQP Deep Drive – Advanced – Kate Smith, Derek Wilson &…
Today the Data Platform Virtual Summit begin at 00:30 am for us… It’s a little bit early but when we like our work and like to learn, we stay up with plaisir. My schedule for the day: After the login, welcome to the lobby! Going to the rooms: After selecting your session, you select the room name and you start!…
Why is this feature interesting? The Azure Synapse Link for SQL Server 2022 will enable you to replicate your operational data into Azure Synapse Analytics dedicated SQL pool. Azure Synapse is an enterprise analytics service that accelerates time to insight across data warehouses and big data systems. Azure Synapse brings together the best of SQL technologies used in enterprise data…
Thanks to dbi services to let me the opportunity to follow this week and next week, the Data Platform Virtual Summit beginning with the Pre-con. I subscribe the session of Guy Glantser about The Performance Tuning Magic Show yesterday & today. It’s every time good to do a refresh and learn about the performance and tuning. It’s good to have…
You probably hear or view that on the security point of view, the next version of SQL Server: SQL Server 2022, has a feature named Ledger. It’s already used in Azure but what is Ledger? In 2 points, I will say: Ledger helps streamline audits, providing cryptographic proof of data integrity to auditors. Ledger is also a protection of the…
Recently I spent some time on a recurring Deadlock problem on a customer’s site in a high concurrency environment. It was only after finding the solution on my own that I discovered that this particular problem is already well documented if you search for the right keyword. ¯\_(ツ)_/¯ Anyway, in this blog, I will give feedback with some useful information…
Today, a customer asks me to have look on each SQL Server instance to control if the user-database Guest is active or not. The easiest way is to go through the CMS (Central Management Servers) with a query but witch query…. The CIS (Center for Internet Security) provides guidance to secure SQL Server. One of the points is to ensure…
