• prakasht

    Limits the number of records per page in SSRS 2012.

    • 5 Comments
    Hello folks, While working on the requirement to fix the number of records per page in the report, I found that there is no such out of the box (OOB) property in SSRS 2012 to do so, However this can be achieved by some workarounds :). Below are the...
  • prakasht

    What’s new in SQL Server 2014 (CTP1)?

    • 2 Comments
    The release of SQL Server 2014 (CTP1) has brought good amount of new features and enhancements. Some of the notable features are presented below. Database Engine Enhancement: In-Memory OLTP for ~10X performance gains by moving most used tables...
  • prakasht

    Difference between Direct casting, is and as operator in C#

    • 1 Comments
    Hi guys, below are the available ways in C# when you cast one data type to another. Direct casting Direct cast is most common way of casting one type to another, however it yields exception if casting can’t be done. Below is the example...
  • prakasht

    Efficiently remove duplicates in dataset

    • 1 Comments
    Hi folks, Remember, the pain of removing duplicates in fetched dataset by looping, comparing etc. it can be handled easily by using DataView.ToTable Method. The syntax is below. DataView.ToTable(bool distinct, string[] columnNames) distinct...
  • prakasht

    SQL Server Management Tools

    • 1 Comments
    Sometimes we may feel that for any monitoring or R&D, which tool to go far? Here is a handy reference for different tools available in Sql Server 2008. Dynamic Management Views and Functions: Dynamic management views and functions return server...
  • prakasht

    Data mining algorithms and their use cases

    • 0 Comments
    Hi folks, I have compiled the comparisons and use case of OOB algorithms available within SSAS/DM for handy reference. Name Description Type Use cases Parent algorithm Supported Values ...
  • prakasht

    Row Versioning based Isolation levels in Sql Server

    • 0 Comments
    Row Versioning based Isolation levels are very useful in reducing blocking. Which are.. • Read Committed (default) Isolation level with READ_COMMITTED_SNAPSHOT database option is ON. • Snapshot Isolation level with the ALLOW_SNAPSHOT_ISOLATION...
  • prakasht

    SSIS Project Deployment Model in SQL Server 2012

    • 0 Comments
    A one of the major improvement in SSIS 2012 is the Project Deployment Model. The project deployment file is a self-contained unit of deployment (.ispac extension) that includes only the essential information about the packages and parameters in the project...
  • prakasht

    WPF Data Grid tips

    • 0 Comments
    Hi folks, While working on WPF, I came to know some good Data grid tips and wanted to share you the same. Issue : WPF Data Grid is not reflecting the changed Item Source. Solution : If using MVVM pattern, Refresh the item source by below...
  • prakasht

    Change the default route in ASP.NET MVC

    • 0 Comments
    Hello folks, As we know that ASP.NET MVC by default takes following setting available in RouteConfig file (under App_Start folder). routes.MapRoute( name: "Default", url: "{controller}/{action}/{id}", defaults: new { controller = " Home ", action...
  • prakasht

    How to fix error "You can't pass property, indexer or dynamic member with out or ref parameter"

    • 0 Comments
    Hi Folks, I happened to encounter this trouble while trying to pass reference of a Property. public class LinkedListQ : QNode { private QNode head = null; public QNode Head { get { return head; } } class Program { static void Main(string...
  • prakasht

    What's new is VS 2013 (RC) for web developers?

    • 0 Comments
    Hello folks Let's discuss some of the amazing enhancements and new features of VS 2013 (RC) in general and mostly related to web technologies. VS IDE Changes: Feedback Icon Notification symbol Sign In option to save...
  • prakasht

    Find first non-repeated character in a string

    • 0 Comments
    Hi folks, This doesn't look difficult right :) however can u think of different ways to find first non-repeated character in a string? I tried 3 different ways in C#. One with O(n^2) and 2 ways with O(n). Please suggest if you can think of better...
  • prakasht

    Reverse a string in different ways

    • 0 Comments
    Hi folks, I am here with another example, how to reverse a string in different ways? Below are the different ways to do it. /// Need one extra array for result, need to traverse full array. public static string ReverseString1 (string str...
  • prakasht

    Reverse words in a string

    • 0 Comments
    Hi folks, I am here with another example, how to reverse words in a string or sentence? I have tried with a approach. I would welcome other approaches, please share.. ////// Complexity: O(n) + O(n)/2 ~ O(n) public static string ReverseWordsInString...
Page 1 of 1 (15 items)