A discussion for DBA's, database developers, and IT management on compliance concerns, observations, issues, and solutions, based on the consulting work of John Weathington. Comments are welcomed! So please let me know what's on your mind, and we'll discuss. http://www.toadworld.com/Community/QuestExpertsBlogs/tabid/67/BlogId/21/Default.aspx en-US john@excellentmanagementsystems.com webmaster@toadworld.com Sun, 06 Jul 2008 16:36:04 GMT Sun, 06 Jul 2008 16:36:04 GMT http://backend.userland.com/rss Blog RSS Generator Version 3.2.0.15477 Is IT centralization a good thing for your company, or is decentralization the answer? In this article we look at the advantages and disadvantages from a compliance point of view, and my conclusion to this age-old debate. http://www.toadworld.com/Community/QuestExpertsBlogs/tabid/67/EntryID/246/Default.aspx john@excellentmanagementsystems.com http://www.toadworld.com/Community/QuestExpertsBlogs/tabid/67/EntryID/246/Default.aspx#Comments http://www.toadworld.com/Default.aspx?tabid=67&EntryID=246 Thu, 03 Jul 2008 07:00:00 GMT 0 http://www.toadworld.com/DesktopModules/Blog/Trackback.aspx?id=246 Okay, we’ve already learned the prevention is the best medicine. But what do we do when we cannot put preventive controls in place? This article answers that question and more, with more examples and data architecture considerations. http://www.toadworld.com/Community/QuestExpertsBlogs/tabid/67/EntryID/242/Default.aspx john@excellentmanagementsystems.com http://www.toadworld.com/Community/QuestExpertsBlogs/tabid/67/EntryID/242/Default.aspx#Comments http://www.toadworld.com/Default.aspx?tabid=67&EntryID=242 Thu, 26 Jun 2008 07:00:00 GMT 0 http://www.toadworld.com/DesktopModules/Blog/Trackback.aspx?id=242 In this article, we discuss the importance of understanding your “Really As-Is” process, and the big mistake companies make when building process documents. Then, we explore a data architecture for continuously auditing your process in an automated fashion. http://www.toadworld.com/Community/QuestExpertsBlogs/tabid/67/EntryID/237/Default.aspx john@excellentmanagementsystems.com http://www.toadworld.com/Community/QuestExpertsBlogs/tabid/67/EntryID/237/Default.aspx#Comments http://www.toadworld.com/Default.aspx?tabid=67&EntryID=237 Thu, 19 Jun 2008 07:00:00 GMT 0 http://www.toadworld.com/DesktopModules/Blog/Trackback.aspx?id=237 In today’s article, we discuss the different types of controls, the best type of control, and considerations for how these controls can be worked into the data architecture of your company. http://www.toadworld.com/Community/QuestExpertsBlogs/tabid/67/EntryID/232/Default.aspx john@excellentmanagementsystems.com http://www.toadworld.com/Community/QuestExpertsBlogs/tabid/67/EntryID/232/Default.aspx#Comments http://www.toadworld.com/Default.aspx?tabid=67&EntryID=232 Thu, 12 Jun 2008 07:00:00 GMT 0 http://www.toadworld.com/DesktopModules/Blog/Trackback.aspx?id=232 In this article, I scratch the surface on the growing concern of data privacy. We’ll discuss how the industry has reacted to the concern, and how you might start to solution for it. http://www.toadworld.com/Community/QuestExpertsBlogs/tabid/67/EntryID/229/Default.aspx john@excellentmanagementsystems.com http://www.toadworld.com/Community/QuestExpertsBlogs/tabid/67/EntryID/229/Default.aspx#Comments http://www.toadworld.com/Default.aspx?tabid=67&EntryID=229 Thu, 05 Jun 2008 07:00:00 GMT 0 http://www.toadworld.com/DesktopModules/Blog/Trackback.aspx?id=229 What do you do when your company consistently has compliance weak points that don’t seem to go away? This article explores this condition, and provides the steps that your company will need to go through – and how you will support it. http://www.toadworld.com/Community/QuestExpertsBlogs/tabid/67/EntryID/227/Default.aspx john@excellentmanagementsystems.com http://www.toadworld.com/Community/QuestExpertsBlogs/tabid/67/EntryID/227/Default.aspx#Comments http://www.toadworld.com/Default.aspx?tabid=67&EntryID=227 Tue, 03 Jun 2008 07:00:00 GMT 0 http://www.toadworld.com/DesktopModules/Blog/Trackback.aspx?id=227 For years now, agile development has been an extremely efficient way to get results while keeping the customer happy. However there are perils, especially for the database people. This article gives you a primer for what to expect, and how to succeed. http://www.toadworld.com/Community/QuestExpertsBlogs/tabid/67/EntryID/223/Default.aspx john@excellentmanagementsystems.com http://www.toadworld.com/Community/QuestExpertsBlogs/tabid/67/EntryID/223/Default.aspx#Comments http://www.toadworld.com/Default.aspx?tabid=67&EntryID=223 Thu, 22 May 2008 07:00:00 GMT 2 http://www.toadworld.com/DesktopModules/Blog/Trackback.aspx?id=223 If dead people are accessing your database, data breach is right around the corner. In this week’s blog, we discuss database access management concerns, and how to architect a compliance system to handle them. http://www.toadworld.com/Community/QuestExpertsBlogs/tabid/67/EntryID/219/Default.aspx john@excellentmanagementsystems.com http://www.toadworld.com/Community/QuestExpertsBlogs/tabid/67/EntryID/219/Default.aspx#Comments http://www.toadworld.com/Default.aspx?tabid=67&EntryID=219 Thu, 15 May 2008 07:00:00 GMT 0 http://www.toadworld.com/DesktopModules/Blog/Trackback.aspx?id=219 Here we take a look at end users sending data back to the database. Is it a good idea? What are some of the reasons why your end users would want to do this? And, four key tips to consider when designing in this functionality. http://www.toadworld.com/Community/QuestExpertsBlogs/tabid/67/EntryID/216/Default.aspx john@excellentmanagementsystems.com http://www.toadworld.com/Community/QuestExpertsBlogs/tabid/67/EntryID/216/Default.aspx#Comments http://www.toadworld.com/Default.aspx?tabid=67&EntryID=216 Thu, 08 May 2008 07:00:00 GMT 0 http://www.toadworld.com/DesktopModules/Blog/Trackback.aspx?id=216 For the last couple of weeks we’ve been talking about controls. Here we round out our series by talking about Segregation of Duties ( SOD ) as a way to keep things in control. Here are some key tips for designing systems that demonstrate control with SOD. http://www.toadworld.com/Community/QuestExpertsBlogs/tabid/67/EntryID/214/Default.aspx john@excellentmanagementsystems.com http://www.toadworld.com/Community/QuestExpertsBlogs/tabid/67/EntryID/214/Default.aspx#Comments http://www.toadworld.com/Default.aspx?tabid=67&EntryID=214 Thu, 01 May 2008 07:00:00 GMT 0 http://www.toadworld.com/DesktopModules/Blog/Trackback.aspx?id=214