Skip to main content

Posts

How to create MySQL Link Server in SQL Server 2012

Workbench is a free tool for MySQL but it is collection of issues in working environment. So I came back on SQL Server management studio. But think if our requirement is something like what , data will be at same place in MySQL and we have to access from SQL Server. Then we can use SQL Server's  Server object’s Link server .  Today I am going to share 7 steps how I have made linked server from SQL Server to MySQL. 

Could not delete publication 'XXX'. Microsoft SQL Server, Error: 15517

Hey friends, I am filling good to write my 1st post in 2015. This is related to error in replication which i faced in 2014 he he. Last month i was facing an error during roll backing Transnational replication as below.. ------------------------------ Could not delete publication 'XXX'. Microsoft SQL Server, Error: 155 17 TITLE: Microsoft.SqlServer.ConnectionInfo

Wishing Happy New Year 2015

Difference between SQL Handle and Plan Handle

When we execute query select * from sys . dm_exec_query_stats it will show aggregate performance statistics of cached query plans of SQL Server. The details including one row per query statement within the cached plan, and the lifetime of the rows are tied to the plan itself. Details have two column SQL Handle and Plan Handle.

Configure Impersonation Authentication in IIS8 for MVC Application

Impersonation is when ASP.NET executes code in the context of an authenticated and authorized client. By default, ASP.NET does not use impersonation and instead executes all code using the same user account as the ASP.NET process, which is typically the ASPNET account. There are 5 below steps by which we can establish Impersonation configuration in our secured application environment. 1.)    Creation of Application/Proxy user where Application is hosted. 2.)    Give appropriate access to the user. 3.)    Create Database Login user on database. 4.)    Authenticate User and provide credential on IIS. 5.)    Then Configure web.config on Application.

Microsoft Delhi UG Meet Nov 2014

Hello friend,  I have been drunk last week end ,, yeah 5 liter vodka.. Dont surprise this drunk was IT enable  drunk in Microsoft Delhi UG Meet . Still my eye not opening and thinking about meets. Like Bangalore Monthly UG Meet microsoft planned for Delhi UG also. Thease are all about through MVPs of NCR ( Deubug_mod , Sarabpreet sir , ahmed sir , brij sir and Aman sir )..