2010-11-30 18:10
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
Blog Directory > Internet Blogs > MyTechnoBook - Datta's Technical Notes..!! internet Blog >
Mytechnobook - Datta's Technical Notes..!! Blog
mytechnobook.blogspot.com
Tags:
surface
table
naming conventions unc
server reporting services
zoom level
tool
coding standards
design surface
conventions unc format
sql server
Dattatrey Sindol (Datta) is a software engineer and a passionate SQL Server developer. He has worked on tools like SQL Server, SSIS, SSAS, SSRS, PPS etc. Find his Technical Notes @ MyTechnoBook.
2010-11-30 17:59
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
2010-11-29 19:45
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
2010-11-29 19:45
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
2010-11-29 19:45
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
2010-11-29 19:45
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
2010-11-29 19:45
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
2010-11-29 19:45
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
2010-11-29 19:45
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
2010-11-29 19:45
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
2010-11-29 19:45
Last week I was writing a few validation scripts for some of the recent schema changes / performance tuning which we had done in our project. As part of this we had defined few indexes and m… Read More
2010-11-29 19:45
I have been using an easy approach for adding an SSIS Package to an SSIS Project for a couple of years now. But didn't get a chance to actually blog about it. Today I decided to bl… Read More
2010-11-29 19:45
Sometimes when we try to get the latest code from TFS using Get Latest Version option, it does not get us the latest changes in various scenarios. Example: When some of the files are removed… Read More
2010-11-29 19:45
You might have seen in many T-SQL scripts that some people use SELECT COUNT(*) FROM MyTable and some people use SELECT COUNT(1) FROM MyTable. Both of these return the same value and perform… Read More
2010-11-29 19:45
Here is one of the common questions asked in many interviews but unfortunately many candidates fail to answer to this question. The question is "How to find the Number of Occurrences of a Ch… Read More
2010-11-29 19:45
Writing well formatted T-SQL queries is an art and takes quite a bit of patience to do the formatting. While working with various project teams, I often advise my team members and people who… Read More
2010-11-29 19:45
The Next Version of SQL Server codenamed Denali has been released to the community (CTP1) just a couple of weeks back for evaluation & feedback. I am very much excited abo… Read More
2010-11-29 19:45
I have seen many people, even though they know what function / clause / keyword to be used for a particular T-SQL / Other type of query / operation, they don't remember the exact syntax [Inc… Read More
2010-11-29 19:45
Have you ever heard of a colored connection in SQL Server? Well, may be few but not everyone reading this blog post would have come across colored connections feature of SQL Server 2008. Let… Read More
2010-11-29 19:45
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
2010-11-29 19:45
Yesterday I came across another interesting and useful online tool for formatting T-SQL queries quickly. T-SQL Tidy is a free online tool which can format numerous lines of T-SQL code within… Read More
2010-11-29 19:45
Everyone working on SQL Server and its components (SSIS, SSAS & SSRS) would require Business Intelligence Development Studio (BIDS) which is a really cool integrated development environm… Read More
2010-11-29 19:45
Often in Reporting Applications, faster rendering of reports is very essential. Especially in case of Operational Reporting Systems with large number of concurrent users, Reporting Rendering… Read More
2010-11-29 19:45
Here is a really cool feature which not many of you would be aware of. All of us write simple SELECT * FROM queries in SQL Server Management Studio (SSMS). And many times, we copy the data t… Read More
2010-11-29 19:45
Often we take the COUNT of records in a table or many of the times all the tables in a database. We might need to get the COUNT of records in all the tables especially for validation purpose… Read More
2010-11-29 19:45
In one of the recent projects, there was a requirement to set the First Day of the Week as Start Date and Current Date as End Date for a Week Level Report. Similarly, First Day of Month &&hell…Read More
Subscribe to Mytechnobook - Datta's Technical Notes..!!
Get updates delivered right to your inbox!