.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Toolbox: Manage databases, easier FTP, and clustered caching

Posted By:      Posted Date: August 21, 2010    Points: 0   Category :ASP.Net

This month's products include DatabaseSpy, FileZilla, NCache, and more.

Scott Mitchell

MSDN Magazine October 2007

View Complete Post

More Related Resource Links

Toolbox: Distributed Caching, Object-Object Mapping, Blogs and More


This column covers Web application performance with distributed caching, a utility for object-object mapping, and a look at interesting blogs.

Scott Mitchell

MSDN Magazine September 2009

Toolbox: Save Coding Time, Manage Compressed Files, and More


Save Coding Time, Manage Compressed Files, and More

Scott Mitchell

MSDN Magazine January 2007

Toolbox: Analyze HTTP Traffic, Synchronize Databases, and More


Debugging Web applications can be a difficult process due to the logical, physical, and temporal differences between the mishmash of technologies that comprise such an application. For bugs that arise from the HTML and script received by the browser or in the transfer or request of a page's markup, developers often adopt archaic debugging techniques, such as using View Source and Notepad to scrutinize the contents received by the browser.

Scott Mitchell

MSDN Magazine April 2006

How to manage Functions across 9 different test databases, Help!


Hello everyone. Thank you for your help.

We are using sql server 2005, and writing stored procedures and user defined functions. We have just introduced a complex test environment that is going to make our t-sql code management very complicated, could use your ideas how to simplify this.

*** The problem: in our development and test environment we're looking at maintaining 9 different versions of each user defined function (udf) we create. This is way too many versions, we'd like to cut it down to 3 versions or even 1 version if possible of each udf. ***

1) We will be developing and testing our udfs in 3 test environments - development (DEV), and two end user test regions - UAT, QAT. Each 'region' is a separate sql server database.

.... so we're looking at 3 versions there, one version in each database.

2) And then, we have 3 different sources for our data: real time production (RT), a day end snapshot (DA), and a month-end snapshot (MO). Each of our functions will need to execute against each of these 3 data sources. Each data source resides in a separate sql database.

... so we now have 3 X 3 versions of each function; as mentioned first, one version in each development environment (DEV, UAT, QAT) and then each function in say DEV must be hard coded to run against each of our 3 data sources (RT,

Copying SharePoint databases from single SQL server to clustered SQL servers, is it possible?



I am going to install SharePoint on load balancing servers - two front web servers, clustered database and on query server.

Since ordering the required hardware for clustering may take long time, my company decides to install SharePoint databases on single SQL server, and later on the databases will be restored on the clustered database server, any SharePoint configuration related to database will use DNS name not the IP address.

My question , in order to copy SharePoint database from single SQL server to clustered SQL servers ,Can we take backup from SharePoint databases (Content , Shared services ,Search …) from single  SQL server to be restored later on clustered SQL server? And then change DNS record to refer to the clustered IP address without any modification on SharePoint settings?



Cant move system databases of SQL Server 2008 (Clustered) running in Windows 2008 with Service SID e



I was trying to move system databases of SQL Server 2008 on clustered emvironment running on Windows 2008.

I remember while doing the cluster installation somewhere it gave me a recomended option of using Service SID. I think that is the culprit here. Because if you see the "Security" of the DATA folder containing all the MDF and LDF (by default location) you will find a Group named "MSSQLSERVER" is having full access to that directory.

While moving the system databases you need that account (MSSQLSERVER) given access to the parent directory containing the MDF and the LDFs, But unfortunately you cannot add that account manually. Even I tried XCOPY to make sure that while copying the ACLs gets transferred properly to the destination, even that failed.

I think it does provide a solid Security but at the expense of Maintenance, which I cant agree.

Also I forgot to tell you that this Sevice SID option is available if you are using Windows Vista / Windows 2008 or above,

Does anyone has any experience of moving the system databases with Service SID enabled in a cluster environment.

As a testing just try to copy/xcopy/robocopy any folder having MSSQLSERVER group in the ACL and see what happens .. If you are lucky like me then you will get ACCESS DENIED error.

Have anyone faced the same error? I h

Easier Silverlight Development against SharePoint

I have been spending quite a bit of time lately working with Silverlight 3 and SharePoint. One of the first big shifts for me is that Silverlight Development is Client development. Silverlight runs in the browser, but it runs on the client, so no SharePoint Object Model code. You have to access all of the goodness that is SharePoint through its web services.

ASP.Net Caching problem ??


I'm having a problem with an asp.net 3.0 application using a gridview to display data.  The problem seems to be that despite a brand new .selectCommand being sent to the sqlDataSource, the gridview starts displaying data from *someone else's* query.  For example, user A is logged in and will be working fine until a few page submissions later when the gridview data starts suddenly showing information that belongs to another user. 

This is my first asp.net application, though I've been working with classic asp and ADO for years so I'm used to sending a SQL string and getting back the results from that string.  Apparently there is a complex caching system which is interferring which I do not at all understand so at this point I just want to stop the server from caching any data whatsoever.  Is this possible?

Any and all help will be much appreciated!!

is the page caching?


I am just trying to understand the basics flow to the MVC framework by putting in some breakpoints in the beginning of the actions of a couple of controllers.

One break point is at the HomeController/Index action where it just returns View() of the "Welcome to MVC".  The Second break point is at a SecondController/Index action where it uses the Entity Framework and returns a View() of a list from the db.

When I run this in debug, it breaks at the points I expected when I go from Home page to the Second page controller and back to Home.  However, when I go to the Second page again, it doesn't break at all?  Is the results of the Second page being cached and how and where?  How do you trigger for it to get check if data is old?

I check to see if the persistence is done on the db, by changing the value of a field on the db side and it still did not cause it to break on that action and displays old information in the view.  I am concerned because it is displaying incorrect values on the UI.  I do not have the OutputCache attribute above this action or specified any cache on my web.config.

Thanks in advance for your time :)

