Tag Archives: feedback

You can now create nonclustered indexes on the Clustered Columnstore index

By | July 16, 2015

This post is to correct a mistake I made in my previous post on Updateable Non Clustered Columnstore index in SQL 2016; in that post I mentioned that Clustered Columnstore index doesn’t allow other indexes to be create on the table. This is true and false. Let me explain. If your using SSMS to create… Read More »

SQL 2016- Live Query Stats

By | July 16, 2015

I am a bit confused about this feature so I thought I would post about it to get feedback on its usage in SQL 2016. With SQL 2016 there is a feature called Live Query Stats being introduced. As its name suggests it provides details on the actual tasks being executed in real time. What… Read More »

Uninstalling SQL Server

By | April 7, 2015

I just realized today that I had the CTP for sql 2014 still installed on my laptop today. While trying to uninstall it from control panel (time period had expired by the way) I got the error below: The Operating System on this computer does not meet the minimum requirement Naturally being a CTP I… Read More »

Video on how to use Schema Compare Option available in SSDT

By | March 21, 2015

In this video we cover how to use the Schema compare option within MS SQL Server Data Tools the Visual Studio IDE that comes as the replacement for BIDS. The video covers how to create a project followed by making changes and detecting the change and then how to sync or merge the changes. http://youtu.be/rNL3Ieev2CQ… Read More »


By | January 27, 2015

Some feedback from the training What did you like most about the training? Knowledge on SQL Trainers end to end knowledge about the tool. Explained concepts with hands on. Came to know topic didnt know earlier. Trainer was able to explain the topics covered in training. Performance improvement only by basic stuff(e.g. index) Trainer is… Read More »

SQL 2012 Administration Societe Generale – JAN

By | January 27, 2015

Some feedback from the training   What did you like most about the training ?   Trainer’s skill and experience in technology Skilled knowledge pool of the Trainer

SQL 2014 ADMIN, DEV – Wells Fargo – JAN

By | January 27, 2015

Some feedback from the training What did you like most about the training?   -Quite impressed by the way Jayant taught Performance tuning -In depth explanation of all the key concepts. -Given real time examples wherever needed which helps understanding complete picture

Bangalore – Bengaluru Slowly Changing Dimensions

By | November 1, 2014

I would like to introduce Type 6 EBS Modified SCD and get your feedback. I couldn’t find any documentation explaining this approach so I guess this is a first, please prove me wrong. So it’s finally happened Bangalore is now officially Bengaluru. Naturally this means a lot of the changes on the road and Highways… Read More »

Create a 5 star rating indicator using SSRS

By | July 7, 2014

Today we are going to create a 5 star rating indicator in SSRS. Indicators are available in SQL Server 2008 R2 and above and provide a quick way to share information on the overall status of a task. It has a number of useful pictorial representations such as stars, traffic light, coloured boxes and more.… Read More »

5 Mary series, SSIS using TSQL in MSBI

By | June 20, 2014

An All new video on using TSQL task in SSIS to run a query and fetch data from the database and assign it to a table. All part of the Mary series of videos. We are following a new pattern with these videos, trying to keep the short and more focused around a single task.… Read More »