Hekaton Part 8 - Hash Collisions - Hash_Index_Stats DMV

Continuing from previous post , this post will discuss a few scenarios on hash collisions.
 The following "in memory" table with a hash...

Indexed views on any core SQL server edition-The video

A few months back I created a blog post showing that you can indeed create and use indexed views on...

Indexed views on any core SQL server edition-The video

A few months back I created a blog post showing that you can indeed create and use indexed views on any core SQL server edition. It has proved to...

Indexed views on any core SQL server edition–The video

A few months back I created a blog post showing that you can indeed create and use indexed views on...

SQL Saturday #453–Minnesota 2015–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...

SQL Server Encryption

Encryption is a methodology used to hide confidential information from any illegitimate user is such a way that they do...

SQL server encryption – Asymmetric Keys

In the previous blog we learnt about symmetric key encryption. We also learnt through an example how data is stored...

SQL server encryption – Certificates

In the previous blogs we saw how to encrypt data using symmetric and asymmetric keys. We saw how to use...

SQL server encryption – Symmetric Keys

In the previous blog we learnt about encryption and a brief about the SQL server option provided for data protection...

Deployed Target Metadata with PoSH

This article shows a deeper dive that will show how to expose the Deployed Target Metadata with PoSH and familiarity with this powerful tool.
Related Posts:

PowerShell to Backup XE Session...