Kevin Bronsdijk’s Blog

Microsoft Azure - SQL Server - PowerShell - Automaton - DevOps

SQL Database Integrity Reports

SQL Database Integrity Reports

Validating database integrity on a regular basis is a fundamental task that is often forgotten by the accidental DBA. Fortunately SQL Server database corruption issues aren’t very common, however finding out that you have been backing up a corrupt database for weeks might be somewhat hard to explain to the business.

Read More →

Move Azure VMs between datacenters

Move Azure VMs between datacenters

Recently I had to move a couple of Windows Azures Virtual Machines from West Europe to Southeast Asia. This wasn’t as easy as expected, so therefore i’m sharing the steps on how to move a Virtual Machine to a different data center.

Read More →

Oracle RightNow CX Resources

Oracle RightNow CX Resources (Quick start)

Recently, I’ve been working with Oracle RightNow CX, and I must say I’m impressed. Now, the individual components aren’t that significant. There are better incident management, survey and email marketing systems on the market. However, the suite as a whole has a lot of potential.

Read More →

Tridion DB – Poor performance after upgrade

Tridion DB

Probably one of the most common issues customers run into after completing the upgrade is performance degradation. This post covers how you can identify and solve SQL Server related issues after upgrading to a newer version.

Read More →

sp_what: Seek and ye shall find

SQL Server SP_what

On-site performance tuning analysis can be as rewarding as it is frustrating. There are some aspects you just can’t control; Ranting managers or dealing with a passive DBA, which often stands behind you with popcorn and drinks. Fortunately, you can prepare your scripts in advance based as i did based on prior leanings.

Read More →