Skip to content

DBA News & Scripts

SQL server techniques, how-to's and other random ramblings

Like any digital tool or platform, the Microsoft SQL Server is constantly evolving to provide a better user experience. Don’t get left behind and fail to maximise the investment in your Microsoft SQL Server infrastructure. Read the latest DBA updates, scripts and tips here.

How to Find Longest Running Queries

The following DMV query returns the creation time, last execution time, physical and logical reads / writes, as well as...
Read More about How to Find Longest Running Queries

How to update DB File Growth Settings for ALL Databases at the same time

SQL Server’s default filegrowth settings grow a database in only 1MB increments. For larger databases this can lead to additional...
Read More about How to update DB File Growth Settings for ALL Databases at the same time

How to Find the Up-Time of a SQL Server Instance

Your DMV stats are only as good as the amount of data they’ve managed to collect since the last SQL...
Read More about How to Find the Up-Time of a SQL Server Instance

How to Fix Very Large MSDB Database

The MSDB database houses your maintenance plan information and job histories (amongst a few other things). For the most part...
Read More about How to Fix Very Large MSDB Database

How Healthy is your SQL Server?

Let’s not beat around the bush, SQL is complex. There are few “experts” out there that deal with the intricacies...
Read More about How Healthy is your SQL Server?

Surround Yourself with Smart People

Tips for Success from Successful People Love him or hate him, Robert Kiyosaki of “Rich Dad, Poor Dad” fame is...
Read More about Surround Yourself with Smart People

Reasons Given for NOT Hiring an External DBA − And Why You Should Reconsider

Hiring someone to look after your business critical data can be a scary prospect. Maybe you’ve managed to get this...
Read More about Reasons Given for NOT Hiring an External DBA − And Why You Should Reconsider

When’s the Last Time you Serviced your SQL Servers?

When was the last time you looked under the bonnet of your SQL Server? We often have this image in...
Read More about When’s the Last Time you Serviced your SQL Servers?

Gettin’ Techie SET STATISTICS TIME

Today we’re going to be getting down and dirty with some good, old-fashioned techno-babble. I’m going to be discussing the...
Read More about Gettin’ Techie SET STATISTICS TIME

Contact Us Today!

Ready to benefit from a faster, more responsive SQL Server? Do you have further enquiries about our flexible support plans? Whatever the need, don’t hesitate to contact DBA Services. 

"*" indicates required fields

Proudly Australian Owned and Operated!

Our team of SQL Server specialists reside entirely within Australia. We’re standing by and ready to boost your business’ productivity with proactive, scalable SQL Server database administration and support services. Contac us today - we typically respond within minutes!