Category: Installation and Configuration
-
DBA Worries Continued Installation and Configuration L1 DBA Monitoring Performance Tuning SQL Scripting SQL Server
Let’s talk about In memory OLTP
In-memory OLTP frequently referred to by its code name “Hekaton”, was introduced in SQL Server 2014 but it got more popular from SQL Server 2016. This feature was being developed by Microsoft to stay in the game for high speed OLTP transaction speed and recent hardware changes in terms of the cost and throughput. Many…
//
-
Auditing: Change Data Capture(CDC)
Overview: Change Data Capture, also known as CDC, introduced the first time in SQL Server 2008 version. Change data capture records insert, update, and delete activity that applies to a SQL Server table. if you want to store the audit information about the UPDATE, INSERT, DELETE operations then enable the SQL CDC on that table. Note: …
//
-
Azure Azure SQL Database DBA Worries Continued High Availability Installation and Configuration SQL Server
Cloud Witness in Azure
Cloud Witness is a type of Fail-over Cluster quorum witness that uses Microsoft Azure to provide a vote on cluster quorum. There are significant benefits which this approach: Problem with traditional cluster setup Lets consider a typical cluster setup which is shown in below diagram. Here we have file share witness in primary DC and unfortunately…
//
-
Step by Step implementing Log Shipping
Log Shipping enables you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances. The transaction log backups are applied to each of the secondary databases individually. ADVANTAGES OF LOG SHIPPING- DISADVANTAGES OF LOG SHIPPING- TYPES OF LOG SHIPPING –…
//
-
STEP BY STEP SQL Server Installation
Hey guys, in this blog I am going to explain you about “Step by step New SQL server stand-alone installation” Minimum requirement for SQL server 2019 installation Hardware requirements: Hard disk – It requires a Minimum 6GB of available hard-disk space. Monitor – Super-VGA (800×600) or higher resolution monitor. Memory – Minimum: …
//
-
Step by Step Configure Windows failover cluster on windows 2019
Step by Step Configure Windows failover cluster on windows 2019- Step 1- First you need to login at the server and go to manage->add roles and features-> add failover clustering and install the features on the server and restart the server. Fig.1 Fig.2 Fig.3 Step-2 Go to failover cluster manager-> create cluster->enter server name -> run…
//
-
SQL Server Checkpoint and Lazy Writer
Good day, everyone! I hope you’re doing well, and Today I’ll show you how to use SQL Server’s Checkpoint and Lazy Writer functions, as well as the many types of checkpoints available. Checkpoint- Fig.1 Advantages of Checkpoint- Types of Checkpoints- There are four different kinds of checkpoints in SQL Server. Automatic checkpoint- When SQL Server…
//
-
Steps to configure Hide DB Instance
Hey guys, In this blog I am going to explain you about “Hide DB Instance” STEP -1: To begin, start SSMS and connect to the server. STEP -2: Expand Database Engine in Network Servers and look for any servers connected to Database Engine, as shown below. Now, if…
//
-
All about tempDB
Hey guys, In this blog I am going to explain you about TempDB TempDB is a workhorse of SQL Server performing a number of functions to support both system and internal operations. With this workload TempDB will process a large number of database writes, which requires low-latency, high throughput underlying storage. What about tempDB Size? It…
//
-
Update Patch Error: Failed to retrieve data for this request.
Update Patch Error: Failed to retrieve data for this request. Step: 1– Login to the Primary Server and install Cumulative Update (CU20) on the Server. Double click on Cumulative patch Update and Install the update. When the Dialog box opens, Click on Yes While installing the Patch in the cluster Environment, if you get the following…
//
-
Copy User DB and System Data and Log Files from One Drive to Another Due to Disk Slowness Issue
Hi guys, in this blog I am going to explain you about copy User DB and System Data and Log Files from One Drive to Another Due to Disk Slowness Issue. Issue- Client Disk Slowness Issue. Solution- These guys set up a 1TB SSD in the server and made partitions from it as well. In…
//