Working with resource groups in MySQL 8

MySQL 8 is GA and it has a variety of new features. Recently, we happened to work with resource groups to restrict ...

Upgrade SQL Server Reporting Services to 2017

In the past, we could run the SQL installer to do an in-place upgrade of SQL server including the SSRS instance to a ...

SQL - Managing Jobs in Availability Groups

This blog post will show how to dynamically add logic at the beginning of jobs in Availability Groups in order to avoid ...

Top 10 New Features of SQL Server 2019

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we bring forward a popular post from ...

Resolving an Availability Group Sync Issue - HADR_AR_CRITICAL_SECTION_ENTRY

We recently ran into an interesting issue on a three-node SQL Server Availability Group (AG) cluster. There was a ...

Using SQLCODE Function

The idea of this post is to show how to handle errors using SQLCODE function. That function shows the code error for ...

How to Automate Killing Inactive Sessions with Resource Manager

Problem Statement Are you manually (or via a script) killing idle sessions on your database? As a consequence, your ...

How to prepare a response file for a grid 18c silent upgrade

Due to security and complexity of the environment, the option to use Graphical User Interface (GUI) is not always ...

Migrating SQL Server On-Premise to Azure SQL

Let’s revisit our options when moving your SQL Server workloads to Azure and check out ways to migrate on each of them. ...

Conventions Make for Easy Automation

Fix: SQL Server to PostgreSQL Linked Server Error - "Requested conversion is not supported."

Managing SQL Jobs in Availability Groups - Method Job Category

Method - Job Category This blog post will show how to setup SQL Jobs in multiple availability groups. This method will ...

Log buffer #549: a carnival of the vanities for DBAs

This log buffer edition covers Cloud, Oracle, SQL Server and MySQL.

A simple command that saved me

Context So there I was, reviewing the environment to create an action plan for patching. To my surprise, I noticed the ...

Azure Platform and Network Infrastructure Security fundamentals

Extracting DML Stats/Workload With GoldenGate

Quantifying data movement across the environment After setting up GoldenGate in your environment, you might ask ...

Best practice recommendations for Windows hosting SQL server on VMware

Did you know it's very important to ensure that your VMware environment is properly set when hosting SQL Server ...

How To Export Collections in SCCM to CSV Using Powershell

Your mission: Gather a list of servers in a specific collection on System Center Configuration Manager (SCCM) so you or ...

How I Finished a GI OOP Patching From 19.6 to 19.8 After Facing cluutil: No Such File or Directory and clsrsc-740 Errors

This past weekend I was doing a production grid infrastructure (GI) out-of-place ...

This past weekend I was doing a production grid infrastructure (GI) out-of-place patching (OOP) from 19.6 to 19.8 for a ...

Installing SQL Server 2008 R2 on Windows 2012 cluster

Despite being an older version, some applications may require you to install a SQL Server 2008 R2 clustered instance on ...

How to install Vertica for test purposes

The column-oriented Vertica Analytics Database Platform was designed to manage large, fast-growing volumes of data and ...

Select vs Assign – How To Assign PL/SQL Variables

Select vs Assign It isn’t unusual to see PL/SQL that contains select columns into variables from some_table This is ...

Graph Algorithms and Inference

Context If you’ve used Google Maps for directions or “friended” someone on Facebook, you’ve experienced graph theory. ...

User “guest” does not have permission to run DBCC CHECKIDENT for object

DBCC CHECKIDENT example DBCC CHECKIDENT is used to check or change the value of an identity column in the specified ...