Backup VisualSVN using PowerShell

Quick and easy backup for VisualSVN.  Wraps the svnadmin.exe and performs a hotcopy of all repositories in the $source_path, dumping them to the $backup_path [crayon-5c98d5a77e81c224584330/]  

Embeded PowerBI

SQL Server Advanced Aggregations Part 1 Grouping Sets

This post is part 1 of a 3 part series…
Part 1 Grouping SetsPart 2 ROLLUP and CUBEPart 3 GROUPING and...

SQL Ops Studio extension development : Starting an adventure

I’ve been in technology a long, long time (more than 2 decades). Over the years, I learned Access which took...

180 – Is It Time For A Turnaround?

What needs to change? The challenge to explore is are there things in your current day to day that needs...

SQL Server database Backup and Restore strategies

One of the most important roles of a database administrator is to constantly protect the integrity of the databases and...

Embeded PowerBI

How to find out whether your database is transactional, analytical or hybrid?

If you are a DBA, especially Infrastructure DBA, Production DBA or Operations DBA then you don't necessarily always know what...

dbachecks – Going parallel – Cut off your execution times

On one of the last clients I have worked, I have implemented dbachecks in order to get the state of...

Gather Always On Configuration using a DMV query

If you were like me, you would know your AG configuration by heart. However, what if you get busy with...