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 month350
Total points2,749,926
Questions: 47
Solutions: 2159
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 25 years.

I've used MS SQL for 20 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 37
David needs 138,074 points to level up.
LVL 38
  • Overall
    37
  • Microsoft SQL Server
    29
  • Microsoft SQL Server 2005
    21
  • Microsoft SQL Server 2008
    19
  • Query Syntax
    12
  • Databases
    10
  • SQL
    7
  • Windows Server 2008
    5
  • Microsoft Access
    5
  • Windows Server 2003
    5
  • .NET Programming
    5
  • MySQL Server
    5
  • Microsoft Development
    4
  • Storage Software
    4
  • ASP.NET
    4
  • SSRS
    4
  • SSIS
    3
  • Microsoft Server OS
    3
  • Oracle Database
    3
  • Visual Basic.NET
    3
  • ASP
    3
  • Microsoft Applications
    3
  • Microsoft SharePoint
    3
  • DB Reporting Tools
    3
  • Microsoft IIS Web Server
    3
  • Microsoft Excel
    3
  • Windows OS
    3
  • Microsoft Legacy OS
    2
  • Visual Basic Classic
    2
  • Active Directory
    2
  • Server Hardware
    2
  • C#
    2
  • VB Script
    2
  • Storage
    2
  • Software
    2
  • Sybase Database
    2
  • VMware
    2
  • Editors IDEs
    2
  • Microsoft Server Apps
    2
  • Windows Server 2016
    2
  • Outlook
    2
  • Microsoft Dynamics
    2
  • SSAS
    2
  • SBS
    2
  • Windows XP
    2
  • Crystal Reports
    2
  • Powershell
    2
  • Windows Networking
    2
  • Enterprise Software
    2
  • Storage Hardware
    2
  • Shell Scripting
    2
  • Azure
    1
  • Windows Server 2012
    1
  • Web Applications
    1
  • Microsoft Office
    1
  • Programming
    1
  • Components
    1
  • Network Management
    1
  • Scripting Languages
    1
  • Virtualization
    1
  • Networking Protocols
    1
  • Accounting
    1
  • Exchange
    1
  • Miscellaneous
    1
  • Programming Languages-Other
    1
  • Cloud Computing
    1
  • Docker
    1
  • Remote Access
    1
  • PHP
    1
  • GIS/GPS Programming
    1
  • Network Operations
    1
  • PostgreSQL
    1
  • Web Servers
    1
  • Windows 2000
    1
  • DB2
    1
  • Hardware
    1
  • ColdFusion Language
    1
  • Network Analysis
    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