C# 6 and Visual Studio 2015

    I created some examples of new C# with Visual Studio 2015. You can download and view them on GitHub (https://github.com/erossini/CS6-Preview). For more information about Visual Studio 2015, you can visit http://www.visualstudio.com/en-us/news/vs2015-preview-vs.aspx

    Read More

      How to Enable XP_CMDSHELL using SP_CONFIGURE

      In this tip we will take a look at the step to follow to enable or disable XP_CMDSHELL using SP_CONFIGURE system stored procedure. In order to use XP_CMDSHELL you need to be a system administrator. Read the following article which explains how to allow non-administrators to use XP_CMDSHELL. Error Message Received when XP_CMDSHELL is disabled…

      Read More

        How to Disable XP_CMDSHELL using SP_CONFIGURE

        It is always considered as a best practice to disable XP_CMDSHELL when not in use. A database administrator can disable XP_CMDSHELL using SP_CONFIGURE system stored procedure. To disable XP_CMDSHELL execute the below mentioned script. Use Master GO EXEC master.dbo.sp_configure ‘xp_cmdshell’, 0 RECONFIGURE WITH OVERRIDE GO EXEC master.dbo.sp_configure ‘show advanced options’, 0 RECONFIGURE WITH OVERRIDE GO

        Read More