31. July 2012 00:06
Visual Studio 2012 RC packs many new improvements from the Setup to the looks and the underlying core features. The new Setup is said to be 20% faster based on the customization you choose.
Lot of work has been done on the overall UX to give even more friendlier experience. Let's start exploring the new IDE to see few areas where we frequently spend time:
The New Project screen. An empty ASP.NET Web Application now really means empty. You won't get basic start-up code for your application.
An Empty Web Application comes with no default Web Page but only Web.Config file. If you want few lines of start-up code, you can always choose a Basic Template:
The Solution Explorer is one such area where tweaks have been done to make it light and clutter free. Things that don't directly affect the Solution View or the Project Hierarchy have been removed from the Solution Explorer. Enhanced Search has been added to search for any text or item in the Solution Explorer.
The Solution Explorer also contains Active Sync option to easily navigate to the location of the opened document. Click on file in the Solution Explorer and select the Preview option on top of the Solution Explorer. It opens the code of the file for you to preview. Once the Preview icon is selected and marked, you can just keep clicking other files in the Solution Explorer to instantly look the code of the file.
Now lets take a look at the default page of a basic Web Froms Application. You will notice a fresh new template to start with:
Now open the Mark-Up, i.e., the source of Default.aspx. You will notice improvements in code manageability and readability. Just click on any line of the source to notice a gray border around that line:
The new HTML editor offers full support for HTML5 elements and snippets. The CSS editor offers full support for CSS3, including support for CSS hacks and snippets for vendor-specific extensions to CSS.
15. July 2012 12:43
SQL Server 2012 brings some of the most desired enhancements in the Management Studio to simplify manageability.
(1) The new SQL Server Management Studio is built on Visual Studio 2012. As it opens, you soon recognize the familiar dark blue theme of Visual Studio 2010.
(2) You can drag and move out Query Window from the main work area:
It also has dual monitor support. You can move out a Query Window to another monitor or outside the main IDE.
(3) You can even drag out the ToolBox from the main IDE and place it elsewhere on the desktop or on another monitor.
(4) Being based on Visual Studio, SSMS brings the same Clipboard Buffer feature of Visual Studio 2010. You can cycle through buffer text by holding down the SHIFT key and pressing CTRL+V.
(5) Another interesting feature is Insert Snippet which you can find on menu via Edit -> IntelliSense. It allows you to inject variety of code snippets onto your Query Window:
Above I selected Create Procedure Basic Template to inject stored procedure code. It even provides you with two parameters to start with. You can always remove or add parameters according to your need.
Similarly, you can inject many other type of code snippets like: Function, Index, Table, View etc. There are even more enhancements which are outside the scope of this post.
11. July 2012 12:54
If you are coming from Crystal Reports background then you must be aware of a property called Suppress if 0 in Crystal Reports. By default, this property is disabled resulting in zero values being displayed on your report. When checked, all the zero values are suppressed by replacing 0 with a blank space.
SQL Server Reporting Services (SSRS) is quite young when compared to Crystal Reports. It is not as powerful as Crystal Reports but it definitely bundles simplicity and seamless integration with SQL Server data and Visual Studio.
Here I show you how to implement Suppress if 0 functionality in SSRS. In my example I have used SQL Server 2008 Reporting Services. Before starting let's see how the report looks when opened in browser before suppressing zero values:
To suppress zero values, go to Business Intelligence Development Studio and open the report design. My report design looks like this: More...