Transfer Users from one SQL Server to another including SID’s the easy way on Feb 22, 2013 in CodeProject Servers Tips Enter your zip code here SQL Server SSIS Before I wrote an article regarding this one but it seem that was the hard way of doing it. See the article here http://anyrest.wordpress.com/2012/10/11/how-to-synchronize-loginsusers-between-mirrored-servers/ , but recently I was playing with SSI...
Transfer Users from one SQL Server to another including SID’s the easy way on Feb 22, 2013 in CodeProject Servers Tips SQL Server SSIS Before I wrote an article regarding this one but it seem that was the hard way of doing it. See the article here http://anyrest.wordpress.com/2012/10/11/how-to-synchronize-loginsusers-between-mirrored-servers/ , but recently I was playing with SSI...
Using a Sybase with S#arp Architecture and nHibernate on Feb 21, 2013 in Architecture CodeProject Programming C# Enter your zip code here NHibernate S#arp Architecture This article will discuss on how I achieved using a Sybase database alongside SQL Server with S#arp Architecture / nHibernate. In this article I would assume that you use S#arp and have already a running project where you want to include Sybas...
Migrate Team Foundation Server’s SQL Server to another SQL Server (same or new version) on Feb 14, 2013 in CodeProject Configuration Database Servers SQL Server Team Foundation Server Yesterday we migrated SharePoint’s SQL Server to a new instance today we will be migrating Team Foundation Server (TFS) SQL database to new SQL instance. In this example we are migrating it to a new version of SQL Server which is from SQL 2008...
Migrate SharePoint’s SQL Server to another SQL Server (same or new version) on Feb 13, 2013 in CodeProject Configuration Database Servers Sharepoint Sharepoint Foundation 2010 SQL Server This is a step by step guide on how you migrate your SharePoint’s (I used 2010 version in this instance) SQL Server to an new SQL Server host. In this exercise I tried migrating it in a new version of SQL server which is 2012 from 2008 R2, al...
Upgrading S#arp to MVC4 on Dec 12, 2012 in CodeProject Configuration Programming ASP.Net MVC C# S#arp Architecture First of all I can assure you that S#arp will work on MVC4 and I am using Sharp Architecture 2.0.4. We just recently migrated and tested 2 large S#arp projects and it is fully working and is running in production. Now lets go to the details, I gues...
How to Synchronize logins/users between Mirrored Servers on Oct 10, 2012 in Uncategorized Mirroring SQL Server Now that you have mirrored your servers, it does not mean that your users are also mirrored (isn’t it nice to have this feature included in next SQL Server releases). You should configure your users properly as well so when a disaster hits yo...
Altering Mirroring Endpoints (Ports) on SQL Server on Oct 9, 2012 in Configuration Database TSQL SQL Server Mirroring We are in a middle of a SQL Server 2012 migration project and one of the main tasks is to completely mirror all of the databases. Having said that it does not mean we did not mirrored it before, some of the legacy databases are already mirroring and...
Using SQL Server Reporting Services in MVC Web Application on Sep 24, 2012 in Programming ASP.Net MVC MVC Reporting Services You might be wondering how to use SQL Server Reporting Services Reports with an MVC Application hence you’re in this page, well let me explain to you in this simple steps At the time of this post there is no controls yet for Report Viewer in MV...
Programmatic Execution of an Excel Macro on Remote Machine from a website on Jun 21, 2012 in CodeProject Programming ASP.Net C# Excel IIS OLE Automation I tried searching everywhere for a solution on this issue but found nothing. To give you an idea what I want to achieve here is the scenario. We have a website where users generate and Excel report using a macro, when I try to run it in my local mach...
