SSIS in Denali comes with a whole bunch of new and exciting features both from an arthitectural/development standpoint and also from a usability standpoint. Here is a really cool feature int… Read More
SQL Server Management Studio (SSMS) in Denali (CTP1) has got a makeover and is now based on Visual Studio 2010 Shell. This will enable us to utilize lot of great features available in Visual… Read More
Often while working with T-SQL we create copies of tables as a backup of the original/base table so that we can make changes to the data in the original/base table for testing purposes, and… Read More
We create Flow Charts, Architecture Diagrams, Diagrams for visual representation of Processes and Concepts etc. There are various tools in the market for different types of diagrams with var… Read More
Today I was working on an SSRS report for one of our clients and came across a specific formatting requirement around formatting Minutes as HH:MM. Browsed a little bit but could not get it w… Read More
Few of my colleagues and friends have been asking me for a while to write something on the differences between SQL Server Reporting Services versions 2005 and 2008. Especially when they were… Read More
We see a lots of articles on the net and lots of documents are prepared by different project teams in the industry to present / capture the conventions, coding standards etc. However in real… Read More
Today, 1st Feb 2010 is a very special day for me. Guess why ? It's my B'day today!!!Happy B'day to meHappy B'day to meHappy B'day dear Datta!!!Happy B'day to me :) Today is very special day… Read More
Recently I started looking into one of the great features of Reporting Services (SSRS 2008) and that is Subscriptions. A Subscription is a feature in SSRS to deliver a report to the users at… Read More
Often people struggle to get a RANDOM record from a table in SQL Server. There is a function in SQL Server RAND() which generates Random Numbers. However this function does not work as expec… Read More
Subscribe to Mytechnobook - Datta's Technical Notes..!!
Get updates delivered right to your inbox!