David Todd
Senior DBA
  • Papakura,
  • New Zealand
Member Since: 2002/01/14
Industry: Computer & IT
Top Skills:
Tech Certifications:
Ace
Connect on Live
Hire

Provide a quick, creative biography in 140 characters or less.

More bio
Activity
Points this month0
Total points2,580,301
Questions: 47
Solutions: 2111
Articles:
Videos:
Courses:
Posts:
Group Discussions: 23
Professional Background
Database Administrator
DTC Consultants
February 2012 – Present
Auckland, New Zealand

Status is: Independent contractor (GST registered) supporting remote clients

Services:
Business As Usual tasks - install, monitoring, users, refresh test from production

Performance tuning

Database development
Database Administrator
NZ Funds
April 2007 – November 2011
Auckland, New Zealand

Achievements:
Upgrade/Migration/Consolidation from SQL 7/SQL 2000/SQL 2005 to SQL 2008R2 - achieved significant performance increase and reduced licence cost.

Created Fund Performance database with Gross Price calculation

Created server disk utilisation monitoring and reporting

Reduced restore time on test servers using network restore and SQL compressed backup

Responsibilities:
Business as Usual tasks

Maintenance of ETL procedures
More
Education
Waiariki Polytechnic
Advanced Certificate in Business Computing
C/C++ Programming
1993 – 1993
More
Full Biography

SQL Server DBA
 
I've been in IT  and communcations for 20 years.

I've used MS SQL for 15 years.

Please take care!
Please take all due care with suggested queries and procedures. That is, test them on test systems first. Make sure that you have current backups of production and system databases.

System database backup
A tip for system database backups: When restarting SQL, take the opportunity to take an off-line copy of the system databases. If for some reason SQL wont start as a system database is corrupt, you'll have a file-copy to go back to. Of course you'll then want to restore a current SQL backup of the relevant database, but it will be a lot quicker than using rebuild, or the repair/recover feature of the installation setup.

Database Maintenance Routines
I've had a lot of success deploying Ola Hallengren's maintenance.sql script. It pretty much does everything - leaves several jobs behind for backups/integrity checks/index optimisation. Apart from changing 3 defaults and setting up the backup directory almost all thats left is to schedule the jobs and set email notifications on them. See https://ola.hallengren.com/

MS SQL
Genius   Mar 2009
Sage     Aug 2007
Wizard  Jun 2007
Guru      2006
Master   2005

SQL 2005
Sage     Jan 2009
Wizard  Jan 2008
Guru     Oct 2007
Master  Jun 2007

SQL 2008
Sage     Jul 2013
Wizard May 2012
Guru    Jan 2012
Master Aug 2010

SQL Syntax
Guru      Dec 2011
Master   Jan 2008

Database Misc
Guru    Apr 2013
Master Jan 2008

MS Access
Master Nov 2013

Windows Server 2008
Master Mar 2014

MySQL Server
Master May 2014

Windows 2003 Server
Master August 2014

More
Languages
English
Native or Bilingual Proficiency

Level Progress

Current: Level 35
David needs 11,699 points to level up.
LVL 36
  • Overall
    35
  • Microsoft SQL Server
    28
  • Microsoft SQL Server 2005
    21
  • Microsoft SQL Server 2008
    19
  • Query Syntax
    10
  • Databases
    9
  • Windows Server 2008
    5
  • Windows Server 2003
    5
  • Microsoft Access
    5
  • MySQL Server
    5
  • Microsoft Development
    4
  • .NET Programming
    4
  • Storage Software
    4
  • ASP.NET
    4
  • SSRS
    3
  • Microsoft Server OS
    3
  • DB Reporting Tools
    3
  • ASP
    3
  • Visual Basic.NET
    3
  • SSIS
    3
  • Microsoft Applications
    3
  • Microsoft SharePoint
    3
  • Oracle Database
    3
  • Microsoft IIS Web Server
    3
  • Microsoft Excel
    3
  • Microsoft Legacy OS
    2
  • Visual Basic Classic
    2
  • Server Hardware
    2
  • C#
    2
  • VB Script
    2
  • Storage
    2
  • Sybase Database
    2
  • Editors IDEs
    2
  • Microsoft Server Apps
    2
  • Outlook
    2
  • Windows OS
    2
  • SSAS
    2
  • SBS
    2
  • Windows XP
    2
  • Active Directory
    2
  • Crystal Reports
    2
  • Software-Other
    1
  • Web Applications
    1
  • Programming
    1
  • Storage Hardware
    1
  • Network Management
    1
  • Windows Networking
    1
  • VMware
    1
  • Scripting Languages
    1
  • Enterprise Software
    1
  • Microsoft Office
    1
  • Networking Protocols
    1
  • Virtualization
    1
  • Azure
    1
  • Microsoft Dynamics
    1
  • Exchange
    1
  • Programming Languages-Other
    1
  • Remote Access
    1
  • PHP
    1
  • Windows Server 2012
    1
  • GIS/GPS Programming
    1
  • Network Operations
    1
  • PostgreSQL
    1
  • Web Servers
    1
  • Windows 2000
    1
  • Components
    1
  • DB2
    1
  • ColdFusion Language
    1
  • Hardware
    1
  • Network Analysis
    1
  • Powershell
    1
  • Networking
    1
  • Disaster Recovery
    1
  • SSL / HTTPS
    1
  • Linux
    1
  • Security
    1
  • Installation
    1
  • IT Administration
    1
  • Server Software
    1
  • Windows Vista
    1
  • Microsoft Visio
    1
  • Routers
    1
  • .NET App Servers
    1
  • Acronis
    1
  • Anti-Virus Apps
    1
  • Big Data
    1
  • DHCP
    1
  • InfoPath
    1
  • JavaScript
    1
  • PayPal
    1
  • Programming Theory
    1
  • Unix OS
    1

Profile Validation

Email Verified
Expert Level Achieved
PayPal Connected