DBTA E-EDITION
May 2017
Subscribe to the online version of Database Trends and Applications magazine. DBTA will send occasional notices about new and/or updated DBTA.com content.
Trends and Applications
As data centers evolve and become more advanced, so too should the tools that are built for them. The traditional approach of monitoring data centers results in reactive problem solving and more alerts than anyone can handle. As we move from reactively monitoring to proactively managing data centers, there will be fewer disruptions, faster resolution, and higher efficiencies. But in order to achieve meaningful gains in these metrics, the new approach and tools must support a critical functionality: automation.
Columns - Database Elaborations
Choices are pervasive when designing a database. The data modeler must progress through a series of issues: What ideas are important? Which objects stand out? Which concepts can take a back seat? Adding to all those decisions comes understanding the target structures one is shooting at. A normalized design may lean one way, while a dimensional design may lean another.
Columns - DBA Corner
As DBAs, we can get mired in the depths of performance tuning parameters and scripts, sometimes getting lost in all the details. It is a good idea to always have a set of goals and philosophies that you can lean on to keep you focused and working on the appropriate things. That is what I want to talk about in this month's DBA Corner column. Some high-level rules of thumb for achieving your DBMS-related performance goals and maintaining your sanity.
Columns - SQL Server Drill Down
Not only has the Microsoft SQL Server engineering team added more and stronger leadership, outstanding individual engineers and staff members, but it is also radically moving its entire development process into a "cloud-first" ethos. Now, I'd like to show one of the most salient results of this new development process-accelerated product releases. It was only a few years ago (and is still the case for other data management platforms) that a major new release takes at least 2, but more likely 3 years. With the "production-ready" release of SQL Server 2017 Community Technology Preview 2.0, we are only 1 year from the last production release.
Columns - MongoDB Matters
MongoDB faced its worst-ever public relations challenge earlier this year when a spate of ransomware attacks plagued tens of thousands of Mongo instances. It's important to realize that we are not talking about some sort of obscure vulnerability here - these MongoDB databases were configured with NO passwords at all, and were easily found listening on the default port (27017) on publicly-accessible servers.
MV Community
Absa Vehicle Finance is now running its MultiValue application on an entirely Microsoft platform, thanks to partnering with ONgroup. The company used ONgroup's MVON# toolset for the changeover to .NET for the application run machine. Absa also selected SQL Server as the DBMS.
Kore Technologies is releasing the latest update to its signature platform, Kourier Integrator, focusing on enhancing two areas including REST API and new API documentation. The latest release introduces a new Subscription capability for published REST APIs.