Database Administration & Monitoring

SQL Server 2016 AlwaysOn: Direct seeding and backup considerations

As promised in my prior blog post, we’ll talk now about direct seeding feature and backups. We found an interesting LIMIT_CONCURRENT_BACKUPS value for current state of the hadr_automatic_seeding_state_transition event. As said last time, this value is(…)

Set the SQL Native Client Default Port with PowerShell

I written an article about “SQL Server 2012: Configuring your TCP Port via PowerShell” and I received a question from PaulJ: “How do you set the port for(…)

Nulls in composite keys

By Franck Pachot . Comparison of NULL can be misleading and it's even worse for unique constraint validation. Having partial nulls in a composite key can be tricky because the SQL ANSI specification is not very easy to understand, and(…)

SharePlex Compare and Repair commands

By Mouhamadou Diaw Reading Franck Pachot blog about comparing source and target in a Dbvisit replication (http://dbi-services.com/blog/compare-source-and-target-in-a-dbvisit-replication/), I decide to write a small article about how we can do same thing with SharePlex. Indeed SharePlex provides built-in(…)

Oracle Multitenant feature name

By Franck Pachot . We all know what is the multitenant option: a container database (CDB) with multiple user pluggable databases (PDB). This requires Enterprise Edition plus option. But you can use the same architecture without the option and even(…)

SQL Server 2016 AlwaysOn: Direct seeding and performance considerations

This blog post follows the previous one about new direct seeding feature shipped with SQL Server 2016. As a reminder, I had some doubts about using direct seeding with large databases because log stream is not(…)

Compare source and target in a Dbvisit replication

By Franck Pachot . You've setup a logical replication, and you trust it. But before the target goes into production, it will be safer to compare source and target. At least count the number of rows. But tables are continuously(…)

Script to suggest FK indexes

By Franck Pachot . In Oracle, when the referenced key is deleted (by delete on parent table, or update on the referenced columns) the child tables(s) are locked to prevent any concurrent insert that may reference the old key. This(…)

GoldenGate 12.2 – Installation of the monitoring agent

As described in my last post, GoldenGate Studio requires the monitor agent on each GoldenGate instance. The goal of this agent is to allow GoldenGate Studio to interact with GoldenGate, for example, to(…)

SQL Server 2016: Always Encrypted – part 2

In my last blog post about SQL Server 2016 Always Encrypted, here, I showed how to use this new functionality but also that you have to separate the different execution context with an Application server, a database server and(…)