How to Identify Slow Running Queries using SQL Server Profiler

CREATING A TRACE TO IDENTIFY SLOW RUNNING QUERIES

SQL Server Profiler is an interface to create and manage traces and analyze and replay trace results. Events are saved in a trace file that can later be analyzed or used to replay a specific series of steps when trying to diagnose a problem.
In this post we will see how to create a trace to capture slow running queries using profiler.

Configure SQL Server Always On Availability Group on Windows and Linux (Cross Platform)

Overview

This post demonstrate the steps to create an AlwaysOn Availability Group (AG) with one replica on a Windows server and the other replica on a Linux server. This configuration is cross-platform because the replicas are on different operating systems. This configuration can be used for migration from one platform to the other or disaster recovery (DR). This configuration does not support high-availability because there is no cluster solution to manage a cross-platform configuration.

Configure SQL Server Always On Availability Group on Windows and Linux (Cross Platform) - Part 1

Install and configure SQL Server 2019 on both the nodes


Step #1: Install SQL Server

Install SQL Server on Windows Server
Install SQL Server 2019 on Windows Server 2016 and set mixed mode authentication.

Install SQL Server on Linux
Install SQL Server 2019 on Linux. For instructions, see Install SQL Server on Linux.

Configure SQL Server Always On Availability Group on Windows and Linux (Cross Platform) - Part 2

Create the SQL Server 2019 Always On Availability (AG) Group

The steps to create the AG are the same as the steps to create an AG for read-scale workloads. The AG cluster type is NONE, because there is no cluster manager.

Configure SQL Server Always On Availability Group on Windows and Linux (Cross Platform) - Part 3

Test and verify both the ways to failover the primary replica

There are two ways to fail over the primary replica in an availability group with cluster type NONE.
    -  Forced manual failover with data loss
    -  Manual failover without data loss

Configure Critical Email Alerts in SQL Server

SQL Server has alerts that are more important based on the severity of the error. When an error is raised by the SQL Server Database Engine, the severity of the error indicates the type of problem encountered by SQL Server.

Setting up Email Alerts for SQL Server Deadlocks

There are two main types of Alerts that can be configured within SQL Server. Event Alerts which can be used to track actions within SQL such as critical failures or failed login attempts. Performance Condition Alerts which are more robust and can be used to alert on specific performance related issues.
This post mainly focused on triggering an email alerts when a deadlock occurs on SQL Server instance.

How to Configure Database Mail in SQL Server

Database Mail is an solution for sending e-mail messages from the SQL Server Database Engine. Using Database Mail, database applications can send e-mail messages to users. The messages can contain query results, and can also include files from any resource on the network. For example, if an automation process like jobs, replication, and database log-shipping fails or there are alerts raised then SQL Server can use this feature to notify the administrators or operators.

What's new in SQL Server 2019

Database Engine Enhancements on Windows

Enhancements in the SQL Server 2019 database engine are not limited to PolyBase and Big Data Clusters; many components of the database engine have new features and capabilities with this release. The following features are added or enhanced for SQL Server 2019 CTP 2.0.

Row Level Security in SQL Server 2016

Row Level Security (RLS) feature enables fine grained control over access to rows in a table. Access restriction is located and controlled in the database level rather than at the application tier. Any time the user access the table based on the restriction of RLS, the function is invoked and enforced by the security policy. This enables us to easily restrict the data based on the user identity or security context.


Setting up an Cloudera Cluster on AWS EC2 - Part 1

In this demo we will be configuring cloudera cluster on Amazon Web Services EC2 platform.

Prerequisites

    -   Sign up for an AWS account if you don’t have one.
    -   RHEL 7.5 Operating System
    -   2 Core Processor minimum 8 GB RAM - AWS Instances EC2

Setting up an Cloudera Cluster on AWS EC2 - Part 2

Step #1 Cloudera Manager Installation 

Start NTPD services 
Note: Perform this step on all servers

service ntpd start

Configure SQL Server Always On Availability Group on Linux

Overview

This post explains how to create an SQL Server AlwaysOn Availability Group (AG) for high availability on Linux.There are two configuration types for availability groups. High availability configuration uses a cluster manager to provide business continuity. This configuration can also include read-scale replicas.With Read-scale configuration, availability group can be created without a cluster manager for read-scale. The AG for read scale only provides read-only replicas for performance scale-out. It does not provide high availability.

Configure SQL Server AlwaysOn Availability Groups on Linux - Part 1

Install and configure a cluster resource manager - Pacemaker

SQL Server 2017 introduces two different architectures for availability groups. Always On availability groups provide high availability, disaster recovery, and read-scale balancing. These availability groups require a cluster manager. In Windows, failover clustering provides the cluster manager. In Linux, you can use Pacemaker.

Configure SQL Server AlwaysOn Availability Groups on Linux - Part 2

Install and Configure SQL Server on three cluster servers.

In Part 1, we saw how to install and configure pacemaker with corosync. In this post, we will walk through installation of SQL Server and Linux resource Agent.We will also prepare the security requirements for authenticating the replicas of the Always On Availability Group.

Configure SQL Server AlwaysOn Availability Groups on Linux - Part 3

Create the SQL Server 2017 AlwaysOn Availability Group

In this post, we will see Step-by-step Installation and Configuration of SQL Server 2017 Availability Groups on a Linux Cluster. In Part 2, we enable the Always On Availability Groups feature and configure the security requirements for authenticating the replicas of the Always On Availability Group. This post is a walk through the creation of the Availability Group and its corresponding listener name.

Configure SQL Server AlwaysOn Availability Groups on Linux - Part 4

Creating the SQL Server AlwaysOn Availability Group Resources on Pacemaker

Pacemaker concept is very similar to Windows Server Failover Cluster (WSFC).The cluster resource agent that is installed in Part 2 - mssql-server-ha - is the interface between Pacemaker and SQL Server. It tells Pacemaker about the status and health of the resource – in this case, the SQL Server Always On Availability Group - so the cluster can decide how to deal with it to maintain high availability.

Dynamic Data Masking in SQL Server 2016

Overview

Microsoft has added new security technologies in the SQL Server 2016 platform that provides the administrator the ability to protect sensitive data. One of them (DDM), helps the administrator basically making the message difficult to understand, usually with confusing and ambiguous language for certain selected columns

Setting up SSH Passwordless Login Using SSH Keygen

Secure Shell (SSH) is a cryptographic network protocol used for secure connection between a client and a server and supports various authentication mechanisms. The two most popular mechanisms are passwords based authentication and public key based authentication.

In this post, we will configure password-less login on CentOS 7 using ssh keys to connect to remote servers without entering password.

Install Microsoft SQL Server 2019 on Linux - CentOS

This post explains how to install Microsoft SQL Server 2019 on CentOS (Linux). CentOS is an Enterprise-class Linux Distribution derived from sources freely provided to the public by Red Harm Inc. for Red Hat Enterprise Linux.

Configure SQL Server Resource Governor to Manage CPU, Memory and I/O

SQL Server Resource Governor is a feature that can be used to manage SQL Server workload and system resource consumption. Resource Governor enables us to specify limits on the amount of CPU, physical IO, and memory that incoming application requests can use.