Infrastructure at your Service

Category

Database Administration & Monitoring

Oracle Team

OOW15 – Day 3 – thoughts from DemoGrounds about SIZE AUTO

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . If you are at Oracle Open world, don’t miss the DemoGrounds where you can talk to product managers and developers. It’s a good way to know how and why something is implemented. They also listen to your user experience on their product, for possible evolution. But remember they are not there to receive complaints or answer your SR… Of course, I had a lot of very interesting discussions about current and…

Read More
Oracle Team

OOW15 – Day 1- No fog on Golden Gate brige but Cloud everywhere at Moscone center

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . Here are the two sides of the Oracle Open World: marketing and community. Of course Oracle organizes that big event for marketing: show the future products and explain how they are better than all competitors ones. But it’s not only that. There is a community around Oracle, of users, partners, technologists, speakers, authors, etc. And Oracle Open World is also the place to meet.

Read More
Stéphane Haby

SQL Server 2016 – Security: Dynamic Data Masking – Other Data Types

By | Database Administration & Monitoring, Technology Survey | No Comments

This blog is a part of the series “SQL Server 2016 – Security: Dynamic Data Masking“. I remember you my different logins used to connect to AdventureWorks: sql login u1 with the db_owner role –> No masking sql login u2 with the db_datareader role –> masking The Data Types used are: xml, date, datetime and varbinary.

Read More
Stéphane Haby

SQL Server 2016 – Security: Dynamic Data masking – String Data Types

By | Database Administration & Monitoring, Technology Survey | No Comments

This blog is a part of the series “SQL Server 2016 – Security: Dynamic Data Masking“. I remember you my different logins used to connect to AdventureWorks: sql login u1 with the db_owner role –> No masking sql login u2 with the db_datareader role –> masking The Data Types used are: sysname, char, nchar, nvarchar and varchar.

Read More
Stéphane Haby

SQL Server 2016 – Security: Dynamic Data masking – Numeric Data Types

By | Database Administration & Monitoring, Technology Survey | No Comments

This blog is a part of the series “SQL Server 2016 – Security: Dynamic Data masking“. I remember you my different logins used to connect to AdventureWorks: sql login u1 with the db_owner role –> No masking sql login u2 with the db_datareader role –> masking The Data Types used are: bit, tinyint, smallint, int, float & money.

Read More
Daniel Westermann

Linux Magic System Request Key Hacks

By | Database Administration & Monitoring | No Comments

Recently at a customer we needed to power-cycle a database system because we wanted to be sure that a cluster resource fails over to a remaining node as expected. The issue was that we did not have access to the data center where the system is running nor did we have access to the console. What to do? Actually it is quite easy to force a system to reboot without syncing the disks or unmounting…

Read More
Oracle Team

SQL> alter database switchover to …

By | Database Administration & Monitoring, Oracle | One Comment

By Franck Pachot . In 12c the manual switchover to physical standby requires only one command (ALTER DATABASE SWITCHOVER) instead of two (ALTER DATABASE COMMIT TO SWITCHOVER on each database). We usually recommend to use the broker and I wanted to see if the broker uses that new command or not. Let’s compare the alert.log for both manual and broker switchover. One simple command I have the broker configured, but try a manual switchover with…

Read More
David Barbarin

SQL Server 2016 query store

By | Database Administration & Monitoring, Development & Performance | 2 Comments

One of the most new interesting features that will be introduced by SQL Server 2016 is certainly the query store that will complete the performance tuning toolbox of database administrators. Basically, the query store will track queries, their query plans and runtime statistics as well. It will be a great tool to detect regressing queries. I remember a real customer case a couple of months ago where I was involved in a database migration project…

Read More