Code Management Archives - {coding}Sight https://codingsight.com/category/tools-technologies/code-management/ Blog for SQL Server DBAs and Developers Mon, 31 Jul 2023 07:59:30 +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 Code Management Archives - {coding}Sight https://codingsight.com/category/tools-technologies/code-management/ 32 32 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.

]]> Oracle Live SQL: Pros and Cons, and What You Miss Out if You Don’t Try It https://codingsight.com/oracle-live-sql-overview-features-pros-and-cons/ Thu, 15 Jul 2021 11:27:56 +0000 http://codingsight.com/?p=15115 Oracle Live SQL is a new feature in Oracle Database 12c that allows the developers to easily create and run SQL scripts against Oracle databases. It is suitable for quick code demos, debugging, and troubleshooting. In general, it is an easier way for those who are teaching or demonstrating SQL, PL/SQL, or another function to …

The post Oracle Live SQL: Pros and Cons, and What You Miss Out if You Don’t Try It appeared first on {coding}Sight.

]]> Create an Upload & Download Application with Oracle Application Express (APEX) and Autonomous Database https://codingsight.com/create-an-upload-download-application-with-oracle-apex/ Thu, 24 Jun 2021 09:30:25 +0000 http://codingsight.com/?p=14812 Oracle APEX (Oracle Application Express) is a web-based software development system that runs on an Oracle Database. It comes as standard with all Oracle Database editions and Oracle Autonomous Database service and, naturally, is fully supported. In other words, Oracle APEX is a low-code development platform for building scalable and secure enterprise apps that solve …

The post Create an Upload & Download Application with Oracle Application Express (APEX) and Autonomous Database appeared first on {coding}Sight.

]]> What is SQL Server Express? Definition, Benefits and Capabilities https://codingsight.com/sql-server-express-edition-definition-benefits-limitations/ Wed, 28 Apr 2021 07:55:58 +0000 http://codingsight.com/?p=13183 SQL Server Express is a free lightweight edition of SQL Server with limited functionality, available for all versions starting from SQL Server 2005.  You can use it for small data-driven applications and independent application vendors. The Express edition restrictions are the following: Maximum relational database size: 10 GB Maximum compute capacity for SQL Server instance: …

The post What is SQL Server Express? Definition, Benefits and Capabilities appeared first on {coding}Sight.

]]> How to Download and Install SQL Server Express Edition? https://codingsight.com/installing-and-configuring-sql-server-express-edition/ Fri, 26 Mar 2021 11:25:01 +0000 http://codingsight.com/?p=12614 SQL Server is Microsoft’s premier database management system that we can use to develop relational databases. It also offers support for graph databases. Depending on the services offered, SQL Server comes in various editions, such as Enterprise, Standard, Personal, Developer, Express, etc. In this article, we’ll deal with the SQL Server Express Edition, a free …

The post How to Download and Install SQL Server Express Edition? appeared first on {coding}Sight.

]]> Microsoft SQL Server Express Edition Limitations and Versions https://codingsight.com/sql-server-express-limitations-and-use-cases/ Fri, 05 Feb 2021 12:36:33 +0000 http://codingsight.com/?p=11931 What is SQL Server Express? SQL Server Express Edition is a free edition of SQL Server. Microsoft provides it for educational purposes as well as minor use cases. Students, hobbyists, and startups can use this edition to implement projects that do not require advanced features of SQL Server. This article will examine the functionality of …

The post Microsoft SQL Server Express Edition Limitations and Versions appeared first on {coding}Sight.

]]> Configure SQL Jobs in SQL Server using T-SQL https://codingsight.com/configure-sql-jobs-in-sql-server-using-t-sql/ Mon, 19 Oct 2020 08:44:24 +0000 https://codingsight.com/?p=10179 SQL Server Agent is a component used for the database tasks automation. For instance, we need to perform Index maintenance on Production servers during the non-business hours only. So, we create a SQL Server job of running index maintenance and schedule it for “off” hours. When we install SQL Server, the SQL Server Agent service …

The post Configure SQL Jobs in SQL Server using T-SQL appeared first on {coding}Sight.

]]> How to Make Use of SQL Server Graph Database Features https://codingsight.com/how-to-make-use-of-sql-server-graph-database-features/ Fri, 04 Sep 2020 12:29:57 +0000 https://codingsight.com/?p=9783 Would SQL Server graph database features fit your next project? While you may not know the definitive answer right now, you might be wondering, “What problems does it solve?”. In broad terms, this post tackles the issues of what a graph database is, what its uses are, and what benefits you and your stakeholders can …

The post How to Make Use of SQL Server Graph Database Features appeared first on {coding}Sight.

]]> Best SQL Tools for Database Developers and Administrators https://codingsight.com/best-sql-tools-for-database-developers-and-administrators/ Fri, 08 May 2020 14:53:20 +0000 https://codingsight.com/?p=8691 For a SQL database developer, it is essential to have the necessary SQL tools in hand, which enable to reduce the development time of given functionality. The same is true for the tester. For a database administrator, it is also important to have monitoring tools. In this article, we are going to look at some …

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

]]> Analytic Functions in SQL Server https://codingsight.com/analytic-functions-in-sql-server/ Sun, 20 Oct 2019 23:10:39 +0000 https://codingsight.com/?p=8009 Aggregate and Analytic functions in SQL Server operate on a set of rows. However, unlike such aggregate functions as sum, count and average that return scalar values, analytic functions return a group of rows that can be further analyzed. In this article, we will see some of the most commonly used analytic functions in SQL …

The post Analytic Functions in SQL Server appeared first on {coding}Sight.

]]>