DBTA E-EDITION

Subscribe to the DBTA E-Edition email newsletter




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

Hadoop and NoSQL databases have emerged as leading choices to capture and analyze big data by bringing new capabilities to the field of data management and analysis. At the same time, the relational database, firmly entrenched in most enterprises, continues to advance in features and varieties to address new challenges.

Data security has been the source of dramatic changes in the last 10 years, influencing technologies and the way businesses operate globally. Data Summit 2017 will take a deep dive into evolving enterprise security considerations during the Data Security Forum moderated by Michelle Malcher, security architect at Extreme Scale Solutions. Data Summit 2017 takes place May 16-17 at the New York Hilton Midtown, with pre-conference workshops on May 15.

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.

Sponsors