TSQL– Search for Strings in Object Definitions

I have been  working nn an environment  that had multiple copies of a database on the same SQL server instance....

Configure SQL Server Database Mirroring: Step By Step

Database Mirroring in SQL Server is deployed as a method to increase the availability of a SQL Server database in...

MongoDB -Calculating Collection Size

Calculating Collection Size
We can get the size of a collections by using the shell’s functions
db.collection.dataSize(): Returns data size in bytes...

Partitioning and filegroup restores

I’ve been playing around with partitioning quite a lot recently and wanted to write a quick post about how it...

Power BI Embedded is here

The announcement of Power BI Embedded came last week during Microsoft’s Build Conference and now enables software vendors or anyone...

Scaling Azure VM’s

There are so many benefits to the cloud, but one of the major features is the ease of use in...

SQL Server PerfMon Counters Not Listed in dm_os_performance_counters

Had an issue with a new Azure VM install of SQL Server, but have had this issue in other, older...

SQL Server Service Broker – Conversation Architecture

This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging...

SQLSaturday (Silicon Valley) Detect Worst Performing SQL Queries During Peak Hour

Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them is a single most efficient technique to fix unexpected...

SQLSaturday (Silicon Valley) Detect Worst Performing SQL Queries During Peak Hour