Top-10 SQL Server Management Studio (SSMS) Add-ins You Should Use in 2021

If you deal with SQL infrastructure, especially Microsoft SQL Servers, you deal with SSMS. The SQL Server Management Studio is the default choice for all professionals working with databases. It is not the only option, but it is the leader, backed by Microsoft and equipped with all the necessary SQL Server developer tools.

Still, even with all its advantages, SSMS is not perfection. It needs improvements as it often lacks the necessary or simply helpful functionality. Most SQL specialists inevitably get into situations where SSMS can’t do what they need. Or can’t do it how they want.

CodingSight - Top-10 SQL Server Management Studio (SSMS) Add-ins You Should Use in 2021
Read More

Connecting to SQL Azure from SQL Server Management Studio (SSMS)

Microsoft Azure is a cloud computing service for building, testing, deploying, and managing applications through the Microsoft data centers. It provides the Software as Service (SaaS), Platform as Service (PaaS), and Infrastructure as a Service (IaaS), and supports different database servers, programming languages, and tools.

Azure allows creating databases on various database server platforms, both open source and paid. The deployment is fast and scalable. Besides, the Azure license model is flexible, which helps to reduce the infrastructure costs.

The current article will highlight the following points:

  1. Create an Azure SQL Server instance.
  2. Connect to the Azure SQL Server using SQL Server Management Studio.
  3. Create an Azure SQL database using SQL Server Management Studio.
Read More

Basics of SQL Server Management Studio (SSMS) – Part 1

This article aims to share the basics of SQL Server Management Studio, commonly known as SSMS, and some useful tips on working with it. Also, it highlights the importance of SSMS as database development and administration tool.

About SQL Server Management Studio

It is always good to clarify the SSMS definition(s) first. Let’s review some of the definitions from the database perspective.

Read More

Manage MDF Files in SQL Server 2019

An SQL Server database contains primary data files, secondary data files (optional), and transaction log files.

The primary and secondary datafiles contain tables, database objects, schema, and data.

The file extension of the primary database file is *.mdf, and the file extension of the secondary data file is *.ndf.

The transaction log files store all the changes made by the transactions (insert, update, and delete). If the SQL Server restarts unexpectedly or crashes, the database engine rolls the incomplete transaction back before the point of failure using the Transaction log file.

The extension of the transaction log file is *.ldf. You might want to refer to this article to understand the Transaction Log Files architecture.

In this article, I am going to explain how we can manage the database files (MDF files) in SQL Server 2019.

Read More

Database Design Concepts with SQL Server Management Studio (SSMS) Part 1

This article is primarily written for beginners. Still, it covers some interesting and often forgotten database designing concepts that are equally attractive for SQL database professionals.

The current part focuses on the database designing concepts and their mapping to SQL Database tables, columns, and relationships. If you understand the backgrounds of databases and tools we are about to use, you will design your first SQL database with confidence.

Read More