Bijay Kumar Sahoo
Whether you are troubleshooting a slow-running query, knowing how to get the primary key of a table in SQL Server is a non-negotiable skill. Today, I will discuss how I navigate system catalogs and metadata to find these keys. Get Primary Key Of Table SQL Server If you’re a developer or a DBA, you need … Read more
Knowing exactly which SSMS Version you are running is the first step toward a stable environment. In this guide, I will show you how to check your SSMS version using multiple professional methods. How To Check SSMS Version Method 1: The “Help > About” Menu (The Golden Standard) This is the most direct and authoritative … Read more
Showing line numbers in SSMS is a professional necessity for debugging, collaboration, and code reviews. In this article, I will walk you through the authoritative steps to enable and master line numbers across your entire SSMS environment. How To Show Line Numbers In SSMS Step 1: Open the Options Menu Launch SSMS and connect to … Read more
In this article, I’m going to walk you through everything you need to know to master Window Functions in SQL Server. We’ll cover the syntax, the different types of functions, and why they are often superior to traditional aggregation. Window Functions in SQL Server What are Window Functions? At its core, a Window Function performs … Read more
In this article, I will take you on a deep dive into how to use SSMS like a professional. We will cover installation, navigation, and the expert workflows I use to manage complex database environments. How to Use SSMS SSMS is an integrated environment for managing any SQL infrastructure. It’s not the database itself (that’s … Read more
One of the most critical skills in SQL Server is the ability to audit object-level permissions. In this guide, I will walk you through the professional methods I use to identify and audit these permissions using T-SQL, system views, and built-in functions. How to Check Object Level Permissions in SQL Server Understanding the SQL Server … Read more
Knowing how to find a table in SQL Server is a fundamental skill. In this article, I’m going to share the exact methods I use every day to navigate massive schemas and locate specific objects in seconds. Find Table In SQL Server Method 1: The Visual Approach (SQL Server Management Studio) If you’re a fan … Read more
The GRANT SELECT command is arguably the most frequently used tool. In this article, I will show you how to execute the GRANT SELECT statement with precision, covering both the T-SQL syntax and the SQL Server Management Studio (SSMS) interface. SQL Server Grant Select On Table Method 1: The T-SQL Way T-SQL is faster, scriptable, … Read more
Understanding database role permissions in SQL Server is your first line of defense. In this guide, I’ll show you how to pull back the curtain on SQL Server security. We’ll cover everything from the GUI approach to the deep-level system views that professional DBAs and developers use. How To Check Database Role Permissions In Sql … Read more
In this article, I’m going to deep-dive into one of the most essential, yet often misunderstood, functions in T-SQL: SCOPE_IDENTITY(). SCOPE_IDENTITY SQL Server What is SCOPE_IDENTITY() in SQL Server At its core, SCOPE_IDENTITY() is a scalar function that returns the last identity value inserted into an identity column in the same scope. In SQL Server, … Read more