Embeded PowerBI

Execution Plan Shortcoming in Extended Events

I use Extended Events almost exclusively for capturing query metrics. They are the most consistent and lowest cost mechanism for...

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...

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...

Securing Test and Dev Environments at the SQL Privacy Summit

Redgate Software is putting on a one day SQL Privacy  Summit on May 18 in London at the Grange Tower...

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...

SQL Server 2016 – SQL Server Telemetry \ CEIP Services

CEIP (Customer Experience Improvement Program) is somethings runs from ages and almost each vendor perform it to collect product usage...

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 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...

Benefits for Veterans

Wanted to share a few things I came across recently with regards to benefits for veterans:
You can get a printed...