NoSQL, SQL Server A generic jdbc tester (part III) 27.01.2023 by Oracle Team A generic utility to test JDBC connections to any RDBMS or no SQL data source whose JDBC drivers are provided. Firebird, SQL Server, HSQLDB, MongoDB, Excel, conclusion.
Database Administration & Monitoring, SQL Server SQL Server: Heap page deallocation and IndexOptimize 23.01.2023 by Steven Naudet Introduction HEAP tables are a type of data structure that, unlike a clustered index table, does not have a specific ordering of its rows, making them faster to insert and delete data. They are often used for temporary “staging” tables.
SQL Server Prepare Failover Cluster for AG configuration 01.12.2022 by Microsoft Team 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(…)
Azure, Cloud, SQL Server Installing Azure AZ Module on Windows 30.11.2022 by Nathan Courtine 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(…)
Azure, Cloud, SQL Server 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(…)
Azure, Database Administration & Monitoring, Database management, SQL Server Data Platform Virtual Summit 2022 – Day 4 – Focus on Azure SQL Managed Instance 22.09.2022 by Stéphane Haby 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 LaporteD4B2 – HYDRA –(…)
Database Administration & Monitoring, Database management, SQL Server, Technology Survey Data Platform Virtual Summit 2022 – Day 3 21.09.2022 by Stéphane Haby 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(…)
Database Administration & Monitoring, Database management, SQL Server, Technology Survey Data Platform Virtual Summit 2022 – Day 2 20.09.2022 by Stéphane Haby 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(…)
Cloud, Database Administration & Monitoring, Database management, SQL Server, Security Data Platform Virtual Summit 2022 – Day 1 19.09.2022 by Stéphane Haby 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,(…)
Azure, Big Data, Business Intelligence, Cloud, Database Administration & Monitoring SQL Server 2022 – Azure Synapse Link 15.09.2022 by Christophe Cosme 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(…)