Category: L1 DBA
-
Enabled DAC to connect remotely
Hello there, everyone! I hope everything is going well for you. Today, I’ll show you how to use the DAC and how to enable it for remote connections. DAC- The dedicated admin connection (DAC) can assist you in getting out of a bind. This was created to assist you in connecting to SQL Server and…
//
-
AOG on Azure Blob with a different region SQL Server instance
Hello there, everyone! I hope everything is going well for you. Today, I’ll show you AOG on Azure Blob with different region SQL Server Instance. Ø Created SQL disk layout and formatted with 64K- · Disk E: SQL Binaries · Disk T: TempDB · Disk R: User Databases · Disk L: User DB transaction logs Ø SQL Server Memory Configuration as…
//
-
DBA Worries Continued DBMS Concepts L1 DBA My SQL MySQL Architecture MySQL Basics MySQL L1 SQL Server
Deterministic and Nondeterministic Functions
Deterministic functions: Deterministic functions always result in the same output every time they are called with a fixed set of input values and given the same condition of the database. For example, AVG() function always results the same result given the qualifications stated above. Nondeterministic functions: Nondeterministic functions result in different output each time they…
//
-
Page Life Expectancy (PLE) in SQL Server
Hey guys, In this blog I am going to explain you about Page Life Expectancy and How to monitor it. Page Life Expectancy (PLE)- Page Life Expectancy (PLE) is an age of a data page in seconds in the buffer cache or buffer memory after querying the tables with the loading data page into the buffer memory.…
//
-
Memory Grants Pending
Hello there, everyone! I hope everything is going well for you. Today In this blog I am going to explain you about Memory Grants Pending and How to monitor it. Memory Grants Pending- The number of processes that are pending a workspace memory grant is known as Pending. Because they are unable to acquire adequate RAM while…
//
-
SQL Interview Questions
You can benefit from this article’s popular SQL Server DBA interview questions and answers. To learn more about SQL interview questions, I would advise you to read this post as well as the SQL Server Interview questions and answers. I made an effort to be very specific in my responses to each question in this…
//
-
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…
//
-
PostgreSQL Index and Types
Hey guys, In this blog I am going to explain you about PostgreSQL Index and Types. PostgreSQL Index- The database search engine can use indexes, which are specialized lookup tables, to speed up data retrieval. An index is simply a pointer to information in a table. An index in a database resembles a book’s back…
//
-
Read a big file using PowerShell
# Command-Format: Get-Content ‘your-file-path’ -Tail <number-of-line>Get-Content ‘.\mylargefile.txt’ -Tail 5000 # Get-Content D:\MyBigFeedFile.txt | Select-Object -skip 123798766555672 -first 6
//
-
Win OS Related Quick Commands
Find Who Restarted Windows Server –Run the following command to filter the System Logs with Source as User32. Get-EventLog -LogName System | Where Source -eq User32 –You may also filter the system logs with Event ID 1074 with the following command. Get-EventLog -LogName System | Where EventID -eq 1074
//
-
Data Integrity
Introduction to Data Integrity It is important that data maintain data integrity, which is adherence to business rules determined by the database administrator or application developer. Business rules specify conditions and relationships that must always be true or must always be false. For example, each company defines its own policies about salaries, employee numbers, inventory tracking,…
//
-
SQL Loader
Hi guys, in this blog I am going to explain you about SQL Loader. SQL Loader- Oracle has a powerful application called SQL Loader, which is often referred to as SQL*Loader, that makes it easy to load data from external files into Oracle database tables. When dealing with enormous volumes of data that must be…
//