Database Administration & Monitoring, SQL Server Validate your SQL Server infrastructure with dbachecks 14.12.2020 by Steven Naudet Introduction In this blog post, I’ll do an introduction to the PowerShell module dbachecks. dbachecks uses Pester and dbatools to validate your SQL Server infrastructure. With very minimal configuration you can check that(…)
Database Administration & Monitoring, SQL Server An Introduction to Pester – Unit Testing and Infrastructure checks in PowerShell 03.12.2020 by Steven Naudet Introduction If you never heard of it, Pester is a PowerShell module, written in PowerShell. It’s a framework for writing and running unit tests, integration tests, and also infrastructure checks as we will see in a moment.
Database Administration & Monitoring, Docker, SQL Server Getting started with SQL Server on Linux containers with Docker Desktop and WSL2 31.10.2020 by Steven Naudet In this blog post, I will show you the steps I went through to run SQL Server inside a Linux Docker container on my Windows 10 laptop. The aim here is to deploy quickly and easily SQL Server instances(…)
Database Administration & Monitoring, Database management, SQL Server SQL Server: Generating SQL script using PowerShell and Template file 18.10.2020 by Steven Naudet In this blog post, I will share with you a small PowerShell script I did recently. I have noticed that my customer performs a very repetitive and time-consuming task almost every day. New columns are added to tables on(…)
Database Administration & Monitoring, SQL Server SQL Server AlwaysOn node “Add all eligible storage to the cluster” 14.10.2020 by Steven Naudet I made a mistake recently when adding a new node to an existing Windows Failover Cluster supporting AlwaysOn SQL Server instances. When adding a new node using the GUI there’s this option checked by default named “Add all eligible storage(…)
Cloud, DevOps, SQL Server Data virtualization on SQL Server with Redgate SQL Clone 25.08.2020 by Cloud Team By Franck Pachot . In the previous blog post I’ve installed SQL Server on the Oracle Cloud. My goal was actually to have a look at Redgate SQL Clone, a product(…)
Cloud, Oracle, SQL Server SQL Server on Oracle Cloud 24.08.2020 by Oracle Team By Franck Pachot . You can create a VM with SQL Server running in the Oracle Cloud. This is easy with a few clicks on the marketplace: Here are the steps I did above: Oracle(…)
Database Administration & Monitoring, SQL Server SQL Server: High SQLCONNECTIONPOOL Memory Clerk consumption 13.08.2020 by Steven Naudet In this blog post, I will show you what I did to troubleshoot an interesting problem with Memory on SQL Server. It all started with a job performing DBCC CHECKDB on all databases taking hours to complete instead of 10(…)
Database Administration & Monitoring, SQL Server SQL Server Installation Wizard error : Failed to retrieve data for this request 29.07.2020 by Steven Naudet Today I faced a strange issue when I tried to install a new SQL Server instance : Failed to retrieve data for this request This error occurred just after clicking on “New SQL Server stand-alone installation…”(…)
Database Administration & Monitoring, SQL Server SQL Server: Change Availability Group Endpoint Ownership 27.07.2020 by Steven Naudet I’m doing some cleaning on my customer’s instances. I want to delete the login of a previous DBA for 2 reasons; this person does not work anymore in my customer’s company and all DBA are members of a group(…)