SQL Connection Strings tips
September 24, 2021This article intends to give some useful tips on usage details of the SQL connection strings.
Search Results for: extended events
Identify and remediate non-compliant Azure SQL Databases for auditing on SQL Server
September 16, 2021This article explores the Azure built-in policies and implements them to check and fix Azure SQL Database and Azure SQL Server compliance.
SQL Server Stored Procedure Recompile Options
September 15, 2021This article intends to give comprehensive details on how we can use the recompilation options of SQL Server stored procedures and how they behave when we use these recompilation options.
SQL Server Stored Procedure Recompilation Factors
September 6, 2021In this article, we will explore in detail the factors that cause SQL Server stored procedures to be recompiled.
SQL Query recompilations and query performance effects
September 1, 2021This article will mention in which conditions the query optimizer decides to recompile to queries and how it affects the SQL query performance.
Fundamentals of SQL Server Statistics
August 27, 2021In this article, we will take a glance at the fundamentals of SQL Server statistics and discover their interaction with the query processing steps with simple examples.
SQL Server Performance Tuning made simple
April 19, 2021In this article, we’ll show a process for SQL Server performance tuning, and several tools, tips and techniques you can use to monitor performance and take the necessary steps to improve it.
Capturing deadlocks on AWS RDS SQL Server databases
April 7, 2021This article will explore the process to capture deadlock XML and deadlock graphs for AWS RDS SQL Server databases.
Lease Timeouts and Health Checks in SQL Server Always On Availability Groups
March 8, 2021In the 42nd article for SQL Server Always On Availability Groups, we are going to explore lease timeouts and health checks.
Modes of Transactions in SQL Server
February 17, 2021In this article, we are going to talk about the modes of transactions in SQL Server.
Session timeouts in SQL Server Always On Availability Groups
February 8, 2021In this 41st article for SQL Server Always On Availability Groups, we will explore the session timeout configurations for AG replicas.
A quick overview of database audit in SQL
January 28, 2021Database auditing is an important task that helps to guide the organization and can point out areas that can be improved, the cause of functions that aren’t quite working as intended, or simply monitoring activity for compliance with government or industry policies. At its core, an audit simply logs events that are happening on the […]
Synchronize logins between Availability replicas in SQL Server Always On Availability Groups
January 21, 2021In this 40th article on SQL Server Always On Availability Group series, we will discuss logins synchronization between replicas.
Configure Integration Services Catalog Database SSISDB in SQL Server Always On Availability Groups
December 14, 2020In this 39th article for SQL Server Always On Availability Group series, we will learn to configure SSISDB in the highly available AG groups.
Configure SQL Server Always On Availability Groups using Windows PowerShell scripts
December 10, 2020In this 38th article for SQL Server Always On Availability Groups, we will explore Windows PowerShell scripts to configure it.
Dynamic management views for monitoring availability replicas and databases for SQL Server Always On Availability Groups
November 19, 2020In this 37th article for SQL Server Always On Availability Groups, we will explore useful dynamic management views for monitoring availability replicas and databases.
Explore dynamic management views for monitoring SQL Server Always On Availability Groups
November 16, 2020In this 36th article for SQL Server Always On series, we will explore various dynamic management views (DMV’s) for monitoring the AG replicas.
Getting started with Azure SQL Database auditing using Blob storage
November 16, 2020Introduction In this article we are going to show how to get started with the Azure SQL Database auditing using specific auditing techniques to configure audit specification and reconstruct audit data trail. Companies nowadays choose to migrate to the Azure cloud platform due to multiple reasons like:
Custom policies for AG dashboards of SQL Server Always On Availability Groups
November 10, 2020In this 35th article in SQL Server Always On Availability Groups, we will implement a custom policy for monitoring AG groups.
The Hub and Spoke model of policy-based management for SQL Server Always On Availability Groups
November 9, 2020In this 34th article on SQL Server Always On Availability Groups, we will explore policy-based management features for the AG’s.
Explore secrets of the SQL Server tempdb database
October 29, 2020In this article, we will uncover some secrets about the SQL Server tempdb database. Tempdb is a system database and it is used for various internal and user operations. Besides this, the tempdb has many unique characteristics, unlike the other databases. When we take into account all of these features of the tempdb, there is […]
Apply SQL Server patches or cumulative updates in SQL Server Always On Availability Groups
October 14, 2020In this 32nd article on SQL Server Always On Availability Group series, we will discuss the process to apply a service pack or Cumulative packs for AG replica instances.
Make the most of secondary replicas in SQL Server Always On Availability Groups
October 13, 2020In this 31st article of the SQL Server Always On Availability Group series, we will explore how you can use the secondary replica SQL database for your workloads.
Column-level SQL Server encryption with SQL Server Always On Availability Groups
October 12, 2020It is the 30th article in the SQL Server Always On Availability Groups series and explores column-level SQL Server encryption with AG groups.
SQL Server Always On Availability Groups for SQL Server Linux instances
October 6, 2020In this 29th article of the SQL Server Always On Availability Groups series, we configure the AG between SQL Server Linux instances.