David Todd
Senior Database Administrator
  • Papakura,
  • New Zealand
Member Since: 2002/01/14
Industry: Computer & IT
Top Skills:
Tech Certifications:

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

More bio
Activity
Points this month0
Total points2,609,301
Questions: 47
Solutions: 2119
Articles:
Videos:
Courses:
Posts:
Group Discussions: 23
Professional Background
Senior Database Administrator
was DTC Consultants now DGTodd Consulting Limited
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 36
David needs 128,699 points to level up.
LVL 37
  • Overall
    36
  • Microsoft SQL Server
    28
  • Microsoft SQL Server 2005
    21
  • Microsoft SQL Server 2008
    19
  • Query Syntax
    11
  • 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
    4
  • Microsoft Server OS
    3
  • ASP
    3
  • Microsoft Applications
    3
  • DB Reporting Tools
    3
  • Oracle Database
    3
  • Visual Basic.NET
    3
  • SSIS
    3
  • Microsoft SharePoint
    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
  • SQL
    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
    1
  • Web Applications
    1
  • Programming
    1
  • Storage Hardware
    1
  • Components
    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
  • DB2
    1
  • ColdFusion Language
    1
  • Hardware
    1
  • Network Analysis
    1
  • Powershell
    1
  • Networking
    1
  • Disaster Recovery
    1
  • SSL / HTTPS
    1
  • Business Management
    1
  • Linux
    1
  • Security
    1
  • Installation
    1
  • Web Development
    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