Blog

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.

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.

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.

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.

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.

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.

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.

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.

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?

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.

7 Steps to Setting Up Database Mail

As an alternative to SQL Mail, Microsoft suggest using Database Mail. They advise using Database Mail because SQL Mail will be removed in a future version of SQL Server, so using Database Mail in new development work should save you some future heartache.