{coding}Sight, Author at {coding}Sight https://codingsight.com/author/codingsight-2/ Blog for SQL Server DBAs and Developers Thu, 07 Dec 2023 12:48:27 +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 {coding}Sight, Author at {coding}Sight https://codingsight.com/author/codingsight-2/ 32 32 Best FREE SQL Server Tools for Database Developers and Administrators! https://codingsight.com/free-tools-for-mssql-database-developers-and-administrators/ https://codingsight.com/free-tools-for-mssql-database-developers-and-administrators/#comments Thu, 07 Dec 2023 12:48:20 +0000 http://codingsight.com/?p=84 This article has recently been extensively revised. In particular, we reworked the article structure, and navigation, and updated descriptions of the tools featured. We have also thoroughly checked all links to guarantee their active status and ensured that the information regarding all tools is current and accurate. The current material comprehensively lists the best SQL …

The post Best FREE SQL Server Tools for Database Developers and Administrators! appeared first on {coding}Sight.

]]> https://codingsight.com/free-tools-for-mssql-database-developers-and-administrators/feed/ 1 dbForge Edge: Your Best Universal Tool for Multidatabase Challenges https://codingsight.com/introducing-dbforge-edge/ Tue, 06 Jun 2023 11:34:26 +0000 https://codingsight.com/?p=24719 Handling several database management systems simultaneously is inevitable in working on multiple projects. At the same time, each system requires a proper set of relevant tools to perform database tasks. These tools should be powerful and flexible enough to adapt to the project’s evolving needs. One moment, your goal is to design a new database …

The post dbForge Edge: Your Best Universal Tool for Multidatabase Challenges appeared first on {coding}Sight.

]]> Introduction to ABP Framework – a Complete Web Platform for Software Development https://codingsight.com/introduction-to-abp-framework-a-complete-web-platform-for-software-development/ Wed, 17 Aug 2022 07:49:36 +0000 https://codingsight.com/?p=21739 ABP Framework is a complete infrastructure that helps developers build modern web applications according to the best practices of software development pre-applied. This product is an open-source project driven by the community. A high-level framework and a full ecosystem let you implement the Don’t Repeat Yourself (DRY) principle and focus on your business code. But …

The post Introduction to ABP Framework – a Complete Web Platform for Software Development appeared first on {coding}Sight.

]]> SQL JOINs Tutorial with Examples https://codingsight.com/sql-joins-tutorial-with-examples/ Tue, 19 Oct 2021 07:18:46 +0000 http://codingsight.com/?p=19184 In this article, we are going to takes a close look at SQL Server JOINs. We will review all supported SQL Server JOIN types with syntax, visual illustrations, and examples. As we all know, table data is the core of any SQL database. To use it effectively, database administrators need to extract records from several …

The post SQL JOINs Tutorial with Examples 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.

]]> DevOps Solutions for Database Development Automation https://codingsight.com/devops-solutions-for-database-development/ Thu, 21 Nov 2019 01:29:26 +0000 https://codingsight.com/?p=8229 What is DevOps? Database DevOps is a philosophy that comprises the following concepts: automating the development, deployment, documentation, testing, and monitoring processes between software developers and operations engineers integrating the development and operations processes to efficiently synchronize, validate, manage, and apply database changes The Database DevOps practice is focused on improving the efficiency of database …

The post DevOps Solutions for Database Development Automation appeared first on {coding}Sight.

]]> Create Indexed Views in SQL Server https://codingsight.com/create-indexed-views-in-sql-server/ Tue, 17 Sep 2019 23:38:59 +0000 https://codingsight.com/?p=7739 Introduction You would have already heard about views in databases. We create views for a number of reasons. One of the main reasons for using views is simplicity. Instead of writing complex queries again and again, you can just write a reusable view which fetches data from the underlying base tables. Another important reason for …

The post Create Indexed Views in SQL Server appeared first on {coding}Sight.

]]> 10 Best MySQL GUI Tools https://codingsight.com/10-best-mysql-gui-tools/ Tue, 10 Sep 2019 00:28:26 +0000 https://codingsight.com/?p=7723 MySQL is among most widely-used and popular database technologies, so quite a lot of tools have been created in order to make the processes of designing, creating, and administering databases easier and more convenient. However, with all of the possible options, it can be difficult to choose one tool that will fit your requirements best. …

The post 10 Best MySQL GUI Tools appeared first on {coding}Sight.

]]> How to Automate the Process of SQL Server Database Schema Synchronization https://codingsight.com/how-to-automate-the-process-of-sql-server-database-schema-synchronization/ Sun, 19 May 2019 23:04:33 +0000 https://codingsight.com/?p=6700 The goal Keeping two databases in sync is a task we often encounter when working on SQL database development and maintenance. One particular case is this – the versions of a database present on testing and development environments need to be consistently synchronized to make sure that tests are running on the most recent version. …

The post How to Automate the Process of SQL Server Database Schema Synchronization appeared first on {coding}Sight.

]]> Bulk Insert Data Files Into SQL Server https://codingsight.com/sql-server-bulk-insert-part-1-2/ Tue, 05 Feb 2019 16:57:01 +0000 https://codingsight.com/?p=6191 According to Wikipedia, the bulk insert is a process or method provided by a database management system to load multiple rows of data into a database table. If we adjust this explanation to the BULK INSERT statement, the bulk insert allows importing external data files into SQL Server. Assume that our organization has a CSV file of …

The post Bulk Insert Data Files Into SQL Server appeared first on {coding}Sight.

]]>