Tuesday , November 13 2018
Home / Murali

Murali

Hello everyone I am Software Developer having 3+ years of Experience in Microsoft Technologies and Others. My skills :- Asp.net, C#,Ado.net, SQL SERVER, web services, windows Service,Windows applications,HTML,CSS, JavaScript,JQuery,AnjularJs

July, 2018

  • 21 July

    How to Identify Database memory in Sql Server

    Identify database size in sql server

      If we run below script it gives us details about memory used by each of the databases . The script returns results in MB. Please remember that it retrieves the data from operating system’s buffer and it keeps on changing. However, this gives information at least relevant to the …

  • 2 July

    GhostDoc Visual Studio extension

    GhostDoc

    GhostDoc is a code documentation tool.Every developer needs to document their code for example we write a method for display purpose then we have to document the method functionality (why this method will use and what it will returns and what type of parameters it accepts) so that other developers …

May, 2017

  • 16 May

    sql server query pagination

    From SQL Server 2012, Microsoft introduced a couple of T-SQL Enhancements. One of them is Query Pagination. In most of the applications, a common requirement is how to fetch the data from the database servers as page wise. In earlier versions of SQL Server like SQL Server 2005/2008/R2, we can implement …

March, 2017

  • 31 March

    Visual Studio 2017 Poster

    Visual Studio thought it would be fun to put together a poster(Visual Studio 2017 Poster) that shows off some of favorite parts of Visual Studio 2017. You’ll also see some helpful tips and tricks to improve your productivity! Visual Studio 2017 Poster: download Visual Studio download poster as pdf   …

  • 29 March

    How to find locked tables in sql server

    Locked Tables

    In multiuser environments, sql server ensures the integrity of the data by setting write locks on all the tables(Locked tables) when you are updating. This prevents other users from making changes to the same tables. if the table is locked we cannot do any CRUD(insert/select/update/delete) operations on table until it …

  • 26 March

    What’s New in Visual Studio 2017

    what's new in visual studio 2017

    What’s new in Visual Studio 2017: Microsoft happy to announce the release of Visual Studio 2017. This release brings a new lightweight and modular installation experience which can be tailored to your needs. by using Visual Studio 2017 to develop apps for Android, iOS, Windows, Linux, web, and cloud. Code …

  • 18 March

    sql server Startup Options in SSMS

    sqlserver_startupoptions

    Normally, after opening up SSMS and once logged in we will Open up a new query window manually to write our scripts but by configuring SSMS startup options we can open new query window or object explorer etc after logged into SSMS immediately Under the Options -> Startup -> At …

  • 18 March

    Backup all databases in SQL Instance with one script

    sql server backup script

    Backup: A copy of SQL Server data that can be used to restore and recover the data after a failure. A backup of SQL Server data is created at the level of a database or one or more of its files. sql server provides a script to take backup Here is …

February, 2017

  • 23 February

    Free ebook: Creating Mobile Apps with Xamarin.Forms

    Xamarin ebook

    Xamarin is a Microsoft-owned San Francisco, California-based software company founded in May 2011 by the engineers that created Mono, Mono for Android and MonoTouch, which are cross-platform implementations of the Common Language Infrastructure (CLI) and Common Language Specifications (often called Microsoft .NET). With a C#-shared codebase, developers can use Xamarin tools to …

  • 22 February

    Find all rows count and columns count in single database in sql server

    In General for any database it contains lot of tables, if we want to find rows count and columns count for any table we need to write individual query for each and every table. but in sql server we have a stored procedure called sp_msforeachtable it will return all table names …

  • Page 1 of 8
    1 2 3 8