In this article, we are going to learn about xp_fileexist, its usage, and alternatives. To access the file system using SQL Server queries, we can use the following extended stored procedures.
Read more »
Nisarg Upadhyay
Nisarg Upadhyay is a SQL Server Database Administrator and Microsoft certified professional who has more than 8 years of experience with SQL Server administration and 2 years with Oracle 10g database administration.
He has expertise in database design, performance tuning, backup and recovery, HA and DR setup, database migrations and upgrades. He has completed the B.Tech from Ganpat University. He can be reached on nisargupadhyay87@outlook.com
He has expertise in database design, performance tuning, backup and recovery, HA and DR setup, database migrations and upgrades. He has completed the B.Tech from Ganpat University. He can be reached on nisargupadhyay87@outlook.com
Latest posts by Nisarg Upadhyay (see all)
- Understanding xp_fileexist and its usage - July 9, 2021
- An overview of the sp_helptext statement - June 28, 2021
- ALTER DATABASE SET SINGLE_USER statement in SQL Server - June 7, 2021
An overview of the sp_helptext statement
June 28, 2021In this article, we are learning about the sp_helptext statement. I am going to show the various examples of the usage of it. I will also explain the two alternatives of the sp_helptext statement.
Read more »
ALTER DATABASE SET SINGLE_USER statement in SQL Server
June 7, 2021In this article, we are going to explore the purpose of the ALTER DATABASE SET SINGLE_USER statement. The ALTER DATABASE SET SINGLE_USER is used to put the database in single-user mode. When any database is in single-user mode, the new user cannot connect to the database. However, the users that are already connected to the database do not get disconnected.
Read more »
Different ways to change database owners in SQL Server
May 17, 2021In this article, we will explore different ways in SQL Server to change the database owner. We can use any of the following methods in SQL Server to change the database owner.
Read more »
Resolving SQL Server errors: The Primary Filegroup is full
May 6, 2021In this article, we are going to understand SQL Server error: The Primary filegroup is full and how we can fix this error.
Read more »
Different ways to check SQL Server uptime
April 26, 2021In this article, we are going to explore different ways to check the SQL Server uptime. We can determine SQL Server uptime by using any of the following methods:
Read more »
Automate consistency checks of SQL database using Windows Task Scheduler
April 20, 2021The SQL database integrity check is one of the most crucial and important tasks of the database administrator. The database integrity task checks the structural integrity and allocation of all database objects and indexes. The integrity checks can be performed by using the DBCC CheckDB command. The CheckDB command is used to identify the corruption in the database. The command performs the following operations on the database.
Read more »
Automate SQL database backups using Windows Task Scheduler
April 15, 2021In this article, we will learn how we can automate the backup of SQL database created in SQL Server Express edition. SQL Server Express edition is a lightweight database that has limited functionalities and resource allocation. The SQL Server Express edition does not support SQL Server Agent jobs, so it is tricky to automate various database administration tasks.
Read more »
Automate rebuilding SQL Database indexes using Maintenance Plans
April 9, 2021Index maintenance is a vital part of a database administrator’s job. I have worked for few clients who often face performance issues in SQL Database and don’t have a dedicated DBA. I remember that one of our clients was facing performance issues. I logged in to their server and found that they did not set up any index maintenance jobs; therefore, many indexes were fragmented, causing the problem.
Read more »
Learn MySQL: Install MySQL server 8.0.19 using a noinstall Zip archive
April 6, 2021In this article, I am going to explain the step-by-step installation process of MySQL server 8.0.19 using a noinstall Zip archive. In my previous article, I have explained the step-by-step installation process of MySQL 8.0 on windows 10.
Read more »
Move SQL databases to a different mount point: Granting permissions and moving System and User databases
March 26, 2021This is the 2nd article of Move SQL databases to a different mount point series. In the previous article, Create a new mount point in Linux, I have explained how we can create a mount point in Ubuntu Linux. In this article, I am going to cover the following topics:
Read more »
Move SQL databases to a different mount point: Create a new mount point in Linux
March 26, 2021This article is the 1st article of the Move SQL Database to different mount point series. This article focuses on creating a new partition using the fdisk command and formatting it with an ext4 file system using the mkfs command.
Read more »
Learn MySQL: Control Flow functions
March 19, 2021In this article, we are going to learn about the most common control flow functions. The control flow function evaluates the condition specified in it. The output generated by them can be a true, false, static value or column expression. We can use the control flow functions in the SELECT, WHERE, ORDER BY, and GROUP BY clause. Following are the most common functions:
Read more »
Learn MySQL: MySQL String Functions
March 17, 2021In this article, we are going to learn about different MySQL String functions. The MySQL String functions can be categorized into the following:
Read more »
Learn MySQL: Run multiple instances of MySQL Server on Windows 10
March 11, 2021This article explains how we can run multiple instances of the MySQL Server on a single machine. In How to install MySQL database server 8.0.19 on Windows 10 article, I have explained the installation process of MySQL on windows 10. For the demonstration, I have installed MySQL 8.0.19 on my workstation. We can view the status of the MySQL Server using MySQL workbench. To view the server status, open MySQL workbench connect to the MySQL instance Click on Server Select Server Status.
Read more »
Learn MySQL: An overview of the mysqlbinlog utility
March 2, 2021The mysqlbinlog utility is used to process the binary logs of the MySQL server. Using mysqlbinlog utility, we can perform the following tasks:
Read more »
Move SQL database files in SQL Server 2019 on Linux
February 26, 2021In this article, I am going to explain how we can move the SQL database files to another location in Ubuntu 18.04. For the demonstration, I have installed Ubuntu 18.04, SQL Server 2019 on Linux on my workstation. You can read SQL Server 2019 on Linux with Ubuntu to understand the step-by-step installation process of the SQL Server 2019 on Linux. We will move database files of AdventureWorks2019 and Wideworldimportors database. To move the databases, we can use any of the following methods:
Read more »
Automate SQL database backups using Maintenance Plans
February 12, 2021In this article, we are going to learn how we can automate the backup of the SQL database using database maintenance plans. Data is one of the most important assets of any organization, and as a database administrator, it is our prime responsibility to protect it. There are various tools available that can be used to back up the data. These tools use state of the art technology to protect the data, and some of them are very costly. Instead of using these costly tools, some organizations prefer to use SQL native backups. These backups of SQL database can be automated by SQL Server Agent Jobs or Windows’ task scheduler.
Read more »
Learn MySQL: An overview of MySQL Binary Logs
February 9, 2021In this article, we are going to learn about the concept of MySQL Binary Logs and their architecture. I am covering the following details in this article.
- An overview of MySQL binary logs and their architecture
- How to enable and disable binary logging
- View and change the location of the binary logs
Learn MySQL: The Basics of MySQL Views
February 3, 2021In this article, we are going to learn about the fundamentals of MySQL Views. In this article, I am going to cover the following topics:
Read more »
Learn MySQL: The Basics of MySQL Stored Procedures
January 8, 2021In this article, we are going to learn about the stored procedures in MySQL. In this article, I am covering the basics of the stored procedure that includes the following
Read more »
T-SQL scripts to update statistics based on the row modification
December 24, 2020In this article, we are going to learn how we can develop a T-SQL script to update statistics of tables based on the row modification. It is always a challenging task to perform maintenance on a table that has billions of rows. During the early years of my professional career, I was assigned a project and one of our clients had performance issues. The initial analysis showed that due to frequent data modifications, a specific table’s statistics become outdated.
Read more »
Identify unused SQL databases
December 8, 2020In this article, I am going to show how we can identify unused SQL databases. In our organization, after release deployment, we receive the database refresh requests. To refresh the database, we were instructed to perform the following tasks:
Read more »
Configure an iSCSI initiator in Ubuntu 18.04
November 26, 2020In this article, I am going to explain how we can configure iSCSI initiator and iSCSI target server on ubuntu 18.04. In my previous article, we have learned the step by step configuration process of configuring the iSCSI target and initiator in Windows Server 2016. The following are the links to these articles:
Read more »
T-SQL scripts to identify unused database files
October 30, 2020In this article, I am going to show how we can automate the report of unused database files using T-SQL.
Read more »