This article gives you an insight into SQL Server Index properties in SSMS.
Read more »
SQL Server Management Studio (SSMS)
Script templates in SQL Server Management Studio (SSMS)
April 27, 2020SQL 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.
Read more »
Overview of Solutions and Projects in SSMS
March 30, 2020DBAs 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.
Read more »
CREATE VIEW SQL: Working with indexed views in SQL Server
March 24, 2020This 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.
Read more »
CREATE VIEW SQL: Inserting data through views in SQL Server
March 16, 2020This 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.
Read more »
Execution Plans in SQL Server
March 10, 2020Introduction
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.
Read more »
Monitor Transaction Log shipping using T-SQL and SSMS
March 10, 2020Database 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.
Read more »
How to filter objects in SSMS 2016
March 5, 2020This 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.
Read more »
CREATE VIEW SQL: Modifying views in SQL Server
March 5, 2020In 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.
Read more »
SQL Server Query Store options in SSMS 18.4
March 4, 2020In this article, we will run through the new options added in the Query Store with SSMS v18.4.
Read more »
An overview of Code Snippets in SSMS
February 24, 2020This article explores the SSMS Code Snippet feature and ways to customize it.
Read more »
How to set custom colors in the SSMS status bar
February 19, 2020This article explains the process of defining custom color codes for SQL Server connections in SSMS.
Read more »
Methods to script SQL Server database objects
February 14, 2020In this article, we will explore various ways for scripting SQL Server database objects.
Read more »
Different methods to attach SQL Server MDF files
February 7, 2020This article demonstrates different methods to attach SQL Server MDF files. First, let me explain about the database files.
Read more »
Importing a BACPAC file for a SQL database using SSMS
February 6, 2020This 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.
Read more »
Overview of Microsoft SQL Server Management Studio (SSMS)
January 27, 2020Introduction
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:
Read more »
CREATE VIEW SQL: Creating views in SQL Server
January 23, 2020Introduction
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.
Read more »
Generate data scripts using SSMS and Azure Data Studio
January 13, 2020This article explores different ways to generate data scripts using Azure Data Studio and SQL Server Management Studio.
Read more »
How to fix the “Agent XPs disabled” error
December 27, 2019This article explains how we can fix SQL Server error “Agent XPs Disabled”. Before we dive into troubleshooting and methods for fixing the error, let me explain about Microsoft SQL Server Agent and the Agent XPs configuration parameter.
Read more »
Overview of SQL Server Clustered indexes
December 23, 2019This article targets the beginners and gives an introduction of the clustered index in SQL Server.
Read more »
Send an alert when the database state changes to SQL Server single-user mode
December 18, 2019This article explains the SQL Server single-user mode and how to configure an automated email alert when the state of the user database changes to the single-user mode. To send an alert, we will create a DDL trigger that executes when the user runs the ALTER DATABASE query. It collects the pieces of information using EVENTDATA() function, saves it in a temporary table, and sends an HTML formatted email.
Read more »
How to create a view in SQL Server
December 16, 2019In this article, we will learn the basics of the view concept in SQL Server and then explore methods to create a view in SQL using T-SQL and SQL Server Management Studio.
Read more »
Importing Data into SQL Server from MySQL using SSMS
November 29, 2019This article shows the best way to import a copy of your MySQL database table to SQL Server using the SQL Server import data feature. We’ll demonstrate how to perform data import and export using a query with the assistance of SQL Server Management Studio.
Read more »
Working with XML Data in SQL Server
October 11, 2019XML (eXtensible Markup Language) is one of the most common formats used to share information between different platforms. Owing to its simplicity and readability, it has become the de-facto standard for data sharing. In addition, XML is easily extendable.
Read more »
How to create and configure a linked server to connect to MySQL in SQL Server Management Studio
October 7, 2019This article will guide you with all the necessary steps to successfully create a linked server in SSMS to connect to the MySQL database.
Read more »