ssms Archives - {coding}Sight https://codingsight.com/tag/ssms/ Blog for SQL Server DBAs and Developers Thu, 27 Oct 2022 11:58:03 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png ssms Archives - {coding}Sight https://codingsight.com/tag/ssms/ 32 32 How to Setup SQL Server on the Amazon RDS https://codingsight.com/how-to-setup-sql-server-on-the-amazon-rds/ Tue, 27 Jul 2021 10:13:47 +0000 http://codingsight.com/?p=15587 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.

]]> Top-10 SQL Server Management Studio (SSMS) Add-ins You Should Use in 2021 https://codingsight.com/top-10-sql-server-management-studio-ssms-add-ins-you-should-use-in-2021/ Tue, 18 May 2021 11:28:15 +0000 http://codingsight.com/?p=13818 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 …

The post Top-10 SQL Server Management Studio (SSMS) Add-ins You Should Use in 2021 appeared first on {coding}Sight.

]]> Understanding SQL DELETE Column from Table https://codingsight.com/understanding-sql-delete-column-from-table/ Tue, 27 Apr 2021 12:28:49 +0000 http://codingsight.com/?p=13168 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.

]]> Connecting to SQL Azure from SQL Server Management Studio (SSMS) https://codingsight.com/connect-to-sql-azure-via-ssms/ Fri, 29 Jan 2021 11:59:06 +0000 http://codingsight.com/?p=11802 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 https://codingsight.com/basics-of-sql-server-management-studio-ssms/ Tue, 26 Jan 2021 14:23:26 +0000 https://codingsight.com/?p=11630 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) https://codingsight.com/create-sql-server-database-using-sql-server-management-studio-ssms/ Fri, 15 Jan 2021 14:50:59 +0000 https://codingsight.com/?p=11164 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 https://codingsight.com/sql-server-management-studio-ssms-basics/ Thu, 24 Dec 2020 11:27:48 +0000 https://codingsight.com/?p=11143 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.

]]> Manage MDF Files in SQL Server 2019 https://codingsight.com/manage-mdf-files-in-sql-server-2019/ Wed, 23 Dec 2020 14:07:48 +0000 https://codingsight.com/?p=11322 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 post Manage MDF Files in SQL Server 2019 appeared first on {coding}Sight.

]]> Learn Database Design with SQL Server Management Studio (SSMS) – Part 2 https://codingsight.com/learn-database-design-with-sql-server-management-studio/ Wed, 16 Dec 2020 20:18:10 +0000 https://codingsight.com/?p=11101 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 https://codingsight.com/database-design-concepts/ Mon, 07 Dec 2020 17:23:56 +0000 https://codingsight.com/?p=11013 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.

]]>