Utilities & Extensions Archives - {coding}Sight https://codingsight.com/category/tools-technologies/utilities-extensions/ Blog for SQL Server DBAs and Developers Tue, 27 Jun 2023 04:23:41 +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 Utilities & Extensions Archives - {coding}Sight https://codingsight.com/category/tools-technologies/utilities-extensions/ 32 32 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.

]]> Backup and Restore MySQL Database Using mysqldump https://codingsight.com/backup-and-restore-mysql-database-using-mysqldump/ Wed, 17 Feb 2021 14:38:43 +0000 http://codingsight.com/?p=12073 The current article focuses on applying the mysqldump utility to backup and restore MySQL databases. This utility is the most common tool for generating backups in several formats or restoring MySQL databases. Note: On CodingSight you can also read about other MariaDB and MySQL backup strategies. For demonstration purposes, I created a demo database named …

The post Backup and Restore MySQL Database Using mysqldump appeared first on {coding}Sight.

]]> Using SQL Server Configuration Manager https://codingsight.com/using-sql-server-configuration-manager/ Mon, 30 Nov 2020 09:04:08 +0000 https://codingsight.com/?p=10923 Introduction SQL Server Configuration Manager is a part of SQL Server Suite, allowing us to configure the options external to the database engine, and options that control the aspects of SQL Server even when that SQL Server is down. The current article reviews some of these configurations. SQL Server Startup and Shutdown You can start/stop …

The post Using SQL Server Configuration Manager appeared first on {coding}Sight.

]]> Create a Database Diagram Using dbForge Database ER Diagram Tool for SQL Server https://codingsight.com/create-a-database-diagram-using-dbforge-database-er-diagram-tool-for-sql-server/ Mon, 09 Nov 2020 15:34:12 +0000 https://codingsight.com/?p=10303 SQL Server database diagram is a graphical representation of database tables. It visualizes the database structure and allows you to understand the overall database schema and relations. It lets you also manage the database schema from the diagram page by creating and modifying database tables, columns, dependencies, indexes, constraints, and keys. Using SQL Server Management …

The post Create a Database Diagram Using dbForge Database ER Diagram Tool for SQL Server appeared first on {coding}Sight.

]]> SQL Server Indexes Management Using Index Manager for SQL Server https://codingsight.com/sql-server-indexes-management-using-index-manager-for-sql-server/ Thu, 29 Oct 2020 16:01:38 +0000 https://codingsight.com/?p=10331 SQL Server Index Overview When talking about SQL Server performance tuning and queries enhancement, the first thing to consider is the SQL Server Index. It serves to accelerate reading data from underlying tables by providing quick access to the requested rows. Thus, it won’t need to scan all the table’s records. The SQL Server index …

The post SQL Server Indexes Management Using Index Manager for SQL Server appeared first on {coding}Sight.

]]> Configure Database Mirroring in SQL Server https://codingsight.com/configure-database-mirroring-in-sql-server/ Fri, 16 Oct 2020 08:37:04 +0000 https://codingsight.com/?p=10184 Database mirroring is a SQL Server high availability solution provided by Microsoft, with the following components. Principal database server: a source database that you configure for the mirroring.    Mirror database server: a destination database that you must restore with NORECOVERY. Ideally, a mirrored database should be on a separate server. Witness Server: an optional …

The post Configure Database Mirroring in SQL Server appeared first on {coding}Sight.

]]> Using SQL Server 2016 Upgrade Advisor https://codingsight.com/using-sql-server-2016-upgrade-advisor/ Thu, 20 Aug 2020 11:32:32 +0000 https://codingsight.com/?p=9784 INTRODUCTION SQL Server is designed to allow multiple databases on a single instance. With this model it is possible to have databases sitting on an instance which are not the same version as the instance itself. You can think of this as running the database in the “backward compatibility mode.” To break it down further, …

The post Using SQL Server 2016 Upgrade Advisor appeared first on {coding}Sight.

]]> Welcome Back the T-SQL Debugger with SQL Complete – SQL Debugger https://codingsight.com/welcome-back-the-t-sql-debugger-with-sql-complete/ Mon, 27 Jul 2020 09:47:35 +0000 https://codingsight.com/?p=9507 When you develop large chunks of T-SQL code with the help of the SQL Server Management Studio tool, it is essential to test the “Live” behavior of your code by making sure that each small piece of code works fine and being able to allocate any error message that may cause a failure within that …

The post Welcome Back the T-SQL Debugger with SQL Complete – SQL Debugger appeared first on {coding}Sight.

]]> Pivoting, Unpivoting, and Splitting Columns in Power BI Query Editor https://codingsight.com/pivoting-unpivoting-and-splitting-columns-in-power-bi-query-editor/ Tue, 07 Jul 2020 11:18:25 +0000 https://codingsight.com/?p=9345 For reference, Power BI is a data visualization and analytics software developed by Microsoft. Power BI can be used for static as well as interactive data visualization. Before you can create actual visualizations with Power BI, you can perform data preprocessing using Power BI Query editor. With query editor, you can perform various data transformation …

The post Pivoting, Unpivoting, and Splitting Columns in Power BI Query Editor appeared first on {coding}Sight.

]]> TeamCity Hosting Plugin https://codingsight.com/teamcity-hosting-plugin/ Sat, 08 Feb 2020 01:55:37 +0000 https://codingsight.com/?p=8514 This is the second part of the article related to the question of the TeamCity plugin implementation and hosting. If you haven’t seen the first article yet, feel free to check it out here. It uncovers the process of implementing a Jenkins plugin from scratch. To upload your plugin to the official TeamCity plugin marketplace …

The post TeamCity Hosting Plugin appeared first on {coding}Sight.

]]>