Blog

7 min read

How to Rename a Database and its Logical and Physical Files

In this blog, we will explore the required steps to query the existing logical and physical file name, rename a database, rename the logical file names, and rename the physical file names.

7 min read

How to Restore Your Backups from Striped Backup Files

In this blog, we will look into how we can generate the TSQL restore scripts automatically and then execute them to perform the restores.

7 min read

DBA Toolbox – Creating Your Own DBA Utilities Database

As a DBA, you can develop your own toolbox and be a master in the craft of administering and managing databases.

7 min read

How to Stripe Your Backups into Multiple Files

In this blog, we will explore the option to stripe the backup files into four by first running the database backups using one file.

5 min read

Checking the SQL Server Agent Status

In this blog, we will explore and share with you how to quick stop, start, and run a script to check the SQL Server Agent status.

3 min read

Comparing DBaaS Options from Amazon and Microsoft

We compare Amazon RDS & Microsoft Azure SQL Databases. Cloud-based computing holds promise for businesses that no longer need to own and maintain fixed-hardware assets.

5 min read

Querying the SQL Server Instance and OS Level Details

If you need to query more than 100+ SQL Server instances, you will need to register all the instances into a group and run a multi-server query.

5 min read

How to Automate the Database Restore Process

This blog will explore on how we can automate the database restore process by generating the required TSQL statements. Read on to learn more.

7 min read

Scripting Out SQL Server Logins, Server Role Assignments, and Server Permissions

This blog reviews how you can generate scripts for SQL server logins, role assignments, and server permissions for a smooth migration.

5 min read

Querying Database File Properties

You may wish to increase the file autogrowth size if they are set at rather small increments or set to increase by a percentage. You can right-click on the database and select “Properties” in the pop-up menu,then click on the “Files” page.

3 min read

Querying the Drive Space Utilization

How can you query the disk drives space utilization to show all the drives, total capacity, free space, and percentage free for the drives that contain the SQL Server databases data and log files?

4 min read

3 Slick Scripts for Database Mail Alerts and Reports

Database Mail enables you to send e-mail messages from the SQL Server Database Engine. Database Mail uses the standard Simple Mail Transfer Protocol (SMTP) to send mail.