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

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

More bio
Activity
Points this month0
Total points2,790,551
Questions: 47
Solutions: 2169
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 97,449 points to level up.
LVL 38
  • Overall
    37
  • Microsoft SQL Server
    29
  • Microsoft SQL Server 2005
    21
  • Microsoft SQL Server 2008
    19
  • Query Syntax
    13
  • Databases
    11
  • 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
  • SSRS
    4
  • Microsoft Server OS
    4
  • ASP.NET
    4
  • SSIS
    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
  • Server Hardware
    3
  • Microsoft Legacy OS
    2
  • Visual Basic Classic
    2
  • Storage
    2
  • Active Directory
    2
  • C#
    2
  • Windows Server 2016
    2
  • VMware
    2
  • Software
    2
  • VB Script
    2
  • Sybase Database
    2
  • Azure
    2
  • Editors IDEs
    2
  • Microsoft Server Apps
    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
  • Windows Server 2012
    1
  • Microsoft Office
    1
  • Web Applications
    1
  • Windows 10
    1
  • Programming
    1
  • Components
    1
  • Network Management
    1
  • Scripting Languages
    1
  • Virtualization
    1
  • RAID
    1
  • Networking Protocols
    1
  • Accounting
    1
  • Exchange
    1
  • Miscellaneous
    1
  • Programming Languages-Other
    1
  • Operating Systems
    1
  • Hyper-V
    1
  • Cloud Computing
    1
  • Docker
    1
  • Remote Access
    1
  • PHP
    1
  • Hardware
    1
  • GIS/GPS Programming
    1
  • Network Operations
    1
  • PostgreSQL
    1
  • ColdFusion Language
    1
  • Web Servers
    1
  • Windows 2000
    1
  • DB2
    1
  • Network Analysis
    1
  • Networking
    1
  • Disaster Recovery
    1
  • Web Development
    1
  • File Sharing Software
    1
  • Power BI
    1
  • SSL / HTTPS
    1
  • Business Management
    1
  • Linux
    1
  • Security
    1
  • Installation
    1
  • COBOL
    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