Monday , December 11 2017
Home / Murali (page 2)

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

January, 2017

  • 1 January

    AES Encryption and Decryption (Cryptography) Tutorial with example

    AES256-Encryption

    AES Encryption and Decryption: AES stands for Advanced Encryption Standard and it was originally called the Rijndael cipher, it is based off a combination of the two Belgian author’s names Joan Daemen and Vincent Rijmen. After the cipher was accepted in 2002 to replace the aging DES cipher, it became the …

December, 2016

  • 31 December

    ISNULL() Vs NULLIF() in sqlserver

    isnull-vs-nullif

    In this article I will explain the differences between the ISNULL() and NULLIF() functions in SQL Server 2012. ISNULL() Function The ISNULL() function is used to replace NULL with the specified replacement value. This function contains only two arguments. Syntax ISNULL (check_exp, change_value) Example 1 : Select ISNULL(null,15) ‘ISNULL VALUE’ output: 15 …

  • 26 December

    Free Ebook : Introducing Microsoft SQL Server 2016

    sql_2016 ebook

    Free Ebook : Introducing Microsoft SQL Server 2016 SQL Server 2016 is the latest addition to Microsoft’s data platform, with a variety of new features and enhancements that deliver breakthrough performance, advanced security, and richer, integrated reporting and analytics capabilities. Built using the new rapid-release model, SQL Server 2016 incorporates …

  • 9 December

    AdventureWorks Database collection (2014,2012,2008,2005)

    AdventureWorks Database

    The AdventureWorks database is a fictitious company database that has existed since SQL Server 2005 as a means to show new functionality in each new version released. Because the Books Online TSQL samples leverage this sample database, AdventureWorks has become a vital aspect of learning new features/constructs within SQL Server. …

November, 2016

  • 22 November

    5 Tips for a Smooth SSIS Upgrade to SQL Server 2012

    5-tips-for-a-smooth-ssis-upgrade-to-sql-server-2012

    SSIS Upgrade Microsoft SQL Server 2012 Integration Services (SSIS) provides significant improvements in both the developer and administration experience. This article provides tips that can help to make the SSIS Upgrade to Microsoft SQL Server 2012 Integration Services successful. The tips address editing package configurations and specifically connection strings, converting …

  • 21 November

    Best Call Recorder Apps For Android – 2016

    Best Call Recording Apps

    Having an important conversation while knowing that you’ll probably forget it all when the call ends? Discussing ideas that will be lost just because you don’t have a pen and paper? Or maybe wanting proof that someone did say something to you? Few Android based smart phones are provided inbuilt apps …

  • 12 November

    Free ebook: Introducing Microsoft Power BI

    Microsoft PowerBI

    Microsoft Power BI: Get started quickly with Microsoft Power BI! Experts Alberto Ferrari and Marco Russo will help you bring your data to life, transforming your company’s data into rich visuals for you to collect and organize, allowing you to focus on what matters most to you. Stay in the …

  • 5 November

    How to Create Query Shortcuts in SQL Server Management Studio

    sql_custom_shortcuts

    In this article, we are going to see some shortcuts that may be useful to you when you work with SQL Server Management Studio. You can always use some custom queries as query shortcuts in SSMS. You can create shortcuts for frequently used queries in Management Studio, some of the shortcuts …

October, 2016

  • 31 October

    Union vs Union All in Sql Server

    Union vs Union All in Sql Server: UNION The UNION command is used to select related information from two tables, much like the JOIN command. However, when using the UNION command all selected columns need to be of the same data type. With UNION, only distinct values are selected. in …

  • 29 October

    View All Databases Information In SqlServer

    Sp_helpdb

     View All Databases Information In SqlServer: There are different ways of listing all databases within an instance of SQL Server. 1.Sp_helpdb : Reports information about a specified database or all databases. Example 1: exec Sp_helpdb Output: Example 2: exec Sp_helpdb ‘Construction’ 2. sp_databases  : Reports all databases Names and Sizes Example: EXEC sp_databases  …

  • Page 2 of 8
    1 2 3 4 8