SQL Server In-Place Upgrade Failed: Wait on the Database Engine Recovery Handle Failed

A few weeks ago I was performing an in-place upgrade from SQL Server 2014 to SQL Server 2017. I followed each and every pre-check before performing an in-place upgrade, but got an  error message at the end of the installation….

Read More >

How to Install SQL Server Reporting Services 2019

sql server reporting

  Problem You’re trying to install SQL Server 2019 and when you reach the feature selection SSRS is nowhere to be found. You also get this notification banner below:   Cause SSRS installation has been separated from Microsoft SQL Server…

Read More >

Why Comprehensive Health Checks for MS SQL Servers Matter: Part 2

ms sql health checks

First part of this blog post: https://blog.pythian.com/why-comprehensive-health-checks-for-ms-sql-servers-matter-part-1/.     The SQL Server Health Check is ready to generate many reports. Four of them are useful and critical in ensuring your SQL Server environment is performing optimally, secure, and can recover…

Read More >

Using Kafka to Replicate Data from Postgres to MS SQL Server: Part 1

kafka

    The Challenge You’ve probably heard the expression, “Data is the new oil”.  That’s because data is at the heart of any business decision system of any organization. However, the data you need  isn’t always located in only one…

Read More >

FIX: SQL Server Installer Hangs on Existing Clustered Instance “Running Discovery on Remote Machine”

SQL Server

Problem You’re trying to install a service pack, cumulative updates, or run the installer to add a shared feature on a SQL Server clustered instance. The installer just hangs and doesn’t progress without any indication on the GUI as to…

Read More >

Fix: SSIS Installation Error – Rule “Existing clustered or clustered-prepared instance” Failed

ssis installation

  Problem You’re trying to install SQL Server Integration Services to an existing SQL Server failover cluster. You chose to add the shared feature to the existing instance and received the error below and couldn’t proceed: Cause You are receiving…

Read More >

Fix: SSIS Catalog Creation Error – “SQL Server Denali is Required to Install Integration Services”

ssis catalog error

  Problem You’re trying to create an SSIS Integration Catalog using SQL Server Management Studio for a SQL Server Instances dated 2016 or later. Upon right-clicking and choosing “Create Catalog, you see this error:   Cause You get this error…

Read More >

Why Comprehensive Health Checks for MS SQL Servers Matter: Part 1

sql healthcheck

How you access and retrieve data is crucial to your database’s performance and resilience: the more transactional or analytical the data processing requirements for applications, the greater the likelihood of introducing inefficiencies. As these inefficiencies increase, you may need to…

Read More >

SQL Server AlwaysOn Availability Groups on Google Kubernetes Engine

Infrastructure Design

This tutorial shows you how to configure SQL Server AlwaysOn availability groups (AG) using DH2i DxEnterprise and Google Kubernetes Engine (GKE). This offering helps you achieve high availability for your SQL Server databases running on containers in Kubernetes. GCP Resources…

Read More >

SQL Server Distributed Availability Group with Forwarder in Microsoft Azure

mysql queries

Architecture diagram Register the application with the name terraform. Leave all options as default. Add a secret that will be used as a password to authenticate terraform. Provide a description and expiry period for the secret. Copy the Secret ID…

Read More >
Page 1 of 2312345...10...Last Page »