Technology Survey SQL Server 2014: Analysis, Migrate and Report (AMR) – a powerful In-Memory migration tool 17.06.2015 by Stéphane Savorgnano An important new functionality of Microsoft SQL Server 2014 is the In-Memory OLTP engine, which enable you to load Tables and also Stored Procedures In-Memory for a very fast response time. The goal is not to load(…)
Database management statistics_level parameter 15.06.2015 by Oracle Team With Enterprise Manager Cloud Control 12c configuring and using the compliance standard utility allows us to discover events we should not have seen in other ways. Today at a customer’s site I discovered the following message: The configuration(…)
Database Administration & Monitoring What is more efficient: arrays or single columns values? – oracle 15.06.2015 by Daniel Westermann In the last post on this topic it turned out that using an array as a column type needs more space than using a column per value in PostgreSQL. Now I’ll do the same test case in Oracle.
Database Administration & Monitoring What is more efficient: arrays or single column values? 15.06.2015 by Daniel Westermann In PostgreSQL ( as well as in other rdbms ) you can define columns as arrays. What I wondered is: What is more efficient when it comes to space: Creating several columns or just creating once column as array? The(…)
Database Administration & Monitoring SQL Interpolation with psql 15.06.2015 by Daniel Westermann The PostgreSQL psql utility provides some really nice features. One of these features is SQL interpolation which allows us to do interesting things, e.g. reading files and analyze the results directly in the database. This post(…)
Database Administration & Monitoring A free PostgreSQL cloud database? 14.06.2015 by Daniel Westermann Recently I was looking for a free PostgreSQL cloud database service for testing. Why? Because I’d like to use such a cloud instance for testing no matter on which workstation or OS I am currently on. Another reason is, that(…)
Database Administration & Monitoring PostgreSQL portable? 12.06.2015 by Daniel Westermann What a surprise: Headed over to the sourceforge page, downloaded, installed (which is just a matter of next/next/next) : Not really the latest patchset but far more than I(…)
Technology Survey SQL Server 2016: native support for JSON 12.06.2015 by Stéphane Haby A lot of discussions and most important, a feature requests in the Microsoft connect site here with more than 1000 votes is the origin of this new feature in SQL Server 2016. A lot of NoSQL have already this function(…)
Database management using dbms_server_alert in combination with a custom monitoring solution 12.06.2015 by Daniel Westermann Lot’s of companies do not use Grid- or Cloud Control for monitoring their Oracle databases for various reasons but rather use open source tools like nagios. And lot of those either implemented custom script frameworks or rely(…)
Database management draft release notes for PostgreSQL 9.5 online 12.06.2015 by Daniel Westermann Bruce Momjian, one of the PostgreSQL Core members, just compiled the first draft version of the release notes for the upcoming PostgreSQL 9.5 Some of the goodies that will show up: BRIN indexes(…)