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.

10 Things Every Project Manager Must Know When Deploying a SQL Server

As someone who lives and breathes SQL servers, let me tell you they are complicated beasts. With as many moving...

How to Configure SQL Server Auditing

With the GDPR requirements rattling quite a few trees in the industry, there's been a renewed interest in SQL Server's...

How Outsourcing is Changing the Way You Do Business

Outsourcing, it almost used to be a dirty word, evoking images of offshore call centers. Thanks to the rise of...

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...

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.