There are several options if one wishes to move a database from a SQL Server 2005 to SQL 2008 Server. First of all there is a 'Copy Database Wizard' in SQL 2008 Server which is meant for transferring a database from any version of SQL Server 2000 and above to 2008 version. In the other option the database will be copied using the SQL Server Management Program for which the source database need not be stopped. However this is slower than the previous method and would also require the SQL Server Agent since a package has to be run.
An option which works without too much hassles is manually detaching and attaching the database/log files. In this step-by-step (really two steps) tutorial by Jayaram Krishnaswamy, this simple procedure is described. If you are just interested in taking a small database from 2005 to 2008 server the author strongly recommends this procedure.Read Moving a Database from SQL Server 2005 to SQL Server 2008 in Three Steps in full
The Repeater control is a data-bound control that uses templates to display data. The Repeater control works by looping through the records in your data source and then repeating the rendering of one of its templates called the ItemTemplate, one that contains the records that the control needs to render. In this article by Joydip Kanjilal we will learn more about the Repeater control and some of its uses.Read The ASP.NET Repeater Control in full
SQL 2008 server is the latest in the line of Microsoft database servers and this article by Dr. Jayaram Krishnaswamy discusses the challenges one may face in installing the Developer version of this product which was released in November 2007. On a virgin machine the software probably installs without a hitch but with a history of installs, especially of the earlier versions it is anything but a joy ride.
"It is almost always true for most of the software I have installed, not necessarily limited to Microsoft. However, most of Microsoft products need entry in the Window's registry and it is almost certain that one has to follow a certain protocol if one wishes to have a successful install. In fact the unsuccessful install flags out what went wrong while the initial steps do verify the requirements during installation. Despite this help and warnings one may face problems simply because it is not possible to foresee all possible combinations of hardware, software, user created error issues at launch time of the product. Again this article does not guarantee a successful install if one were to follow the steps delineated but gives you some guidance based on the author's experience."Read Microsoft SQL Server 2008 - Installation Made Easy in full
Tetris is a classic game. In this article by Stefan Björnander, we will develop a version very similar to the original version. Seven figures of different shapes and colors fall down and the player's job is to move and rotate them into positions so that as many rows as possible are completely filled. When a row is filled, it disappears. Every removed row gives one point.Read Application Development in Visual C++ - The Tetris Application in full
The thought of creating your first skin may be intimidating. You may believe that there are steps that will have to be done just right or there's no point even getting started. The fact is that once you understand some simple concepts, skinning is relatively easy. Ultimately, you will need to know your HTML and CSS markup and styling, but that is common in any type of web design you would do anywhere. This article by Darren Neese is geared toward those who have never created a skin, and it will get you over any anxiety you thought you had about creating a skin.Read DotNetNuke Skinning: Creating Your First Skin in full
In this article by Richard Seroter, you will learn and understand about consuming the adapter from outside BizTalk Server, WCF service reference, Auto generated IIS hosted service, and finally custom built proxy hosted service.Read Consuming the Adapter from outside BizTalk Server in full
These days, Model View Controller (MVC) is a buzzword in the ASP.NET community, thanks to the upcoming ASP.NET MVC Framework that Microsoft is expected to launch soon. The Framework allows easier adoption of the different MVC patterns in our web applications.In this article by Vivek Thakur, we discuss ASP.NET MVC Framework in detail with the help of a Sample Project. We also take a glance at Unit Testing with reference to ASP.NET MVC Framework.
The ASP.NET MVC framework was released by Microsoft as an alternative approach to webforms when creating ASP.NET based web applications. The ASP.NET MVC framework is not a replacement or upgrade of webforms, but merely another way of programming your web applications so that we can get the benefits of an MVC design with much less effort.Read ASP.NET MVC Framework in full
It is not always possible to conduct the automated tests. There are situations where we may need the manual tests. Manual testing is a document or a text file, which contains a set of steps for the tester to follow. Manual testing can be conducted in between automated tests or anywhere between a series of different tests. For example, after some sets of automated tests, we may have to check log files or configuration information or settings based on the tests executed to continue with the remaining automated tests. We can group all these tests together, order them, and create an ordered test to execute the tests in an order.
In some cases, we may need to execute the tests that are not created by using Visual Studio but required for this current application. In that case, we go for the generic test, which acts as a wrapper for the tests written by some third-party tool and executes that test inside Visual Studio IDE. Once it is wrapped, it is executed normally like any other test inside Visual Studio.
This article by Subashni.S and N Satheesh Kumar talks about the manual, generic, and ordered test types in detail. We will go through the steps to create and manage these tests types in VSTS.Read Manual, Generic, and Ordered Tests using Visual Studio 2008 in full
Active Directory (AD) failure, which includes corruption, is something that is dreaded by any administrator. Simply put, it means that the directory service can no longer read the Active Directory database that it has locally. This will prevent logon and authentication as well as any directory-dependent services. Essentially, it renders the domain controller (DC) useless. What's worse, though, is that several times, the replication keeps going so that the corrupted database spreads out to the other DCs.
In this article by Florian Rommel, we will look at the different options and approaches available to recover a DC that has a database corruption. In addition, this article outlines, symptoms, causes, and solutions for this scenario.Read How to Recover from an Active Directory Failure in full
Planning is a key element of any IT implementation, but planning can only be accomplished with an understanding of the technical underpinnings of the proposed solution. In this article, authors Mitesh Desai and Dan Renfroe delve more deeply into the technical architecture of BES in order to provide you with an understanding of what’s under the hood. This article also covers the system requirements and pre-requisites for a BES implementation, including operating system, hardware, network, and database requirements.Read BlackBerry: BES Architecture and Implementation Planning in full