SSMS Archives - {coding}Sight

How to Setup SQL Server on the Amazon RDS

Aveek Das — Tue, 27 Jul 2021 10:13:47 +0000

SQL Server is one of the most popular databases used in modern applications. Over the past few decades, it has established itself as a leading database provider that drives most of the applications in the Microsoft ecosystems. It provides unique features and easy integration with technologies. SQL Server was previously released as a Microsoft Windows …

The post How to Setup SQL Server on the Amazon RDS appeared first on {coding}Sight.

Understanding SQL DELETE Column from Table

Nisarg Upadhyay — Tue, 27 Apr 2021 12:28:49 +0000

Adding and removing columns are among the most common tasks when you manage tables in databases. And it might seem strange, but many users face issues. To learn or recall how to delete column in SQL correctly, they often have to refer to the guidelines and conduct additional searches for any specific scenario. That’s why …

The post Understanding SQL DELETE Column from Table appeared first on {coding}Sight.

How to Rename a Table Name in SQL Server

Nisarg Upadhyay — Thu, 25 Feb 2021 08:56:20 +0000

One of the most critical database administrator’s duties is managing database objects. For instance, the application logic changes, and DBAs may need to change the database object names. This task is crucial because we must ensure that renaming won’t break the application. I have recently been assigned a project where I had to rename a …

The post How to Rename a Table Name in SQL Server appeared first on {coding}Sight.

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

Nisarg Upadhyay — Fri, 29 Jan 2021 11:59:06 +0000

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 …

The post Connecting to SQL Azure from SQL Server Management Studio (SSMS) appeared first on {coding}Sight.

Basics of SQL Server Management Studio (SSMS). Part 2

Haroon Ashraf — Tue, 26 Jan 2021 14:23:26 +0000

This article further explains the basics of SQL Server Management Studio (SSMS) – one of the most widely used database development and administration tools. Also, it gives a conceptual understanding of some fundamental and essential options and components related to this tool. Part-1 Recap Before we proceed, we’d recommend referring to the first part of …

The post Basics of SQL Server Management Studio (SSMS). Part 2 appeared first on {coding}Sight.

Create a Database in SQL Server Using SQL Server Management Studio (SSMS)

Nisarg Upadhyay — Fri, 15 Jan 2021 14:50:59 +0000

This article briefly explains creating a new database with the New Database wizard of SQL Server Management Studio (SSMS). The SQL Server Management Studio is a graphical interface tool for creating, configuring, and administrating SQL Server engines and databases. You can download it from here. To create a database, connect to the SQL Server instance …

The post Create a Database in SQL Server Using SQL Server Management Studio (SSMS) appeared first on {coding}Sight.

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

Haroon Ashraf — Thu, 24 Dec 2020 11:27:48 +0000

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 …

The post Basics of SQL Server Management Studio (SSMS) – Part 1 appeared first on {coding}Sight.

Learn Database Design with SQL Server Management Studio (SSMS) – Part 2

Haroon Ashraf — Wed, 16 Dec 2020 20:18:10 +0000

It is the second part of the series focused on the SQL Server Management Studio usage. You will learn the database design core concepts and issues and get a walkthrough to design a simple SQL database with SSMS (SQL Server Management Studio). Prerequisites SQL Server 2016/2017/2019 Express/Developer edition is installed. The latest version of SSMS …

The post Learn Database Design with SQL Server Management Studio (SSMS) – Part 2 appeared first on {coding}Sight.

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

Haroon Ashraf — Mon, 07 Dec 2020 17:23:56 +0000

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 …

The post Database Design Concepts with SQL Server Management Studio (SSMS) Part 1 appeared first on {coding}Sight.

Seven Secrets in SSMS for Developers

Kenneth Igiri — Thu, 12 Nov 2020 14:47:37 +0000

SQL Server Management Studio is Microsoft’s primary client tool for interacting with SQL Server. It is simple, and it has been around for quite a while (launched with SQL Server 2005). Still, it is easy to miss plenty of great features that can make the T-SQL scripts execution and overall interaction with SQL Server more …

The post Seven Secrets in SSMS for Developers appeared first on {coding}Sight.