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 Attach Only a Database MDF

For databases with single log files, the sp_attach_single_file_db stored procedure will work to attach the DB file and create a...

SQL Server 2000 Health Check Script in CVS

For those of you unfortunate enough to still be running legacy applications from the cretaceous period, the below SQL 2000 Health...

How to Split a Database Across Multiple Files / Disks

There’s a lot that can be said about what the correct ways are to split up a database over multiple...

How to Manually Remove Log Shipping

Removing log shipping via SQL Management studio is as simple as un-selecting the log shipping check box under the database...

Script: Query Full Table Scans via the Search Cached Plans’ DMV

SQL Server Dynamic Management Views (DMVs) are a powerful feature set introduced with SQL 2005 that allows you to pull...

Identify Performance Bottlenecks with SQL 2005 and 2008 Perfmon Counters

Identifying SQL Server performance bottlenecks can be quite a complicated process. With so many counters required to assess where potential...

Uncover Missing Indexes with DMV

Dynamic Management Views are a great way to peak under the covers of SQL Server to see what’s going on...

How to Fix Orphaned Users on an SQL Server

Whenever a database is moved from one SQL Server to another, it’s only the database users which are carried across...

How to Find SQL Logins with NO Database Mappings

SQL Server is one of the most common attack surphases for would-be hackers, so it’s important to maintain a good...

How to Grant Read-Only Access to Activity Monitors

Give your clients the ability to view activity monitor, without handing over full sys-admin rights into your managed SQL server...

Be Mindful of Deprecated Features in SQL Servers

It’s important to always be mindful when moving databases between SQL version that implemented features have not been deprecated in...

Recompile All SQL Server Stored Procedures with this Script

Whenever updating statistics, introducing new indexes or removing old indexes, the following script offers a quick and simple way to...

Contact Us

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. We’re ready to boost your business’ productivity with proactive, scalable SQL Server database administration and support services. We typically respond within minutes.