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

53 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

13 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

98 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

384 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

80 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

Catching Up On SQLOrlando

Advice I Like: Pyramid Schemes

Using Prompt AI for a Travel Data Analysis

Forums

Switch partition: NULL boundary id

Minimally Viable Security

Encoding NULL

Question of the Day

Encoding NULL