Clota Blog

Category: SQL Server

  • Connect to SQL Managed Instance from an on-premises client computer by using a point-to-site connection

    In this section, you will learn how to connect SQL managed instance from an on-premises client computer by using a “point-to-site” connection. Point-to-Site VPN connections are useful when you want to connect to your VNet from a remote location. Prerequisites: Follow below sequence steps by step to connect SQL Managed Instance from an on-premises client machine (wherein will…

  • DBCC (Database Console Command) Commands

    It’s a common question of DBA interview. I already have faced millions of time. HaHa Ha. DBCC is a series of statements in Transact-SQL programming language to check the physical and logical consistency of SQL Server database. We can divide in 4 major category or type… DBCC command type… 1.    Informational DBCC command 2.       Validational DBCC command 3.       Maintenance…

  • SQL Server Architecture and Basics

  • CAP Theorem

    In theoretical computer science, the CAP theorem, also named Brewer’s theorem after computer scientist Eric Brewer, states that it is impossible for a distributed data store to simultaneously provide more than two out of the following three guarantees: Consistency Every read receives the most recent write or an error. Availability Every request receives a (non-error)…

  • Important SQL Server Scripts…

    Restore Progress Check… ========================================================================== DECLARE @DBName VARCHAR(64) = ‘ODS’ DECLARE @ErrorLog AS TABLE([LogDate] CHAR(24), [ProcessInfo] VARCHAR(64), [TEXT] VARCHAR(MAX)) INSERT INTO @ErrorLog EXEC master..sp_readerrorlog 0, 1, ‘Recovery of database’, @DBName INSERT INTO @ErrorLog EXEC master..sp_readerrorlog 0, 1, ‘Recovery completed’, @DBName SELECT TOP 1     @DBName AS [DBName]    ,[LogDate]    ,CASE       WHEN…

  • Important PS (Power shell) Scripts

    $a = get-eventlog -logname system -message *SQL* -newest 1 $a | select-object -property * ————————————————————————————————————- EventID            : 7036 MachineName        : ABCD Data               : {83, 0, 81, 0…} Index              : 4281381 Category         …

  • innodb_change_buffer_max_size

    With MySQL 5.6.2, you can set the maximum size of the change buffer as a percentage of the total size of the buffer pool using the innodb change buffer max size configuration option. The default value for innodb change buffer max size is 25. The maximum number of characters is 50. On a MySQL server…

  • CPU Components

    CPU consists of 6 main components: 1. CU Control unit  2. ALU Arithmetic logic unit  3. Registers 4. Cache 5. Buses 6. Clock All the components work together to allow processing and system control. Control Unit (CU) It fetches, decodes, and executes instructions. It issues control signals that control hardware. It moves data around the…

  • Cache Memory

    Hey guys, In this blog I am going to explain you about Cache Memory Cache is a small amount of high-speed random-access memory (RAM) built directly within the processor. It is used to temporarily hold data and instructions that the processor is likely to reuse. This allows for faster processing as the processor does not…