Understand SQL Server Editions and Components

SQL Server editions:- · Enterprise – Enterprise edition is the topmost edition with all available features. This is best suited for mission-critical Tier 1 applications. Enterprise edition is the...

Explain RDBMS and History of SQL Server?

RDBMS means Relations Database Management System. RDBMS is one of the DBMS types where data is stored in 2 dimension structures called “Table”. RDBMS stores data in table format...

Launch of YouTube Video Channel

Dear Friends We are launching the YouTube Channel “Decode ITES”. Decode ITES will be sharing technical videos over multiple IT infra skills like SQL Server, Postgres, Oracle, Windows, Public...

SQL Server Learning Series

Dear Friends Apologies for less knowledge sharing articles for a long time and Big thanks for stay connected with me. I will be coming up with the “SQL Server...

Error : DBCC could not obtain a lock on this object because the lock request timeout period was exceeded

DBCC CheckDB failed with error “DBCC could not obtain a lock on this object because the lock request timeout period...

BIOS and OS Power Settings to enhance SQL Server Performance

Performance is always a most prioritized task for any DBA and every DBA always prefer to go for a proactive...

SQL Server 2016 – SQL Server Telemetry \ CEIP Services

CEIP (Customer Experience Improvement Program) is somethings runs from ages and almost each vendor perform it to collect product usage...

A Very Happy Holi – Festival of colors, Colors of life

How to create System-versioned temporal tables? – New database feature of SQL Server 2016

Creating a System-Versioned Temporal Table – There are three ways to create a system-versioned temporal table with regards to how the...

Kronothon2.0 – Accept the challenge

Kronothon2.0 – The only difference between Success and Failure is one’s attitude.
Register here to win cash prizes up to 5 Lakhs...