Tags » Dba

DBA Mock Draft Year 3

It’s complete. Backyard Football League has ended, and although it may have been a little hectic, in the end, it ended like every game should, with a boy who rose. 177 more words


#0373 - SQL Server - Interview Questions - Parameters required for server-side paging mechanisms

For a mid-level SQL developer profile, this is one of my favourite interview questions if their current projects involve some sort of paging mechanism while displaying results on a grid. 332 more words


Updated DBA 3.0 FAQ Available

The team working on the the DBA Frequently Asked Question file have just released an updated version.

This latest version aims to clarify common questions that have been submitted since the last update and that have come up in a number of games. 12 more words


Warclouds 2016 - DBA Report

Each February the Warclouds Convention is held in Christchurch. As is now regular, a 15mm DBA competition forms part of this larger convention. The format for DBA is six rounds, each of one hour, over one day. 747 more words


Transaction Tracking Continued

In my last blog, I wrote about the use of fn_dblog that helped us in querying the log to find the exact information with respect to a transaction that we needed to track down. 1,396 more words


Back on the Wagon at Warclouds

Well after what feels like an eternity I finally got some wargaming done today at one of the local major competitions Warclouds Over Woolston.  It has been a fairly hectic few weeks with a family beach holiday, travel for work, and also moving into a new role at work – so wargaming has been on the back burner.   978 more words

Battle Report

Monitoring CPU usage for a SQL Server

In this blog post, I would like to list down the metrics that can be used to indicate an issue with over-usage of CPU on a server where SQL Server is installed. 53 more words