DataBaseBlogs.com

How To Shrink A Database In SQL Server?

November 22, 2024 by Grey Recently, my team got a requirement to reduce the size of one of our SQL Server databases to boost the performance of that DB. As a team, we analyzed this requirement and identified a few ways to do this. In this article, I will walk you through multiple ways to shrink a database in SQL … Read more

How To Generate Script Of Table With Data In SQL Server?

December 9, 2024November 19, 2024 by Grey Recently, we were working on an SQL Server database migration project. For the critical tables, we generated scripts, including their data, which made our job easy during migration activities. In this article, I will walk you through all the steps to generate the script for the table with data in SQL Server in real-time. How … Read more

How To Get The Primary Key Of A Table In SQL Server?

December 9, 2024November 18, 2024 by Grey As a SQL developer, as part of my daily tasks, I used to work on multiple issues where I used to find the primary key of a table in an SQL server. In this article, I will walk you through multiple approaches. How To Get The Primary Key Of A Table In SQL Server Let … Read more

How To Enable SA Account In SQL Server?

December 14, 2024November 13, 2024 by Grey As an SQL Server DBA, you will encounter many scenarios in which enabling the SA (System Administrator) account is necessary. My daily activity is troubleshooting authentication issues and working on some Legacy applications that require sa access. Based on my analysis, I have identified some simple approaches to enabling an account in SQL Server. In … Read more

How To Create A User In SQL Server Database?

December 14, 2024November 12, 2024 by Grey As a DBA working with SQL server and managing SQL Server environments, I have created tons of users in SQL server. It is crucial to know how to do this task smoothly. In this article, I will walk you through the simplest approaches I used to follow to create SQL server user. How To Create … Read more