Monday , December 11 2017
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

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 …

January, 2017

  • 6 January

    dbForge Studio for SQL Server – Ultimate SQL Server Manager Tool from Devart

    dbForge-Studio-for-SQL-Server

    dbForge Studio for SQL Server is a powerful IDE for SQL Server management, administration, development, data reporting and analysis.The tool will help SQL developers to perform complex database changes, version-control database changes in popular source control systems, and speed up routine tasks. dbForge Studio for SQL Server Features Overview: Devart’s …

  • 3 January

    Free Ebook: 45 Database performance tips for developers

    As a developer, you may or may not need to go into the database and write queries, or design tables and indexes, or help determine configuration of your SQL Server systems. But if you do, these 45 database performance tips ebook  should help to make that a more pain free …

  • Page 1 of 8
    1 2 3 8