Infrastructure at your Service

 
Stéphane Haby

SQL Server – Change Management: list all updates

By | Database management | 5 Comments

I am looking to have all SQL Server updates on a server including Service Packs, Cumulative Updates and other fixes like we can see in the uninstall panel from Windows. I take the opportunity of this blog to remind you in a little introduction the different types of patches for SQL Server: Service Pack Service Pack, known as SP is big set of Hotfixes. The particularity is that the regression is fully tested and sometimes…

Read More
Franck Pachot

C15LV: Nothing to BLOG About – Think Again

By | Database management, Oracle | No Comments

By Franck Pachot . Before going to the airport to come back in Europe, the las session I assisted at IOUG Collaborate is a panel: Nothing to BLOG About – Think Again Some famous bloggers were there to help, motivate and inspire people that are afraid to blog. The idea is good. The session was good. The panelists have shared ideas, tips, experience. It was very good. I’m already a blogger, but that inspired me anyway….

Read More
Franck Pachot

SQL Monitor report little improvement in 12c

By | Database management, Oracle | 2 Comments

By Franck Pachot . This is a very short post about something I though I had already blogged about. I like SQL Monitoring active reports. The are graphical, and still very light. There is only one thing I don’t like about it in 11g and it has been improved in 12c Look at the following. The query has run for 1.1 minute. And from the ‘Database Time’ line we can see that it used mostly…

Read More
Nathan Courtine

Get the main information from Windows Server with PowerShell

By | Database Administration & Monitoring | No Comments

This blog will present you a way to retrieve Windows Server main information via PowerShell. The goal is to be able to automate the extraction of information for different purposes: audit, report generation, dashboards…   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!     Computer System information First, I initialize the WMI object containing…

Read More
Daniel Westermann

bulk loading semi structured data in postgresql

By | Development & Performance | 3 Comments

The last post took a look at how to efficiently load 1m rows into a table in PostgreSQL. In this post I’ll take a look on how to do the same with semi structured data. Again it is the same system as in the last post using the same PostgreSQL parameters. Using the hstore datatype For storing key/value pairs there is the hstore extension in PostgreSQL. Using the same sample data as in the last…

Read More
Daniel Westermann

Variations on 1M rows insert(2): commit write – PostgreSQL

By | Development & Performance | No Comments

Franck was quite fast with his second post Variations on 1M rows insert(2): commit write. Lets see what we can do on the PostgreSQL side. I’ll take the same test table as Franck again: create table DEMO (“id” number , “text” varchar2(15), “number” number) ; The pgplsql block which corresponds to Frank’s plsql block looks like this: \timing on truncate table DEMO; DO $$DECLARE l_people_array varchar(15)[12] := ‘{“Marc”, “Bill”, “George”, “Eliot”, “Matt”, “Trey”, “Tracy”,”Greg”, “Steve”,…

Read More
Daniel Westermann

Variations on 1M rows insert (1): bulk insert – PostgreSQL

By | Development & Performance | One Comment

When I read Franck’s post about Variations on 1M rows insert (1): bulk insert I thought doing quite the same in PostgreSQL might be interesting. Lets start by using the same test tables, one using a primary key and the other one without a primary key:create table DEMO (“id” int , “text” varchar(15), “number” int); create table DEMO_PK (“id” int , “text” varchar(15), “number” int, constraint demo_pk_pk primary key (id) ) ; postgres=# \d demo*…

Read More
Matthieu Munch

QlikView – Load data in QlikView / QlikSence – Best practice and trick

By | Entreprise content management | No Comments

In this blog, I will give you some best practices and tricks when you are loading table to generate your data. But before, I will review the different ways to load data in a QlikView or QlikSense report. 1.How to retrieve data in QlikView You have 2 different possibilities to load your data in your report: Database connector File connector a) Database connector: If your data are located in a database, you must use this…

Read More
Franck Pachot

Yesterday’s AWR Straight to the Goal

By | Hardware & Storage, Oracle | 6 Comments

By Franck Pachot . Yesterday I was a speaker at Collaborate15 and did my presentation about reading an AWR report. That was great. Many people (and not enough seats). Here are some aswers about questions that came later. I did that presentation at DOAG last year in a much bigger room. But because of the bigger room there was no questions, and because of the tension I felt in that big room, I made it…

Read More
Franck Pachot

Cloning a PDB from a standby database

By | Database management, Oracle | 5 Comments

By Franck Pachot . Great events like IOUG Collaborate is a good way to meet experts we know through blogs, twitter,etc. Yesterday evening, with nice music in the background, I was talking with Leighton Nelson about cloning PDB databases. Don’t miss his session today if you are in Las Vegas. The big problem with PDB cloning is that the source must be read-only. The reason is that it works like transportable tablespaces (except that it can…

Read More
Franck Pachot

RAC Attack! was another great success at C15LV

By | Operation systems, Oracle | No Comments

By Franck Pachot . The RAC Attack  – install a RAC in your own laptop – is a great success at Las Vegas. The idea is to help people follow the RAC Attack cookbook which is available at: http://en.wikibooks.org/wiki/RAC_Attack_-_Oracle_Cluster_Database_at_Home/RAC_Attack_12c/Hardware_Requirements It is a complex configuration and there is always problems to troubleshoot: get Virtual Box be able to run a 64-bits guest, and that might involve some BIOS settings be able to install VirtualBox, and we…

Read More
Franck Pachot

Dbvisit replicate REDO_READ_METHOD

By | Database management, Oracle | No Comments

By Franck Pachot . A frequent question about replication is the overhead in the source, because in a lot of cases the source is production. Dbvisit replicate comes with the possibility to do the minimum on the source: only the FETCHER process is there to read de redo logs and sends it to the MINE process wich can be on another server. But maybe even that – reading those critical online redo logs – is…

Read More