Nisarg Upadhyay, Author at {coding}Sight https://codingsight.com/author/nisarg-upadhyay/ Blog for SQL Server DBAs and Developers Wed, 13 Mar 2024 12:10: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 Nisarg Upadhyay, Author at {coding}Sight https://codingsight.com/author/nisarg-upadhyay/ 32 32 Identifying Cost-Saving Opportunities in Azure DevOps https://codingsight.com/identifying-cost-saving-opportunities-in-azure-devops/ Wed, 13 Sep 2023 16:23:53 +0000 https://codingsight.com/?p=25526 This article explores various methods that can be used to reduce costs while using Azure DevOps. When you deploy an application on the cloud, resource utilization and monitoring become key factors. The performance of a database or an application relies on how the application is configured and hosted, and the cost of maintaining and running …

The post Identifying Cost-Saving Opportunities in Azure DevOps appeared first on {coding}Sight.

]]> The Tutorial Guide to SQL Server DROP TABLE Statement https://codingsight.com/sql-drop-index-drop-table-and-drop-database-statements-explained-with-examples/ Thu, 22 Sep 2022 07:24:00 +0000 http://codingsight.com/?p=14264 The SQL DROP statement is a command that deletes existing database components or the entire databases with all their data permanently. There are other SQL commands with a similar effect (TRUNCATE or DELETE), but the specificity of the DROP command is that it deletes everything at once. For instance, DROP TABLE removes the table data, …

The post The Tutorial Guide to SQL Server DROP TABLE Statement appeared first on {coding}Sight.

]]> How to Change Default MySQL Port in Windows 10 https://codingsight.com/how-to-change-default-mysql-port-in-windows-10/ Sun, 18 Sep 2022 17:20:00 +0000 http://codingsight.com/?p=16885 A network port is a communication endpoint used by applications, incoming connections, and external devices to the computer/server or specific application. In this article, we’ll discuss MySQL ports and learn how we can change the default port on Windows 10. Table of contents Every RDBMS has its default port to accept incoming connections. The below …

The post How to Change Default MySQL Port in Windows 10 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.

]]> Automation of Database Maintenance in SQL Server 2019 Express Edition https://codingsight.com/automation-of-database-maintenance-in-sql-server-2019-express-edition/ Fri, 18 Mar 2022 16:57:49 +0000 http://codingsight.com/?p=19286 This article explains how to automate the database maintenance tasks in SQL Server Express Edition. In terms of automation of database maintenance schedules, the SQL Server Express Edition has the following limits: The SQL Server Agent is not supported, so we cannot automate the database maintenance tasks using SQL Server. The SQL Server database mail …

The post Automation of Database Maintenance in SQL Server 2019 Express Edition appeared first on {coding}Sight.

]]> Drop Temp Table in SQL Server and PostgreSQL https://codingsight.com/drop-temp-table-in-sql-server-and-postgresql/ Fri, 08 Oct 2021 09:01:28 +0000 http://codingsight.com/?p=19067 This article explains different ways to drop the temp table in SQL Server and PostgreSQL. As the name suggests, temporary tables are used to store the data temporarily. It can be used to process the data without accessing the actual table. We can create indexes, statistics, and constraints on the temp tables. Temporary Tables in …

The post Drop Temp Table in SQL Server and PostgreSQL appeared first on {coding}Sight.

]]> Reset the Root Password of MySQL on Windows https://codingsight.com/reset-root-password-of-mysql-on-windows/ Tue, 31 Aug 2021 10:20:21 +0000 http://codingsight.com/?p=16332 When we install MySQL on Windows, we usually specify the password of the root user. This helps keep the MySQL Server secured. Suppose you joined a new organization, and the management of that organization plan to migrate some MySQL databases to SQL Server. To perform this, you need the credential of the root user, but …

The post Reset the Root Password of MySQL on Windows appeared first on {coding}Sight.

]]> MySQL SHOW USERS: How to List All Users in a MySQL https://codingsight.com/mysql-show-users-different-ways-to-populate-the-users-of-mysql/ Wed, 25 Aug 2021 08:44:18 +0000 http://codingsight.com/?p=16238 This article explains different methods to populate the details of the Users in MySQL. We can view the list of users by using any of the following methods. Environment Setup For demonstration, I have installed MySQL Server 8.0 on Windows 10 and created a user named NisargU. Run the below query to create a user. …

The post MySQL SHOW USERS: How to List All Users in a MySQL appeared first on {coding}Sight.

]]> How to SHOW or LIST Tables in MySQL https://codingsight.com/different-ways-to-view-tables-in-mysql-server/ Mon, 26 Jul 2021 08:54:23 +0000 http://codingsight.com/?p=15772 There are two primary methods to view the tables in MySQL: In this article, we are going to explore them both. MySQL SHOW TABLES Command The show tables command displays the list of all tables created in a database. The syntax is as follows: In the syntax, Let us see the examples. Example 1: Show …

The post How to SHOW or LIST Tables in MySQL appeared first on {coding}Sight.

]]> SQL Server RAISERROR Statement with Simple Examples https://codingsight.com/sql-raiserror-statement-with-simple-examples/ Wed, 14 Jul 2021 13:11:08 +0000 http://codingsight.com/?p=15299 The SQL RAISERROR statement is used to send a custom message to the client application. It also can be used to debug the application and applies to the error handling mechanism. SQL RAISERROR Statement Syntax and Parameters The syntax of the SQL RAISERROR statement is the following: Below you can see the explanation of the …

The post SQL Server RAISERROR Statement with Simple Examples appeared first on {coding}Sight.

]]>