HealthySQL – A Review

How well do you know the health of your SQL Servers and databases? Ever wonder about the current health or...

SQL Script to find all the triggers defined on a database or on a single table

Sometime we need to find all the triggers defined on the database. So in this case, we can use the below SQL Query:-SELECT       tbl.name as [Table Name] ...

SQL Script to find all the triggers defined on a database or on a single table

Sometime we need to find all the triggers defined on the database. So in this case, we can use the...

Connecting, Saving, Discarding, Branching, and Merging in the Big Apple

We’ve got another DLM workshop on Database Source Control taking place in New York City on August 27. It’s in...

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

Getting Started With Power BI Desktop: Installation

Power BI is becoming popular for a lot of reasons. Simply put, Power BI is “BI on your fingertips.” Companies looking to...

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

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

PASS Board Update: July 2015

I was actually travelling for most of July and some of that was on holiday with the family, the real...