A really simple bug with SSMS

If you’re a long time IT professional or an occasional user of high or even low tech software you’ll know...

An open letter to the PASS community

PASS is our community.

It may sound a little cliche in this time of election propaganda in the US, but it’s...

Configuring Passwordless PowerShell Remoting over SSH

Open Source PowerShell has been on fire, getting tons of community support and really making people think about what’s to come with a single language to manage a heterogenous...

Configuring Passwordless PowerShell Remoting over SSH

Open Source PowerShell has been on fire, getting tons of community support and really making people think about what’s to...

Connecting to Twitter with R and RStudio

Social Media and Analytics is always an interesting combination. Twitter has an API that you can so you can connect...

DBCC CLONEDATABASE and sensitive data

Just over 2 months ago Service Pack 2 for SQL server 2014 was released. Included in this Service Pack is...

Query Store and Plan Forcing: What Do You Use It For

If you’re working with Azure SQL Database or you’ve moved into SQL Server 2016, one of the biggest new tools...

SQL Server Execution Plan Operator – Table Scan

In my previous blog we discussed about the different format of SQL Server execution plan. Now in upcoming blogs we...

This Week In Data – Episode 6 (Why Companies are Choosing Power BI)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...

Future DBA – Hive Big Data 2

In our last blog on Future DBA, we discussed on HADOOP -HDFS system. how as we know HDFS management is...