Resumable Online Index Rebuild

I have been fascinated with another new feature of the upcoming SQL Server release and so I decided to blog...

Excel BI VC presents Prathy Kamasani–Power BI Dashboards for Excel Users

  Thu, Apr 27 2017 20:00 GMT Daylight Time

Power BI Dashboard within an hour for Excel users
RSVP: https://attendee.gotowebinar.com/register/8516045593703848705
Power BI Dashboard within an hour for Excel users...

Why Did Your Availability Group Creation Fail?

Availability Groups are a fantastic way to provide high availability and disaster recovery for your databases, but it isn’t exactly the easiest thing in the world to pull off...

Why Did Your Availability Group Creation Fail?

Availability Groups are a fantastic way to provide high availability and disaster recovery for your databases, but it isn’t exactly...

Excel BI VC presents Prathy Kamasani–Power BI Dashboards for Excel Users

Thu, Apr 27 2017 20:00 GMT Daylight Time
Power BI Dashboard within an hour for Excel users
RSVP:https://attendee.gotowebinar.com/register/8516045593703848705
Power BI Dashboard within an...

Installing a Visual Studio Team Services private build agent hosted On-Premises

This blog post is about a situation where I  use Visual Studio Team Services (VSTS) to build/deploy my DEMOs. Those...

Retrospective analysis of SQL Saturday South Island (#sqlsat614)

Now that SQL Saturday South Island (also known as #sqlsat614 on the Twitter) is done I thought it would be...

Columnstore Indexes – part 104 (“Batch Mode Adaptive Joins”)

Continuation from the previous 103 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is a logical continuation...

DevOps Basics– git Cloning Repos

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

SQL Database File Wise Disk Space Monitoring

As a DBA, you get alerts many times regarding the database file space issue. To address the issue, you may...