sivasqlbi.blogspot.com
Sivakumar Vellingiri's Blog: SSIS : SSIS toolbox is not visible in SQL Server Data Tools (SSDT)
http://sivasqlbi.blogspot.com/2013/09/ssis-ssis-toolbox-is-not-visible-in-sql.html
Dedicated blog for SQL Server, Business Intelligence and Data Warehousing. Tuesday, September 10, 2013. SSIS : SSIS toolbox is not visible in SQL Server Data Tools (SSDT). Yesterday, I was asked by one of my reader that he is not able to see the toolbox in SSIS 2012. I have provided the way of getting it and thought of sharing which may help you guys. Previous to SQL Server Data Tools (SSDT). We were using Business Intelligence Development Studio (BIDS). So, how to get the SSIS toolbox in SSDT? February ...
sivasqlbi.blogspot.com
Sivakumar Vellingiri's Blog: May 2012
http://sivasqlbi.blogspot.com/2012_05_01_archive.html
Dedicated blog for SQL Server, Business Intelligence and Data Warehousing. Friday, May 18, 2012. SQL Server : Find out Nth highest salary of employee using RANK() or DENSE RANK() functions in SQL Server. This article is going to hash out some interesting question which is also one of the favorite questions asked in SQL Server interviews. Hope, you guys got it. J. Yeap, you are right that is “ Find out N. Highest salary of employee. This can be achieved very easily by using RANK. Now, let us find out the 4.
sivasqlbi.blogspot.com
Sivakumar Vellingiri's Blog: SQL Server : Rules of Database Normalization (Poster)
http://sivasqlbi.blogspot.com/2014/02/sql-server-rules-of-database.html
Dedicated blog for SQL Server, Business Intelligence and Data Warehousing. Monday, February 17, 2014. SQL Server : Rules of Database Normalization (Poster). I was going through an article written by Joe Celko in www.sqlservercentral.com. And found very interesting poster related to database normalization rules. Hope, this poster may help new SQL folks to understand the normalization. :). Subscribe to: Post Comments (Atom). The opinions expressed here represent my own and not those of my employer.
sivasqlbi.blogspot.com
Sivakumar Vellingiri's Blog: December 2010
http://sivasqlbi.blogspot.com/2010_12_01_archive.html
Dedicated blog for SQL Server, Business Intelligence and Data Warehousing. Wednesday, December 8, 2010. SQL Server : Situation to use GROUP BY ALL. An interesting question was raised by one of the attendee in my “SQL Server – Performance Tuning”. Ie) Where GROUP BY ALL. Can be used in efficient manner? First of all, what is GROUP BY ALL. Is similar to GROUP BY. But which includes all groups and result sets, even those that do not have any rows that meet the search condition specified in the WHERE. INSERT...
sivasqlbi.blogspot.com
Sivakumar Vellingiri's Blog: December 2013
http://sivasqlbi.blogspot.com/2013_12_01_archive.html
Dedicated blog for SQL Server, Business Intelligence and Data Warehousing. Tuesday, December 10, 2013. SSRS : I have officially reviewed SQL Server 2012 Reporting Services Blueprints book for Packt Publishing. Folks, I have good news for you all! I have opted some time out of my busy schedule for officially reviewing the book on SQL Server 2012 Reporting Services Blueprints. Which was published on 28th Oct 2013. I would request you all to read this book and provide your valuable feedback. :). Microsoft C...
sivasqlbi.blogspot.com
Sivakumar Vellingiri's Blog: April 2010
http://sivasqlbi.blogspot.com/2010_04_01_archive.html
Dedicated blog for SQL Server, Business Intelligence and Data Warehousing. Wednesday, April 28, 2010. SQL Server : Displaying records with Sequential Numbering / Group wise Sequential Number / specific range of records in SQL Server using ROW NUMBER() function. One of my SQL buddy called yesterday and asked me, how to display the records with Serial Numbers in SQL Server. I gave the solution over phone which I want to share with you guys too. :). Assume that we have a table with the following records.
SOCIAL ENGAGEMENT