SQL Server techniques, how-tos and other random ramblings

Why Is SQL Server So Slow?

It’s the perennial question: Why is my SQL server so slow? What was once a finely tuned system has become sluggish and unresponsive. Something has changed and now the server is struggling. But what is the cause? How can we find out where the hold-up is to even start working on a solution? Thankfully, SQL…

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 parts as the international space station (or thereabouts), it might seem impossible for an outsider to understand what’s important and what’s chaff. So, if you’re implementing an SQL server project and you don’t have vast…

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 auditing capabilities that were once a very neglected feature. This article steps you through setting up both a server level audit, as well as a table auditing on specific events such as selects, updates and…

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 dynamic work forces and increases in available contract resources, outsourcing has become mainstream. Not only can your business save money, it can now gain access to technical experts previously outside the financial reach of most…

How to Attach a Database MDF Only

For databases with single log files, the sp_attach_single_file_db stored procedure will work to attach the DB file and create a new single log file. The syntax is as follows: sp_attach_single_file_db [ @dbname= ] ‘dbname’, [ @physname= ] ‘physical_name’ Where there are multiple log file, the above stored proc won’t work. You can still attach this…

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 Check script might help to sooth that itch a little… [crayon-5c46e0de8ae3e903346257/]

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 disks, and on a windows system the advantages are fairly self evident when you consider that Windows only allows four (4) concurrent read / write operations per LUN. This article isn’t going to cover the…

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 properties, however every now and again somebody restores a database over a DB that was configured for log shipping, consequently breaking everything and now requires a little manual intervention in order to get things cleaned…

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 back the curtain on SQL Server and easily review some of the inner workings of your database server (such as performance issues etc) without first having to collect a full SQL trace then interrogating that…

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 bottlenecks exist – both within SQL Server, it’s databases and the underlying operating system, disk subsystem etc. Below we’ve listed just a handful of SQL Server Perfmon counters which you can use to assess some…

DMV Missing Index Report

Dynamic Management Views are a great way to peak under the covers of SQL Server to see what’s going on without having to run a full profiler trace and parse that through SQL tuning advisor. While the following is also available as a Performance Dashboard report, sometimes it’s handy to have the actual DMV query…

How to Fix Orphaned Users (SQL Server)

Whenever a database is moved from one SQL Server to another, it’s only the database users which are carried across (so no logins are transferred as part of this). For Windows logins, the fix is simply a matter of re-creating that login on the new server, however SQL logins – which have their own unique…

Contact DBA Services

We typically respond within minutes.

Contact Us

Professional SQL Server Database Administration Services, because we believe every business deserves to have a specialist DBA.

QAssure # 16602. GITC #Q-6452

Office Location
2/67 Dennis Rd,
Springwood QLD,
Australia 4127

Postal Address
PO Box 1208,
Fortitude Valley,
QLD Australia 4006

  • g-pluse
  • linkedin
  • facebook
  • twitter