Infrastructure at your Service

Stéphane Savorgnano

SQL Server 2017 on RHEL first installation

By | Database Administration & Monitoring | No Comments
 

 Beginning of last week Microsoft announced the general availability of SQL Server 2017 for today, the second of October. In the same time, but in a more marketing side, Microsoft announced a SQL Server on Red Hat Enterprise Linux offer, more information here. It looked for me like the good time to do my first installation of SQL Server 2017 on Linux. My first concern was to download an ISO of the Red Hat Enterprise…

Read More
Stéphane Haby

SQL Server 2016: New Dynamic Management Views (DMVs)

By | Database Administration & Monitoring, Database management | No Comments
 

 In SQL Server 2016, you will discover a lot of new Dynamic Management Views(DMVs). In this article, I will just give you a little overview of these useful views for us as DBA. SQL Server 2012 has 145 DMVs and SQL Server 2014 has 166 DMVs. Now, SQL Server 2016 has 185 DMVs. How to see it? It is very easy to have a look using the sys.all_objects view: SELECT * FROM sys.all_objects WHERE TYPE=’V’…

Read More
Mehdi Bada

Oracle Big Data Cloud Service – Compute Edition

By | Cloud, Oracle | 4 Comments
 

 In this blog post, we will see how to create a Big Data cluster through the Oracle Cloud Services. If you want more details about the Oracle Big Data cloud services offering, you can refer to my previous blog Introduction to Oracle Big Data. First, you need to create your trial account through the following link: https://cloud.oracle.com/tryit. Note that, when you create your trial account, all information (phone number, address, credit card…), must be from…

Read More
Mehdi Bada

Introduction to Oracle Big Data Services

By | Big Data, Oracle | No Comments
 

 Since few years, Oracle decided to move forward in the Big Data area, as their main competitor. The goal of this blog post is to explain you, how the Oracle Big Data offering is composed. As the Oracle Big Data offering is continuously improving, I’m always open to your feedback Oracle Big Data offering is split in 2 parts: On-Premise Public Cloud Note: It’s important to know, that the 2 main Big Data distribution on…

Read More
Daniel Westermann

Announcing the dbi OpenDB Appliance

By | Database Administration & Monitoring | No Comments
 

 As already announced on Twitter and LinkedIn here is the blog post to describe our OpenDB appliance in more detail. I am sure you wonder what this is about so let me explain why we are doing this. What we do see day by day at our customers is that more and more databases get consolidated on to a VMWare deployment. This is not only true for the smaller ones of those but also for…

Read More
Franck Pachot

When deterministic function is not

By | Oracle | No Comments
 

 When you declare a function-based index, the function is deterministic, which means that calling it with same arguments will always return the same result. This is required because the indexed values, which are the result of the function, are stored in the index. But what happens if you declare a function deterministic when it is not?

Read More
Pascal Brand

Using WebLogic 12C RESTful management for monitoring WebLogic Domains

By | Application integration & Middleware, Oracle | No Comments
 

 WebLogic 12.2.1 provides a new RESTful management interface with full accesses to all WebLogic Server resources. This interface offers an alternative to the WLST scripting or JMX developments for the management and the monitoring of WebLogic Domains. The following of this blog provides a few examples demonstrating the simplicity and the efficiency of the REST requests. WebLogic Server State When checking a WebLogic Server state, we are interested in the state and in the “ActivationTime”…

Read More
Franck Pachot

Am I a DBA 3.0 or just an SQL*DBA?

By | Oracle | 2 Comments
 

 There are currently a lot of new buzz words and re-namings which suggest that our DBA role is changing, most of them escorted with a #cloud hashtag. Oracle Technology Network is now called Oracle Developer Community. Larry Ellison announced the database that does not need to be operated by humans. And people talking about the death of DBA, about the future of DBA, about DBA 3.0,… Those are all generalizations and universal statements, and I…

Read More
Franck Pachot

Wrong result with multitenant, dba_contraints and current_schema

By | Oracle | No Comments
 

 Multitenant architecture is not such a big change and this is why I recommend it when you start a project in 12c or if you upgrade to 12.2 – of course after thoroughly testing your application. However, there is a point where you may encounter problems on dictionary queries, because it is really a big change internally. The dictionary separation has several side effects. You should test carefully the queries you do on the dictionary…

Read More