1 / 47

“ Success consists of going from failure to failure without loss of enthusiasm ”

“ Success consists of going from failure to failure without loss of enthusiasm ” “A lie gets halfway around the world before the truth has a chance to get its pants on”. Winston Churchill. Operation Catapult, July 1940. Operation Cover, June 2nd 1944. D-Day, June 6th 1944.

bedros
Download Presentation

“ Success consists of going from failure to failure without loss of enthusiasm ”

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. “Success consists of going from failure to failure without loss of enthusiasm” “A lie gets halfway around the world before the truth has a chance to get its pants on”

  2. WinstonChurchill

  3. Operation Catapult, July 1940

  4. Operation Cover, June 2nd 1944

  5. D-Day, June 6th 1944

  6. Churchill’s War Map

  7. What’s this got to do with SQLDOT ?????

  8. The Applications Support War

  9. Service Desk - hold the line steady out front

  10. Server Management – make sure the infrastructure is battle ready

  11. Networks – tie it all together and keep out attackers

  12. Database Admin – keep up the rear defences

  13. While Project Managers marshal the troops

  14. All working separately – no single view of applications

  15. SQLDOT – The equivalent of Chuchill’s War Map

  16. What services do you think that Dublin City Council provide via SQL Applications ?

  17. PLANNING Traffic Housing Dublin Bus RTPI ERCC (Emergency Response) Water Quality Testing Drainage DCC Credit Card Payments DCC Sports Centers Voters Register

  18. Traffic video

  19. Key Points from the Video • Over-reliance on key individuals • No ‘single source’ of documentation • Any documentation present is long since out of date

  20. SQLDOT – Business Case Provide a ‘birds-eye view’ of SQL applications

  21. With SQLDOT, the traffic lights being down won’t be such a drama!

  22. So what is SQLDOT? Is it just another application for manual input of data?

  23. What is different about SQLDOT? COMPARISON ENGINE Allows SQLDOT to compare a picture of yesterdays infrastructure against today's infrastructure

  24. SQLDOT Power shell Scripts Power shell scripts run against all servers in instance table and returns database information Run Date/Time SQL Instance Name List of Databases File Locations File Sizes Building up Historical Data Instance Table VM-SQLSRV1 VM-SQLSRV2 VM-SQLSRV3 VM-SQLSRV4 VM-SQLSRV5 VM-SQLSRV6 VM-SQLSRV7 Day 1 Day 2 Day 3 Day 4

  25. SQLDOT Comparison Engine Historical Table Comparison Day 1 Same Day 2

  26. SQLDOT Comparison Engine Historical Table Comparison Day 1 Same Day 2 Same Day 3

  27. SQLDOT Comparison Engine Historical Table Comparison Notification Day 1 Same Day 2 Same Day 3 Different Notification Day 4

  28. Out of Scope • Oracle applications, • Replicating what other apps do • Linking to call management system • Implementing a full CMDB

  29. In-Scope • SQL Applications Info • Automatic collection of db info • Reports on DB downtime, Apps and DB trending, DR Run-book. • Link to project site, service description doc, XYMON and contract.

  30. The Journey

  31. Link to Balsamiq Prototype • https://eileendennan.mybalsamiq.com/projects

  32. Adam’s video

  33. The Bigger Picture Why are we the right people for the Job? What is the on Government Sector Horizon? Are there any other possible customers outside our own organisation?

  34. Skill Sets Our team includes a Project Manager who has worked on Nationwide projects. We have a SQL DBA who manages Nationally centralised databases. We have an Infrastructure Architect with knowledge of national public facing systems.

  35. Organisational Buy In We have access to users who need these systems Most importantly we have buy in from Senior Management

  36. Government Sector Landscape In June 2012 the Irish government released a Strategy Document They suggested a plan for shared services across 10 national datacentres

  37. Government Sector Lanscape Budgets dried up and Government bodies are left with insufficient budgets to meet immediate needs.

  38. Dublin City Council Vision Have the infrastructure to run national shared services Are actively seeking to host and run nationally shared services This means even more SQL databases

  39. Dublin City Council Run fibre around the city, have access to greater bandwidth than other authorities. Our fibre Network is more resilient than Government Networks.

  40. Other County Councils We have sent out e-mails to all the county councils. None have an automated system. All expressed interest in using such a system.

  41. Important Bodies In the Local Government Sector the most important ICT body is the LGMA. They direct what software local authorities use and buy They are interested in SQLDoT

  42. Our Product These are the reasons why we think our product can be a success

  43. Just ask the IT Crowd

  44. Our Product We hope you enjoyed our presentation... Any Questions?

More Related