Getting and storing a high precision datetime

Earlier today I was working on a project where I was recording some time stamps. In order to get as...

Interview question - Is Clustered index on column with duplicate values possible?

Through this article, we are going to discuss three important interview questions of SQL which are given below:-
 1) Can we create clustered index on a column containing duplicate values?

 2) Can we create...

Interview question - Is Clustered index on column with duplicate values possible?

Through this article, we are going to discuss three important interview questions of SQL which are given below:-

 1) Can we...

Hekaton Part 3: Table Creation and Parameters

Part of a Series on "Hekaton". Refer below for previous posts

Introduction to Hekaton - Part 1Creating a Hekaton Database - Part 2
Having...

How easy or difficult to write dynamic SQL ? TIP#110

This is one of the challenge for most of the developer to write dynamic SQL. Generally we follow the approach...

Columnstore Indexes – part 62 (“Row Groups Trimming”)

Continuation from the previous 61 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have spoken a lot of times...

oPASS & MagicPASS Meeting Tonight

David Pless is presenting:
Query Store is a new feature in SQL Server 2016, and is also available in Azure SQL...

Here’s the New #Excel 2016 Chart Types!

The Office 2016 Public Preview is now available for download! Included in the preview of Excel 2016 are a handful...

Hadoop and Microsoft

In my Introduction to Hadoop I talked about the basics of Hadoop.  In this post, I wanted to cover some of...

Please Welcome Our New Certified SQL Server DBA’s!

Today we celebrated the last session of one of our Become a SQL Server DBA classes. This course takes people...