Manish Kumar

Manish is a Data warehouse/Business Intelligence Solution expert. He has a Master’s degree in Computer Applications with 11+ years of experience resulting from associations with organizations such as Mahindra Satyam, Verizon, ITC Infotech and Aditi Technologies. While associated with these companies, he has had the opportunity to work with well-known names such as Microsoft (R&D, AdCenter India) and Danske Bank Denmark. He is MCITP (SQL 2008 Business Intelligence Developer) certified and his skills and expertise include Design and Architecture definition for BI/DW solutions. He has successfully implemented various BI & DW projects with coverage across ETL, Data Modeling, OLAP, Data Analysis, Data Quality, Analytical Reporting, Data Mining, Dash Board design and implementation as well in fine tuning complex queries and databases.

Manish’s hobbies include writing and reading Hindi poems, cooking, hiking , sports, philanthropy, sharing technical knowledge and listening to music.

All authors

RANKING Function in plain SQL

by Manish Kumar

SQL & BI

Below examples will show that we can still write a pure sql query for RANK, DENSE_RANK and ROW_NUMBER without using...

2012-06-11

321 reads

RANKING Function in plain SQL

by Manish Kumar

SQL & BI

Below examples will show that we can still write a pure sql query for RANK, DENSE_RANK and ROW_NUMBER without using RANK() function.DECLARE @StudentScore TABLE(StudentName VARCHAR(1),StudentScore INT)INSERT @StudentScore VALUES ('A',85),...

2012-06-11

56 reads

All about Kerberos authentication

by Manish Kumar

SQL & BI

http://download.microsoft.com/download/B/E/1/BE1AABB3-6ED8-4C3C-AF91-448AB733B1AF/SSRSKerberos.docx

2012-05-17

15 reads

All about Kerberos authentication

by Manish Kumar

SQL & BI

http://download.microsoft.com/download/B/E/1/BE1AABB3-6ED8-4C3C-AF91-448AB733B1AF/SSRSKerberos.docx

2012-05-16

218 reads

OFFSET and FETCH Query Options in SQL Server 2012

by Manish Kumar

SQL & BI

If you are tired of implementing query paging solution in old classic style than try query hints OFFSET & FETCH newly introduced in SQL Server 2012. You might have...

2012-05-03

103 reads

OFFSET and FETCH Query Options in SQL Server 2012

by Manish Kumar

SQL & BI

If you are tired of implementing query paging solution in old classic style than try query hints OFFSET & FETCH newly...

2012-05-03

540 reads

SQL Azure Federation

by Manish Kumar

SQL & BI

What is Federation?
Federation is a database object like other objects such as tables, views, stored procedures or triggers.It is also known as...

2012-04-25

838 reads

SQL Azure Federation

by Manish Kumar

SQL & BI

What is Federation?

Federation is a database object like other objects such as tables, views, stored procedures or triggers.
It is also known as Sharding.
There can be multiple federations in a database.
It is...

2012-04-25

390 reads

CONCAT in SQL 2012

by Manish Kumar

SQL & BI

SQL Server 2012 introduces a brand new string function called CONCAT(). CONCAT() string function allows you to concatenate up to 255 string or variable values in to one single...

2012-04-20

83 reads

CONCAT in SQL 2012

by Manish Kumar

SQL & BI

SQL Server 2012 introduces a brand new string function called CONCAT(). CONCAT() string function allows you to concatenate up to...

2012-04-19

464 reads

All authors

Manish Kumar

RANKING Function in plain SQL

RANKING Function in plain SQL

All about Kerberos authentication

All about Kerberos authentication

OFFSET and FETCH Query Options in SQL Server 2012

OFFSET and FETCH Query Options in SQL Server 2012

SQL Azure Federation

SQL Azure Federation

CONCAT in SQL 2012

CONCAT in SQL 2012

Blogs

T-SQL Tuesday #198–Change Detection

Redgate and Rome

Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database

Forums

Permissions Removal When Changing Object Schema

SSRS Is Dead. Here Are Your Real Options

The Distance Metric

Question of the Day

The Distance Metric