SQL Server Management Studio (SSMS)

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.

SQL Server Query Store options in SSMS 18.4

March 4, 2020 by Gauri Mahajan

In this article, we will run through the new options added in the Query Store with SSMS v18.4.

An overview of Code Snippets in SSMS

February 24, 2020 by Rajendra Gupta

This article explores the SSMS Code Snippet feature and ways to customize it.

How to set custom colors in the SSMS status bar

February 19, 2020 by Rajendra Gupta

This article explains the process of defining custom color codes for SQL Server connections in SSMS.

Methods to script SQL Server database objects

February 14, 2020 by Rajendra Gupta

In this article, we will explore various ways for scripting SQL Server database objects.

Different methods to attach SQL Server MDF files

February 7, 2020 by Nisarg Upadhyay

This article demonstrates different methods to attach SQL Server MDF files. First, let me explain about the database files.

Importing a BACPAC file for a SQL database using SSMS

February 6, 2020 by Rajendra Gupta

This article gives you an overview of BACPAC package and its usage in SQL Database data refresh (data import and export) using SQL Server management studio.

Overview of Microsoft SQL Server Management Studio (SSMS)

January 27, 2020 by Esat Erkec

Introduction

Microsoft SQL Server Server Management is an advanced development environment that enables us to configure, manage and administrate SQL Server database engines. SSMS is very popular and widely used by the database developers and administrators because of the following advantages:

CREATE VIEW SQL: Creating views in SQL Server

January 23, 2020 by Bojan Petrovic

Introduction

In this article, we are going to see how to use the CREATE VIEW SQL statement to create a view. This is the first article in a series that will be a programmatical approach of creating, altering and working with views using T-SQL. If you are a beginner and you don’t even know what a view is, don’t worry. We will kick off with a definition, and then move on to some basics like syntax, examples, use cases, etc.