Bijay Kumar Sahoo
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
In this comprehensive article, I will walk you through every major method to move your data from SQL Server to a CSV file. We will cover everything from the quick-and-dirty GUI methods to robust, automated scripting solutions. SQL Server Export Table To CSV Method 1: Using the SQL Server Import and Export Wizard If you … Read more
In this article, I’ll walk you through the process of dropping all constraints on a table in SQL Server. We will cover the manual approach, the programmatic script approach, and the critical “issues”. Drop All Constraints On A Table Sql Server What Are SQL Server Constraints? We classify constraints into five main categories. Constraint Type … Read more
In this article, I’m going to walk you through the “why,” “when,” and “how” of rebuilding indexes. We’ll cover the T-SQL commands you need, the difference between a Reorganize and a Rebuild, and the best practices. SQL Server Rebuild All Indexes On A Table Understanding Fragmentation: Why Rebuild at All? Before we get into the … Read more
Understanding the SQL Server permissions is essential. In this comprehensive guide, I will walk you through the intricate layers of SQL Server permissions. We will move from the conceptual down into the granular details of securing individual objects. SQL Server Permissions Understanding the SQL Server Security Hierarchy SQL Server security is hierarchical. To understand permissions, … Read more