Tools & technologies Archives - {coding}Sight https://codingsight.com/category/tools-technologies/ 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 Tools & technologies Archives - {coding}Sight https://codingsight.com/category/tools-technologies/ 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.

]]> How to Connect MySQL Workbench to MariaDB https://codingsight.com/how-to-connect-mysql-workbench-to-mariadb-html/ Mon, 31 Oct 2022 05:53:04 +0000 https://codingsight.com/?p=23322 To use MySQL Workbench as a GUI for MariaDB? If you’re filled with disbelief right now, you’re not alone. Though Michael “Monty” Widenius “fathered” both MySQL and MariaDB, they’re getting more differences in each iteration, which also affects MySQL Workbench as a GUI tool for MariaDB. This article will tackle compatibility between the two so …

The post How to Connect MySQL Workbench to MariaDB appeared first on {coding}Sight.

]]> PgAdmin GUI client for PostgreSQL: Comprehensive Overview https://codingsight.com/an-overview-of-pgadmin-tool-for-postgres/ Sat, 20 Aug 2022 07:57:00 +0000 http://codingsight.com/?p=16283 The PgAdmin is a popular tool for the open-source database – Postgres or PostgreSQL. It provides various graphical user interfaces for managing the Postgres relational database. It simplifies database management activities such as database creation, maintenance, database objects export\import, query tool, backup\restores, managing cluster objects. PgAdmin Features How to Download PgAdmin Tool The current PgAdmin …

The post PgAdmin GUI client for PostgreSQL: Comprehensive Overview appeared first on {coding}Sight.

]]> Install and Configure XAMPP Software on Windows Server 2019 https://codingsight.com/how-to-install-and-configure-xampp-software-on-windows-server-2019/ Tue, 09 Aug 2022 10:56:00 +0000 http://codingsight.com/?p=15906 XAMPP is a cross-platform web server used to develop and test programs and web applications, created by the Apache friends organization.  It is open-source software, so its code can be modified or revised by the audience. The XAMPP is supported by various platforms like Windows, Linux, and macOS. Table of contents What is XAMPP? In …

The post Install and Configure XAMPP Software on Windows Server 2019 appeared first on {coding}Sight.

]]> What is AWS Athena? https://codingsight.com/amazon-athena-overview/ Tue, 02 Aug 2022 11:58:00 +0000 http://codingsight.com/?p=15893 AWS Athena is a fully managed, popular cloud service provided by Amazon to query structured data in S3. It allows users to write custom SQL queries to retrieve data from CSV or other file formats in S3. This is helpful if you want to query your static data at rest. Being a pioneer in the …

The post What is AWS Athena? appeared first on {coding}Sight.

]]> The Importance of SQL Server Data Tools (SSDT) https://codingsight.com/sql-server-data-tools-ssdt/ Mon, 13 Sep 2021 05:56:50 +0000 http://codingsight.com/?p=16993 Any SQL Server DBA, Developer, or end-user always needs a client tool to connect to SQL Server and access its features. In this article, we will go through various Client Tools offered by SQL Server itself and learn about SQL Server Data Tools and its hidden potentials to make the lives of DBAs and Developers …

The post The Importance of SQL Server Data Tools (SSDT) appeared first on {coding}Sight.

]]> Introduction to Amazon QuickSight https://codingsight.com/introduction-to-amazon-quicksight/ Wed, 28 Jul 2021 08:31:39 +0000 http://codingsight.com/?p=15673 Nowadays, companies are moving their infrastructure from on-premise devices to the cloud. There are a few major cloud vendors like AWS, Azure, and GCP that dominate the market shares. When applications are deployed to the cloud, more and more data is generated daily. However, the humongous amount of data generated each minute has no value …

The post Introduction to Amazon QuickSight appeared first on {coding}Sight.

]]> 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.

]]> Oracle Data Integrator: A Tutorial Guide to Get Google’s Financial Service Data https://codingsight.com/query-googles-financial-service-using-oracle-data-integrator/ Thu, 22 Jul 2021 08:57:54 +0000 http://codingsight.com/?p=15482 RESTful API is a popular protocol for exchanging data between different applications and systems especially in Web applications. Most programming languages support calling RESTful API(s) to query data quickly. Oracle Data Integrator supports RESTful services for reading and writing data. In this tutorial, we are using Oracle Data Integrator to query data from Google Financial …

The post Oracle Data Integrator: A Tutorial Guide to Get Google’s Financial Service Data appeared first on {coding}Sight.

]]>