Infrastructure at your Service

 
Microsoft Team

SQL Server 2016 : availability groups and the new ssis_monitor role for SSIDBB catalog

By | Database Administration & Monitoring | No Comments

During my investigation about the new AlwaysOn features, I wrote a blog post about the new SSISDB support for AlwaysOn. You can find it here: > SQL Server 2016 : availability groups and the new SSISDB support Just as a reminder, for those who have dealt with the SSISDB catalog in the previous version, some extra works were mandatory to be “AlwaysOn” compliant. Fortunately, the new version of SSIDB catalog will make easier the DBA…

Read More
Jérôme Witt

Install Oracle instant client and perl DBD::Oracle @ Mac OS X Yosemite

By | Database Administration & Monitoring | No Comments

Recently, I tried to install and connect to Oracle databases directly from my new Mac Book using perl  (Yes, perl is still one of the most friendly programming language for DBAs). What first seemed to be easy was in reality quite difficult and long. Alone, the huge quantity of  hits on the WorldWideWeb was impressive. However none of the hits were providing the entire solution. Follows, all the steps to prepare and install the Oracle…

Read More
Microsoft Team

SQL Server AlwaysOn: number of databases and the hadr worker pool

By | Database Administration & Monitoring | One Comment

Often, when I’m in charge to implement an SQL Server AlwaysOn infrastructure with availability groups, customers ask me if it exists some best practices and recommendations about the maximum number of databases in an availability group planning. In fact, we have to keep in mind the relation between databases and the SQL Server worker pool in this architecture. Remember that the SQL Server AlwaysOn and availability group feature is an extension of the SQL Server…

Read More
Middleware Team

Oracle Java Cloud event 1st Septembre in Geneva

By | Application integration & Middleware | No Comments

Tuesday, the 1st of September, we attended an Oracle’s Java Cloud Platform as a Service demonstration in Geneva. Presentation was organized by Arrow – Switzerland. Presentation aims to show us new opportunities of development in the Cloud, and we were invited to attend several live demonstrations of these new Oracle products. Java Cloud PaaS allows developers and managers to have a complete software factory platform that can follow full development lifecycle of an application. But,…

Read More
Stéphane Savorgnano

SQL Server 2016: Upgrade Advisor

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

During the read of a blog of my colleague Nathan Courtine about Stretch database, I installed the version of SQL Server 2016 Upgrade Advisor and Oh surprise! it looks really NEW! “A new generation of advisor tool for SQL Server” aka Microsoft. To download and install it, click here. This new version has a dual role: Check the compatibility of old versions of SQL Server compared to SQL Server 2016 Help adoption of new SQL…

Read More
Microsoft Team

Join transitive closure and query simplification considerations

By | Development & Performance | No Comments

Yesterday, I had a discussion with one of my friend who works with Oracle about some different behaviours between each query optimizer against one particular query. You can read his blog post and get the repro script here. I decided to write a blog post because our discussion has introduced some interesting concepts and I wanted to explain more things from the SQL Server side. First of all let me set the scene that is…

Read More
Daniel Westermann

If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops?

By | Database Administration & Monitoring | No Comments

This is the next post on this GoldenGate series: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate Performing an initial load with GoldenGate (1) – file to replicat Performing an initial load with GoldenGate (2) – expdp/impdp Using GoldenGate event actions to suspend replication for end of day reporting One question that pops up when stopping the replication by using an event marker is: What happens…

Read More