Database Administration & Monitoring, SQL Server SQL Server: Audit changes on Instance Configuration, Linked Servers and Agent Jobs 12.04.2021 by Steven Naudet Introduction Very often with our customers, there is only one person with the DBA role. The configuration of the instances is then under control and if anything strange has to be questioned, the culprit is quickly identified. 🙂 When(…)
Database Administration & Monitoring, SQL Server, Security SQL Server connectivity issue – troubleshoot TLS configuration 08.04.2021 by Steven Naudet In the blog post, I will share a case of troubleshooting a connectivity issue with SQL Server. The problem occurred in a migration context. The SQL Server databases (in version 2008 to 2014) from multiple applications were consolidated on a(…)
Database Administration & Monitoring, SQL Server SQL Server: Create a Shared Storage for your Failover Cluster LAB 31.03.2021 by Steven Naudet I’m currently working on the migration of a Failover Clustered SSAS instance from Windows Server 2012 to Windows Server 2019. The context is quite complex and in order to choose the right migration scenario I need to play with it(…)
Database Administration & Monitoring, Database management, SQL Server Copy or Migrate a SSISDB environment 2.0 19.03.2021 by StĂ©phane Haby Based on the blog “Copy or Migrate a SSISDB environment” of my colleague Christophe, I create a new one named 2.0. In the precedent script, you need to give the folder name and environment name and he(…)
Business Intelligence, Database Administration & Monitoring, SQL Server SQL Server – PolyBase Services when listening on all IP is disabled 16.03.2021 by Christophe Cosme Introduction You will find a lot of blogs explaining how to install the PolyBase feature with a SQL Server database instance. You will also learn how to configure it and how to use it in these blogs. But I could(…)
SQL Server Automate CNOs and VCOs for SQL Server AAG 26.02.2021 by Nathan Courtine During the installation of a new SQL Server environment in a Project, we wanted to automate the whole process deployment and configuration when installing a new SQL Server Always On Availability Group (AAG). This installation requires to prestage cluster(…)
Database Administration & Monitoring, SQL Server SQL Server: Control the size of your Transaction Log file with Resumable Index Rebuild 25.02.2021 by Steven Naudet Introduction In this blog post, I will demonstrate how the Resumable capability of Online index rebuild operation can help you to keep the transaction log file size under control. An index rebuild operation is done in a single transaction(…)
Database Administration & Monitoring, Database management, Development & Performance, SQL Server First steps on Kusto Query Language (KQL) 15.02.2021 by StĂ©phane Haby Do you know this query language? No, it’s time to explain you and see what it is. “A Kusto query is a read-only request to process data and return results.” dixit Microsoft Documentation here The KQL(…)
Database Administration & Monitoring, SQL Server SQL Server tips: How to migrate database-users in another domain without touching permissions 08.02.2021 by Stéphane Haby By a customer, I must migrate a database from a domain to another. The goal is to keep the database-user permissions, take the new SID from the windows login of the new domain and change the database-user name.
SQL Server SQL Server TCP: Having both Dynamic Ports and Static Port configured 21.12.2020 by Steven Naudet Introduction Have you ever seen an SQL Server instance configured to listen on both “TCP Dynamic Ports” and “TCP (static) Port”? This kind of configuration can be caused by the following scenario: A named instance is installed. By default, it(…)