My SQL Server Development Team Maturity Levels

A teams maturity shows in its choice of tools.
I have seen quite a few different development teams in wildly different environments and the single fact that really stands out...

My SQL Server Development Team Maturity Levels

A teams maturity shows in its choice of tools.
I have seen quite a few different development teams in wildly different...

SQL Doc by RedGate

I recently was on a call where a technical unit indicated they did not receive any form of documentation around...

SQL Server 2016 enhancements – Truncate Table and Table Partitioning

The idea behind this article is to discuss the importance and the implication of SQL Partition and understand the truncate...

SSMS Tips: Copy Full Path

When you right click on a tab you’ll see a number of different options. You can set up new horizontal...

Vnext – Its SQL Server 2017

Yes thats true, SQL Server New version will be release this year and call it “SQL Server 2017” where sql can...

Do Not Trust My GitHub Projects

Aloha!
Recently I’ve revisited one of my GitHub projects, TurboLogShip. I’ve been wanted to write a presentation around what it does...

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

Resumable Online Index Rebuild

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

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