Database management

DBA, turkeys and NoSQL hype

By Franck Pachot . We (DBAs) look at this NoSQL hype with a large smile. We know how powerful are SQL databases and we can't imagine processing data seriously without it. And the technologies that come with NoSQL brings back(…)

How to be sure that tempdb size is good to run a DBCC CHECKDB?

In many blogs or forums, you can read that the answer is to use the option: WITH ESTIMATEONLY. With this option, you can easily have the space estimation needed to check the database in tempdb. But be careful, only since(…)

SSISDB is too big and it is not every time the retention period’s fault!

In all blogs that I read, the solution is just to change the retention period to a reasonable value. Yes, it is true but in some case you need to go deeper in the analysis… Like you, I(…)

Oracle and Analytic Queries before In-Memory option

By Franck Pachot . Next Tuesday in Geneva I'm presenting Oracle In-Memory Column Store to Business Intelligence people at the Swiss BI Day After defining what is an analytic query, I show the different approaches to optimize that in(…)

Oracle 12c duplicate in cluster fails with ORA-65500

I had to perform a duplicate database between 2 ODAs and was always facing an ORA-65500 at the begin of the RMAN operation. Looking a bit deeper in the log outputs pointed me out that it was due to some(…)

Oracle CDC for Datawarehouse, Dbvisit replicate as an alternative

By Franck Pachot . You don't want to reload the datawarehouse database every night. And you may want to have it refreshed more often, in real-time during the day. There is another reason to capture all changes from the(…)

Oracle Database Cloud Service – DBaaS

By Franck Pachot . My first trial was not very good because I had access to Schema as a Service only. Which is not new. But Oracle Cloud Services is becoming(…)

SQL Server 2016: In-Memory OLTP enhancement

The CTP2.1 has been released for some weeks and it is time to check which interesting enhancements have been already deployed for the In-Memory OLTP feature. I will first have a look to the memory optimized table. Memory Optimized(…)

Dealing with SSRS subscription schedules in AlwaysOn environment

A couple of days ago, I had the opportunity to work with AlwaysOn 2014 infrastructure that included a report server (SSRS) in native and scale-out mode. As you know, dealing with SSRS and availability groups is not an easy task(…)

Clustered columnstore index and memory management

Few weeks ago, I had the opportunity to give a session about the clustered columnstore index feature (CCI) at our In-Memory event dedicated to In-Memory technologies for Microsoft SQL Server, Oracle and SAP HANA. During our session, I explained(…)