Columnstore Indexes – part 97 (“Working with Strings”)

Continuation from the previous 96 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
After many years of using & fighting the...

Availability Group on SQL Server 2016

The Challenge
One of our clients in the gaming industry wanted to set up a high availability solution in their data...

Improve performance by replacing temp tables with memory optimized tables - Part 1

There are many cases where you will be using temp tables, and many of us are trying to seek for...

Write-Host || Cannot invoke this function because the current host does not implement it

Issue: While running powershell in SQL job step, I am getting below error: –
A job step received an error at...

My backup and SLEEP_BPOOL_FLUSH

I noticed that my backup was taking longer than usual. I went to Perfmon to look at some counters, more...

SQL and the other technologies

I was curious about how the SQL language stands with the other technologies. Next table shows it. The data is taken from StackOverflow.   Charted data looks like in...

SQL and the other technologies

I was curious about how the SQL language stands with the other technologies. Next table shows it. The data is taken from StackOverflow.   Charted data looks like in...

SQL and the other technologies

I was curious about how the SQL language stands with the other technologies. Next table shows it. The data is...

JSON Support Is The Best New Developer Feature in SQL 2016 — Part 2: Creating JSON

This is the second article in my series about learning how to use SQL Server 2016's new JSON functions. If you haven't already, you can read Part 1?—?Parsing JSON.

Part...

Disabling #sqlprompt Formatting

I love SQL Prompt, especially the new formatting engine. However, it’s not perfect, and there are times I don’t want...