Columnstore Indexes – part 82 (“Extended Events in SQL Server 2016”)

Continuation from the previous 81 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Previously, I have blogged about about the...

SQL Saturday #492 Follow Up – A Window into Your Data

Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and...

What's New in SQL Server 2016 Release Candidate 3

Microsoft announced SQL Server 2016 Release Candidate 3 Evaluations

Benefits of SQL Server 2016 Release candidate 3:
Enhanced in-memory performance provide up...

Community work

I have been really busy lately with articles, podcasts and so forth. Lately I have been working on 2 public...

Sarpedon Quality Lab presenting SQL Server 2016 In-Memory and Security Features in Arabia at SQL Gulf 3

?????

(“MARR-hah-bah”, Arabic: Hello)
This year takes me to yet another part of the world:
I have been invited to speak at THE...

Test

SQL 2016 Temporal Tables By Example

Brief Description
Temporal tables allow automated change tracking of a table directly in to a history table which can be queried...

Goodness-of-Fit Testing with SQL Server Part 7.2: The Lilliefors Test

By Steve Bolton
…………Since I’m teaching myself as I go in this series of self-tutorials, I often have only a vague...

MongoDB – How to Copy Database

Using copydb
Run the copydb under admin database with from,to, host parameters
>use admin
switched to db admin
> db.runCommand({ copydb: 1, fromdb: “test”,...

Basic SQLCMD–#SQLNewBlogger

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