Database management Improving your SharePoint performance using SQL Server settings (part 1) 08.05.2014 by Nathan Courtine SharePoint performance is a recursive problem and preoccupation. As a Database Administrator, we have to deal with SharePoint when configuring SQL Server databases. In this article, I will propose a list of best practices in SQL Server settings(…)
Application integration & Middleware SQL Server 2014: SELECT INTO operators can run in parallel 06.05.2014 by Microsoft Team A couple of weeks ago, I had to provide some best practices in term of architecture for a “heavy writes” environment that consists in importing data from different sources into SQL Server tables. At the customer place, I was(…)
Database management, Oracle ROWNUM vs ROW_NUMBER() and 12c fetch first 05.05.2014 by Oracle Team By Franck Pachot . Prior to Oracle 12c, there were two ways to do ‘top-n’ queries: use rownum after sorting rows with “order by” use row_number() over (order by) Top-n queries are usually required for result pagination. The application(…)
Database management, Oracle Oracle 12c CDB – metadata & object links internals 30.04.2014 by Oracle Team By Franck Pachot . Warning: this is only geek stuff about internals on multitenant database dictionary, metadata, and object links. It has nothing to do with the operations that you can do on your database. Don’t try that in(…)
Database management AWR Formatter: plug-in Google Chrome pour rapports AWR 28.04.2014 by Oracle Team Chacun d’entre nous à une façon bien différente d’appréhender le rapport AWR (Oracle Automatic Workload Repository). Nous utilisons nos propres processus de lecture et notre propre appoche. Dans ce blog je vous propose de découvrir AWR Formatter, un outil qui(…)
Database management SQL Server 2014: In-Memory tables, Bw-Tree, and storage 17.04.2014 by Microsoft Team SQL Server 2014 introduces hash indexes with in-memory optimized tables. I described some of their aspects in a previous blog post. These indexes are very efficient with lookup search operations but have some limitations with operations(…)
Database management Oracle TNS_ADMIN issues due to bad environment settings 15.04.2014 by Oracle Team Recently, I faced a TNS resolution problem at a customer. The reason was a bad environment setting: The customer called the service desk because of a DBLINK pointing to a bad database. The users were supposed to be redirected to a(…)
Database management, Oracle Oracle 12c Adaptive Plan & inflection point 11.04.2014 by Oracle Team By Franck Pachot . The Oracle 12c Adaptive Plan feature was already presented by Nicolas Jardot in OOW 2013: Solving customer issues with the 12c Optimizer. I recently had to answer several questions about its behavior at execution(…)
Application integration & Middleware How to install and manage a Kerberos Server 11.04.2014 by Morgan Patou For some time now, I have been working on how to set up a Single Sign-On (SSO) solution in my company. As a big fan of Open Source solutions, I have obviously proposed the implementation of a solution based(…)
Database Administration & Monitoring, Oracle Best practice for the sending of an Oracle execution plan 08.04.2014 by Oracle Team By Franck Pachot . You have a query that takes too long and you want help to analyze the execution plan? Then you need to get it with relevant information, and correctly formatted. Autotrace is not a good option(…)