Data caching c#.net


Hi Friends,


I have a large SQL Database in the server from which I can create a dataset of about 10000 rows. My question is about caching this data. Which type of data caching should I choose (Server side or Client side)? Which one will provide better performance?


Thanks in advance

SOA Tips: Address Scalability Bottlenecks with Distributed Caching


SOA makes application scalability easier, but getting the best performance out of your SOA means paying close attention to the details. We'll give you some tips for coding your app more effectively and using distributed caching to remove data access bottlenecks.

Iqbal Khan

MSDN Magazine June 2010

Toolbox: UI Mockups, User Experience Tips, JavaScript Checker and More


Scott Mitchell reviews a user interface mockup tool, a blog for user experience tips, a JavaScript code checker and a book that expertly explains the ins and outs SQL Server Reporting Services.

Scott Mitchell

MSDN Magazine January 2010

Toolbox: Database and OR/M Tools, Oren Eini and Custom Visual Studio Tabs


This month we look at tools for enhancing the LINQ to SQL and Entity Framework designers, Oren Eini's .NET development blog, Visual Studio tab customization, and more.

Scott Mitchell

MSDN Magazine December 2009

Toolbox: Database Documentation, API for Pre- and Post-Conditions, Blogs and More


In this month's column, Scott explores one-click database documentation, covers an API for pre- and post-conditions, takes a look at an interesting blog, and reviews the latest book about the ASP.NET MVC Framework.

Scott Mitchell

MSDN Magazine November 2009

Toolbox: User Interfaces, Podcasts, Object-Relational Mappings and More


This column covers common user interface groupings, configuring NHibernate using C#, and a look at interesting books and podcasts.

Scott Mitchell

MSDN Magazine October 2009

Toolbox: Data Snapshots, Subversion, Source Code Organization and More


If you want to save, organize, and annotate snapshots of your database data, find an easy way to install and configure Subversion, and automate the organization of your source code, then you'll want to read more about these latest tools.

Scott Mitchell

MSDN Magazine August 2009

Scale Out: Distributed Caching On The Path To Scalability


Developers frequently face issues related to scalability bottlenecks when they have applications that need to handle a lot of load. This article describes the role of a distributed cache in building scalable applications.

Iqbal Khan

MSDN Magazine July 2009

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend