SQL Server Management Studio (SSMS)

An overview of the sp_helptext statement

June 28, 2021 by Nisarg Upadhyay

In this article, we are learning about the sp_helptext statement. I am going to show the various examples of the usage of it. I will also explain the two alternatives of the sp_helptext statement.

ALTER DATABASE SET SINGLE_USER statement in SQL Server

June 7, 2021 by Nisarg Upadhyay

In this article, we are going to explore the purpose of the ALTER DATABASE SET SINGLE_USER statement. The ALTER DATABASE SET SINGLE_USER is used to put the database in single-user mode. When any database is in single-user mode, the new user cannot connect to the database. However, the users that are already connected to the database do not get disconnected.

Different ways to change database owners in SQL Server

May 17, 2021 by Nisarg Upadhyay

In this article, we will explore different ways in SQL Server to change the database owner. We can use any of the following methods in SQL Server to change the database owner.

Resolving SQL Server errors: The Primary Filegroup is full

May 6, 2021 by Nisarg Upadhyay

In this article, we are going to understand SQL Server error: The Primary filegroup is full and how we can fix this error.

Different ways to check SQL Server uptime

April 26, 2021 by Nisarg Upadhyay

In this article, we are going to explore different ways to check the SQL Server uptime. We can determine SQL Server uptime by using any of the following methods:

T-SQL scripts to identify unused database files

October 30, 2020 by Nisarg Upadhyay

In this article, I am going to show how we can automate the report of unused database files using T-SQL.

T-SQL scripts to generate database health reports

October 21, 2020 by Nisarg Upadhyay

In this article, I am going to show how we can automate a database daily health report using T-SQL scripts. For a senior database administrator, it is always important to review the health of the database server. When a DBA manages many database servers, it becomes difficult to visit every server and review the status of databases, SQL jobs, and backups. To ease the monitoring, I have developed a T-SQL script that populates the following information:

An overview of the db_datareader role

October 12, 2020 by Nisarg Upadhyay

In this article, we are going to learn about the db_datareader role. It is a fixed, database-level role. The database-level roles are a group of security principals that are used to manage the permissions within the databases more efficiently. There are two types of database-level roles. One is a predefined database-level role, and another is custom database-level roles. The custom database-level roles can be created by the database administrator or the member of the db_owner role.

Split SQL database backups into multiple backup files using SSMS

July 29, 2020 by Nisarg Upadhyay

In this article, I am going to explain how we can split the large backup file into multiple small backup files using SSMS 2016. I will also explain how we can combine multiple backups to restore a database and split the backup of the SQL database using SQL Server Management Studio (SSMS).

Enforce SQL database best practices using SQL Server Policy-Based Management

July 24, 2020 by Nisarg Upadhyay

In this article, I am going to explain how we can enforce the SQL database best practices using Policy-Based Management. The policy-based management feature of SQL Server was introduced in SQL Server 2005. This feature was useful because it helps database administrators to define and enforce the database policies based on the organizations’ requirements.

An introduction to SQL tables

July 17, 2020 by Esat Erkec

In this article, we will learn the concept of SQL tables and then work on how we can create tables with different techniques in SQL Server.

Explore SQL Server Index Properties in SSMS

July 2, 2020 by Rajendra Gupta

This article gives you an insight into SQL Server Index properties in SSMS.

Script templates in SQL Server Management Studio (SSMS)

April 27, 2020 by Rajendra Gupta

SQL Server Management Studio (SSMS) is a popular client tool to connect with SQL Server and perform various development and administrative tasks. Beginner developers or DBAs might not be familiar with T-SQL or code for specific tasks. Even for an expert DBA, query templates and shortcuts help immensely to save time and improve productivity. SSMS template explorer is an often-overlooked solution, but it is a useful feature.

Overview of Solutions and Projects in SSMS

March 30, 2020 by Rajendra Gupta

DBAs and developers manage a broad set of queries, codes, applications. It is a good practice to organize code or t-SQL scripts so that we can easily access them without wasting time searching for them. You might use Visual Studio, GitHub source control for it. In this article, we look at how Solutions and Projects help to organize T-SQL scripts.

CREATE VIEW SQL: Working with indexed views in SQL Server

March 24, 2020 by Bojan Petrovic

This is the fourth article in a series of learning the CREATE VIEW SQL statement. So far, we have done a great deal of creating and altering views using T-SQL. In this last part, I want to take a big look at how to work with indexed views.

CREATE VIEW SQL: Inserting data through views in SQL Server

March 16, 2020 by Bojan Petrovic

This is the third article in a series of learning the CREATE VIEW SQL statement. So far, I’d say that we’re comfortable and familiar with the syntax, and we’ve learned how to create and modify views. In this part, we’ll continue to work on views using the sample database and data that we created so far.

Execution Plans in SQL Server

March 10, 2020 by Aveek Das

Introduction

In this article, I’m going to explain what the Execution Plans in SQL Server are and how to understand the details of an execution plan by reading the various metrics available once we hover over the components in the plan.

Monitor Transaction Log shipping using T-SQL and SSMS

March 10, 2020 by Jignesh Raiyani

Database Administrators are vigilant on the backup and restore processes and use the Monitor Transaction log for the same. SQL Server Transaction Log shipping’s prime steps are Transaction Log backup, copy and restore. The answer to solving Disaster Recovery (DR) at the database level can be achieved by SQL Server Transaction Log shipping.

How to filter objects in SSMS 2016

March 5, 2020 by Nisarg Upadhyay

This article explains different ways to filter the objects in the object explorer of the SSMS 2016. When we are working with hundreds of databases or hundreds of objects within a database, then it becomes challenging to locate a specific database or database object. To handle such challenges, we can use the filter option in the SQL Server management studio. In the SQL Server management studio, we can apply a filter on the following objects.

CREATE VIEW SQL: Modifying views in SQL Server

March 5, 2020 by Bojan Petrovic

In my previous article, we looked at how to use the CREATE VIEW SQL statement to create views. In this one, we are moving on and focusing on how to modify views. We will continue using examples on a sample database and data created in the first write-up so in order to follow along, head over and read the Creating views in SQL Server part before starting with this one.