New Learning Tree 1 Day SQL Server Training

Learning Tree has recently introduced some new 1 day virtual training events There is range of courses and subjects for...

Power BI Semantic Model Supports Many-to-Many Relationships

Is is possible to duplicate the same many-to-many relationship behavior in VertiPaq that we have in SSAS multidimensional? Since Tabular...

Power BI Semantic Model Supports Many-to-Many Relationships

Is is possible to duplicate the same many-to-many relationship behavior in VertiPaq that we have in SSAS multidimensional? Since Tabular...

Script to find the Fragmentation of indexes

Below is the script to find the fragmentation of the indexes created on a database.

SELECT OBJECT_NAME(OBJECT_ID), index_id,index_type_desc,index_level,
avg_fragmentation_in_percent,avg_page_space_used_in_percent,page_count
FROM sys.dm_db_index_physical_stats (DB_ID( N'Database name')...

Improve Your Wifi Connection Speed with the Use of a Simple 6’/2m USB Cable Extension

For years now we have dropped using Cat6 at home for Wifi,
since the Cat5e cables in the house we moved...

Script to find all the running queries/jobs on the Database Server

Below is the query to find out all the Queries and their details like SSID etc. running on the SQL...

A Very Happy New 2015

Wishing you a very happy new year to you. May this year bring success & happiness in your life. Reference : Rohit Garg (http://mssqlfun.com/) You can find and follow...

How to pass Microsoft Certification Exams

Many times I was asked how to pass Microsoft certifications and how difficult it is. In my point of view,...

A Very Happy New 2015

Wishing you a very happy new year to you.
May this year bring success & happiness in your life.
Reference : Rohit Garg (http://mssqlfun.com/)
You...

Clustered Columnstore Indexes – part 46 (“DateTime compression and performance”)

Continuation from the previous 45 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
At the last SQLPort event in December 2014, I have listened to...