Infrastructure at your Service

Category

Database Administration & Monitoring

Microsoft Team

Columnstore index rebuild cannot start

By | Database Administration & Monitoring | No Comments

A couple of weeks ago, I was charged to migrate an SQL Server datawarehouse environment to a more recent version of SQL Server (from 2005 to 2012 in my case). After discussing with my customer we decided to benefit from the nonclustered columnstore index feature to improve reporting queries performance directly executed against the concerned database. So the implementation was successful and we included an additional job that consists in disabling as well as rebuilding…

Read More
Stéphane Savorgnano

SCOM: Creation of a group in order to subscribe to alerts

By | Database Administration & Monitoring, Technology Survey | No Comments

I am currently managing at one of my customer a monitoring project that concerns SQL Server instances and SCOM (System Center Operation Manager). The project includes many instances, more or less 50, divided in two environment (Production and Test) and different versions of SQL Server as 2008, 2012 and 2014. The defined target was to create two groups of instances, respectively Production and Test, in order to manage differently the alert’s subscription. Let’s see how…

Read More
Clemens Bleile

Database security: Where is my critical data?

By | Database Administration & Monitoring, Database management, Oracle | 3 Comments

Last week I visited the Oracle University Event “Expert Summit 2016” in Berlin, Germany. Besides the nice location in the Adlon Kempinski hotel, close to the Brandenburger Tor, I saw very interesting presentations from Jonathan Lewis (Database Troubleshooting and Tuning) and Pete Finnigan (Oracle Database Security Audit Training). The training from Pete was about how to do a database security audit. On the first day we learned a lot about potential security holes (vulnerabilities) in…

Read More
Nathan Courtine

syspolicy_purge_history job and PowerShell ExecutionPolicy

By | Database Administration & Monitoring | No Comments

Since SQL Server 2008, Microsoft has introduced a system job called “syspolicy_purge_history”. This job is installed and enabled by default, and it contains three steps scheduled at 02:00 AM:   What is this job? And what is it for? Since SQL Server 2008, a new feature called Policy Based Management has been added. When your policies are run, the results are stored in the msdb. But without a purge mechanism, msdb will keep growing. So…

Read More
Daniel Westermann

The (almost) same sample schema for all major relational databases (3) – MySQL/MariaDB

By | Database Administration & Monitoring | No Comments

Some time ago I blogged on how to get the “Dell DVD Store Database Test Suite” installed in PostgreSQL and Oracle. This time we’ll do the same on a MariaDB instance. I have to admit here that I am not very familiar with MariaDB/MySQL so the stuff presented here for sure breaks any security best practices 🙂

Read More
Daniel Westermann

Maintenance scenarios with EDB Failover Manager (3) – Witness node

By | Database Administration & Monitoring | 2 Comments

In the last posts ( Maintenance scenarios with EDB Failover Manager (1) – Standby node , Maintenance scenarios with EDB Failover Manager (2) – Primary node ) we looked at how to perform maintenance operations on the master as well as on the standby node in a failover cluster managed by EDB Failober Manager. What is still open is how to perform maintenance operations on the witness node. So, lets go.

Read More
Daniel Westermann

Maintenance scenarios with EDB Failover Manager (2) – Primary node

By | Database Administration & Monitoring | 4 Comments

In the last post I looked at how you can do maintenance operations on the standby node when you are working in a PostgreSQL cluster protected by EDB Failover Manager. In this post I’ll look on how you can do maintenance on the primary node (better: the node where the primary instance currently runs on). This requires slightly more work and attention. Lets go.

Read More
Franck Pachot

A short glance at Attunity replicate

By | Database Administration & Monitoring | 7 Comments

By Franck Pachot . If you follow my blog, you should know that I really like Dbvisit replicate because it’s simple, robust, has good features and excellent support. But that’s not a reason to ignore other alternatives (and this is the reason of https://www.dbi-services.com/news-en/replication-event-2/). When you have heterogeneous sources (not only Oracle) there is Oracle Golden Gate with very powerful possibilities, but maybe not an easy learning curve because of lack of simple GUI and…

Read More