Columnstore Indexes – part 63 (“Parallel Data Insertion”)

Continuation from the previous 62 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Data Loading is one of the most...

Create a SQL Azure Database–Old Portal

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

Adding a VLDB database to an SQL Server Availability Group

Recently, I was tasked with making an 60TB database highly available by adding it to an availability group. The following,...

Monitoring SQL Server on a budget

Monitoring SQL Server on a budget

Cheap ain’t easy
There’s a lot of tools out there, and very few that are polished,...

Nesting Aggregates with Window Functions

Recenty I was writing an article for MSSQLTips where I had to create a treemap (it will be published soon)....

Studying for the 70-462 Exam: Database Mirroring

If we could take a picture of the HA solutions currently offered in SQL Server, database mirroring would be the...

Monitoring SQL Server on a budget

Monitoring SQL Server on a budget

Cheap ain’t easy
There’s a lot of tools out there, and very few that are polished,...

Are you Ready to Use Power BI?

What! NO? Get with it, my friend.  Power BI is for everyone.  All the kids are doing it… not to...

Are you Ready to Use Power BI?

What! NO? Get with it, my friend.  Power BI is for everyone.  All the kids are doing it… not to...

Zero to hero in SSIS (SQL SERVER Integration Services) TIP #110

Recently, Many friends of mine are interested in learning SSIS so , I thought to write some blogs which might help...