Infrastructure at your Service

 
Nathan Courtine

Get the main Administration Information from SQL Server with PowerShell

By | Database management | No Comments

In my previous blog Get SQL Server services with PowerShell, I presented you the first step of the SQL Server administration through an automated process. This blog is a follow-up of the previous one, and it will focus on retrieving information of a SQL Server instance 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…

Read More
Nathan Courtine

Get SQL Server services with PowerShell

By | Database management | 2 Comments

SQL Server Configuration Manager and SQL Server Management Studio are the main tools to administrate the components of SQL Server. They are very convenient to use and pretty complete. But as soon as you wish an automated process, these tools have their limitations. Nevertheless, there is still the solution: PowerShell! This blog introduces a first step towards an automation process of SQL Server administration. I will retrieve all SQL Server services related to a specific…

Read More
Daniel Westermann

getting started with postgres plus advanced server (3) – setting up a hot standby server

By | Hardware & Storage | 5 Comments

So, we have a ppas 94 database up and running and we have a backup server for backing up and restoring the database. Now it is time to additionally protect the database by setting up a hot standby database. This database could even be used to offload reporting functionality from the primary database as the standby database will be open in read only mode. Again, I’ll use another system for that so that the system…

Read More
Franck Pachot

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

By | Database management, Oracle | No Comments

By Franck Pachot . This blog is the first one of a series about inserting 1 million rows. Do you have an idea about the time it takes? The idea came from another project, about NoSQL databases, but I’ll focus on Oracle in those posts. There are a lot of different ways to insert 1 million rows in Oracle: row-by-row insert or bulk, row-by-row commit or not, different ways to commit, In-Memory Database, Database In-Memory…

Read More
Microsoft Team

Using Windows 2012 R2 & dynamic witness feature with minimal configurations

By | Operation systems | No Comments

F I wrote a blog post some time ago about using a file share witness with a minimal windows failover cluster configuration that consists of two cluster nodes. In this blog post, I told I was reluctant to use a witness in this case because it introduces a weakness in the availability process. Indeed, the system is not able to adjust node weight in this configuration but it does mean that we don’t need a…

Read More
Stéphane Savorgnano

Windows Server Next, AKA Windows Server 2016!

By | Technology Survey | No Comments

The first technical preview of the future version of Windows Server was, since last October, available (here) and a second one with more new features should be available in May. The final version which should be normally released in 2015 has been recently postponed to 2016. It will be the first time that the client and server releases will be decoupled. This new version of Windows Server will include: new and changed functionalities for Hyper-V…

Read More
Daniel Westermann

getting started with postgres plus advanced server (2) – setting up a backup and recovery server

By | Database management | 5 Comments

The first post in this series explained how to get ppas installed on a linux system. Now that the database cluster is up and running we should take care immediately about backup and recovery. For this I’ll use another system where I’ll install and configure bart. So, the system overview for now is: server ip address purpose ppas 192.168.56.243 ppas database cluster ppasbart 192.168.56.245 backup and recovery server As bart requires the postgres binaries I’ll…

Read More
Franck Pachot

A migration pitfall with ALL COLUMN SIZE AUTO

By | Database management, Oracle | No Comments

By Franck Pachot . When you migrate, you should be prepared to face some execution plan changing. That’s not new. But here I’ll show you a case where you have several bad execution plans because lot of histograms are missing. The version is the same. The system is the same. You’ve migrated with DataPump importing all statistics. You have the same automatic job to gather statistics with all default options. You have repeated the migration…

Read More
Stéphane Haby

SQL Server Tips: How to know if In-Memory Feature is supported by your server?

By | Database management | No Comments

A customer asks me, how to know if In-Memory Feature is supported by my SQL Server server? An easy way is to check the edition, version etc. but now, you have directly a property for that. On msdn here, you find all property that you can search with the T-SQL Command: SERVERPROPERTY But if you try to run through all your servers with CMS (Central Management Server), for all SQL Server below than SQL Server…

Read More
Daniel Westermann

getting started with postgres plus advanced server (1) – setting up ppas

By | Database management | No Comments

I did several posts around postgresql and postgres plus advanced server in the past. What is missing is a beginners guide on how to get postgres plus advanced server up and running including a solution for backup and recovery, high availability and monitoring. So I thought I’d write a guide on how to do that, consisting of: setting up postgres plus advanced server setting up a backup and recovery server setting up a hot standby…

Read More
Stéphane Haby

Azure DocumentD8: Microsoft goes to NoSQL

By | Technology Survey | No Comments

Azure DocumentDB is a documentary database service and as like its name suggests, it is aMicrosoft Azure Cloud service. Since the last summer, developers have access to this new service, and now it is available for all. The Redmond Company offers for the first time a “NoSQL” database. This is not the only service that has come; it is associated to Azure Search, a full text search service.   Why NoSQL? Is first and foremost…

Read More
Franck Pachot

List listeners and services from the instance

By | Database management, Oracle | No Comments

By Franck Pachot . Want to know all your listeners – including scan listeners, and the services it listens for? It is possible from the instance, with the – undocumented – view V$LISTENER_NETWORK which is there since 11.2 Let’s look at it from a RAC database: SQL> select * from GV$LISTENER_NETWORK And here is the result: INST_ID NETWORK TYPE VALUE CON_ID 1 LOCAL LISTENER (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.78.62)(PORT=1521)) 1 1 SERVICE NAME racpdb1.racattack 1 1 SERVICE NAME racpdb2.racattack…

Read More