Why You Should Care About Microsoft APS and Azure SQL Data Warehouse

Last week, I gave a presentation about SQL Server’s data warehouse capabilities, and specifically about APS (Analytics Platform System) and...

I don't use the Visual Studio SSDT Publish

I see questions pretty regularly on stack overflow and the ssdt msdn forum that is some variation on "I am...

I dont use the Visual Studio SSDT Publish

I see questions pretty regularly on stack overflow and the ssdt msdn forum that is some variation on “I am...

I dont use the Visual Studio SSDT Publish

I see questions pretty regularly on stack overflow and the ssdt msdn forum that is some variation on “I am...

I dont use the Visual Studio SSDT Publish

I see questions pretty regularly on stack overflow and the ssdt msdn forum that is some variation on “I am doing a publish through visual studio and it doesn't...

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