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 with Packt Publishing which was published on 28th Oct 2013.

This book does not require readers to have advance knowledge of T-SQL, but the readers are expected to know how to write basic aggregates in T-SQL. SQL Server Reporting Services architecture and any pertinent information are not included in this book. Knowing how data sources and datasets work in advance will greatly help you to progress through the tutorials quickly. This book is perfect for those new to SQL Server Reporting Services. Other SQL Server users, such as database administrators, who are getting involved in report development can greatly benefit from the fast-paced style of this tutorial book.

I would request you all to read this book and provide your valuable feedback. :)

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) to develop SSIS packages. In BIDS when we click on Toolbox icon which opens the SSIS Toolbox window whereas in SSDT which opens the user control toolbox as shown below:

So, how to get the SSIS toolbox in SSDT?  There are two ways to get the toolbox, one is by clicking on the icon as shown below or selecting the menu from View -> Other Windows -> SSIS Toolbox

Hope you got the SSIS toolbox in SSDT J