Future DBA – Big Data -MongoDB 2

In our earlier blog we discussed an introduction to MongoDB. so, how is MongoDB is into BigData, MongoDB has a...

Upcoming Webinars: What’s New in SSRS and MDS 2016

I’ll be delivering two webinars for MSSQLTips.com in the coming months. The first one is about the – amazing – new features...

SQL 2016 SSMS memory leak?

Has SSMS (SQL Server Management Studio) been crashing on you? Have you been getting Out of Memory messages when attempting...

Detaching corrupt databases

Question – Can you detach a corrupt database? Answer – IT DEPENDS! More specifically it depends on the SQL Server version. SQL...

PowerShell: Extending Modules – System Parameter measurement

The Microsoft Technet Guru Award  (August 2016) winning article  – Silver
PowerShell: Extending Modules – System Parameter measurement

PowerShell: Extending Modules – System Parameter measurement

Abstract
The...

Rename a Server with PowerShell

I’m sure many people are experimenting with VMs and SQL Server. If you’re like me, many of you just default...

Correlated Datetime Columns

SQL Server is a deep and complex product. There’s always more to learn. For example, I had never heard of...

Mastering Index – Clustered Index

This article is the part of series Mastering Index, in this particular article we will be exploring Clustered Index. Take...

Becoming a Microsoft MVP

I was awarded the Microsoft MVP (data platform) award on Saturday.
On the four days a year (one per quarter) when...

Future DBA – Big Data -MongoDB 1

We have discussed hadoop and its HDFS management tools for big data system, which works horizontal scaling for data distribution...