Infrastructure at your Service

 
Franck Pachot

Matching SQL Plan Directives and queries using it

By | Database management, Oracle | No Comments

By Franck Pachot . This is another blog post I’m writing while reviewing the presentation I’m doing next week forSOUG and next month for DOAG. You have SQL Plan Directives used by several queries that have same kind of predicates. And queries that can use several SPD. Can you match them? When a query uses a SPD (meaning that the SPD in usable state – NEW, MISSING_STATS or PERMANENT internal state) the execution plan show…

Read More
Morgan Patou

Kerberos configuration for DFS 6.7 SP1

By | Application integration & Middleware | 2 Comments

In my last post, I explained how to configure Kerberos for a CS 6.7 SP1. Unfortunately if you only configure the Content Server, it will almost be useless… If you want this configuration to be useful, then you will also have to configure the Kerberos SSO for the Documentum Foundation Services (DFS). That’s why in this blog post I will describe step by step what need to be done for that purpose. So what are…

Read More
Daniel Westermann

does impdb into a compressed table really compress data?

By | Database management | One Comment

Today at a customer we discussed the following scenario: To refresh a test database a datapump export and import was implemented. To save space on the test system the idea came up to compress the data on the test system. When we checked the documentation we came across the following statement: “When you use basic table compression, warehouse compression, or archive compression, compression only occurs when data is bulk loaded into a table.” So the…

Read More
Franck Pachot

Matching SQL Plan Directives and extended stats

By | Database management, Oracle | One Comment

By Franck Pachot . This year is the year of migration to 12c. Each Oracle version had its CBO feature that make it challenging. The most famous was the bind variable peeking in 9iR2. Cardinality feedback in 11g also came with some surprises. 12c comes with SPD in any edition, which is accompanied by Adaptive Dynamic Sampling. If you want to know more about them, next date is in Switzerland:http://www.soug.ch/events/sig-150521-agenda.html SQL Plan Directives in USABLE/MISSING_STATS…

Read More
Microsoft Team

Using VSS snapshots with SQL Server – part I

By | Database management | One Comment

  This is probably a series of blog posts about some thoughts concerning VSS snapshots with database servers. Let’s begin with this first story: Some time ago, I implemented a backup strategy at one of my customers based on FULL / DIFF and log backups. No issues during a long time but one day a call of my customer who told me that since some days, the differential backup didn’t work anymore with the following…

Read More
Microsoft Team

News SharePoint 2016: new alternative to InfoPath Forms

By | Application integration & Middleware | 5 Comments

Microsoft announced in January 2015 that it was the END OF INFOPATH, that the 2013 version would be the last one. However, Microsoft updated the Infopath 2013 app will work with SharePoint Server 2016. Following the new users needs, Microsoft decided InfoPath wasn’t suited for the job, that’s why Microsoft won’t release a new version but only propose an alternative. What is InfoPath Forms? InfoPath is used to create forms to capture information and save…

Read More
Microsoft Team

Microsoft Project Management Tools: SharePoint 2013 and Project Server 2013

By | Application integration & Middleware | No Comments

Project Management? Project management is the process and activity of planning, organizing, motivating, and controlling resources, procedures and protocols to achieve specific goals in scientific or daily problems. Why using Project Management? Using Project Management methods and strategies decrease risks, reduce costs and improve success rates of your projects! What are the Business Needs? Rationalize investment Align work with strategic objectives Manage projects and resources effectively Gain visibility and control over projects Microsoft has 3…

Read More
Nathan Courtine

Get the main information from SQL Server databases with PowerShell

By | Database management | One Comment

As I promised in my previous blog Get the main Administration Information from SQL Server with PowerShell, I will present you this time how to retrieve the SQL Server databases information with PowerShell. Disclaimer: I am not a developer but a SQL Server dba. If you find errors or some ways of improvement, I will be glad to read your comments! Retrieve SQL Server databases information I use the SMO objects to access the instance…

Read More
Microsoft Team

Variations on 1M insert (2): write commit

By | Development & Performance | No Comments

In this blog post, I will try to do the same than my colleagues about Oracle and for PostgreSQL. As a reminder, we’ve seen in my previous blog post that SQL Server is designed to commit transactions implicitly by default and inserting 1M rows in this case may have a huge impact on the transaction log throughput. Each transaction is synchronously committed to the transaction log. In this blog post, we’ll see a variation of…

Read More
Nathan Courtine

Get SQL Server Network Configuration with PowerShell

By | Database management | One Comment

This blog is part of a set which try to automate the SQL Server administration with PowerShell. It explains how to retrieve the network configuration of a SQL Server instance with PowerShell. I will refer to my previous blog Get SQL Server services with PowerShell. I presented how to get the SQL Server Engine service. I will assume the service has already been retrieved. Disclaimer: I am not a developer but a SQL Server dba….

Read More
Microsoft Team

SharePoint 2016: What’s new? And What to expect?

By | Application integration & Middleware | One Comment

The Ignite Event took place in Chicago last week. According to what has been presented, here are the first news about the new SharePoint 2016!  SharePoint 2016 looks like an enhancement of the existing SharePoint 2013 version. Most of the SP2013 features will continue to work but in a more powerful way. SharePoint 2016 will be focused on the following points: Security Compliance Advanced Analytics and Insights (data analysis and reporting) Cloud experience The new…

Read More
Daniel Westermann

What will be coming with the next major version of postgresql ?

By | Database management | One Comment

A PostgreSQL major version is usually released once a year. For the next major version, which is 9.5, this probably will be in the second half of 2015. As PostgreSQL is an open source product everything that goes on is available to the public. If you want to know what will be coming in the next release there are several places you might take a look at. The PostgreSQL documentation The official PostgreSQL documentation is…

Read More