This month's products include DatabaseSpy, FileZilla, NCache, and more.
MSDN Magazine October 2007
View Complete Post
This column covers Web application performance with distributed caching, a utility for object-object mapping, and a look at interesting blogs.
MSDN Magazine September 2009
Save Coding Time, Manage Compressed Files, and More
MSDN Magazine January 2007
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.
MSDN Magazine April 2006
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
... 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,
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?
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
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!!
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 :)
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 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.
MSDN Magazine June 2010
MSDN Magazine January 2010
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.
MSDN Magazine December 2009
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.
MSDN Magazine November 2009
This column covers common user interface groupings, configuring NHibernate using C#, and a look at interesting books and podcasts.
MSDN Magazine October 2009
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.
MSDN Magazine August 2009
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.
MSDN Magazine July 2009