This Log Buffer Edition covers Oracle, SQL Server and MySQL blog posts listing down few new tricks, tips and workarounds plus the news.
Oracle:
Displaying CPU Graphs For Different Time Ranges in Enterprise Manager
One of the cool things in 12c is that (finally after all these years) a sequence can be assigned as the default value for a column.
Jonathan Lewis demonstrates connect by after receiving an email.
Oracle 12c – PL/SQL “White List” via ACCESSIBLE BY
Oracle DBA, IT Manager, or Something Else
SQL Server:
Using R Machine Learning Script as a Power BI Desktop Data Source
SQL Authentication Via AD Groups Part II: Who has what access?
Using R Machine Learning Script as a Power BI Desktop Data Source
Connect to on premise data sources with Power BI Personal Gateway
Exploring SQL Server 2016 Dynamic Data Masking – Part One – Creating a Table that uses Dynamic Data Masking
MySQL:
Data Encryption at Rest
Planets9s: Download the new ClusterControl for MySQL, MongoDB & PostgreSQL
Automate your Database with CCBot: ClusterControl Hubot integration
Loading JSON into MariaDB or even MySQL – mysqljsonimport 2.0 is available
Privileges in MySQL and MariaDB: The Weed Of Crime Bears Bitter Fruit
No comments