When migrating portals from one instance to another, you can use the template creation in DotNetNuke to export a template with content and then import that template to another instance. The problem you end up with however is the links tend to break as your portals directory usually has another id assigned to it. With SQL 2005 you can use the replace function to replace some text, but you're dealing with an ntext field, and you also don't want to run the replace on all DesktopModules if you have a multi portal instance. Here's a SQL 2005 sto...

A few years ago, mentioning the phrase "SQL Injection" to developers or asking to adopt a "defense-in-depth" strategy would probably get you a blank stare for a reply. These days, more people have heard of SQL Injection attacks and are aware of the potential danger these attacks present, but most developers' knowledge of how to prevent SQL Injection is still inadequate, and when asked how to defend their applications against SQL Injection, they usually reply, "That's easy, just use stored procedures." As we will see, using stored procedures is ...

 By Brad Kingsley I guess I'm from the "old school" because I learned coding without a fancy GUI and I still have a tendency to lean that direction when possible. The latest version of Visual Studio is a great tool, but I still like to understand what's going on rather than just dragging and dropping controls onto a page. Perhaps with some more time I'll give up on this way of thinking, but for now I still like to hand-code at times. With ASP.Net 2.0 available now, I wanted to create an ASP.Net page that would pass parameters to a S...

Have you ever want to loop through a recordset and then perform another database operation as you go through the recordset? You may have considered doing this in the ASP.NET page, but it can really slow down your application making repeated calls over the network to connect to the database server from the Web server. In this code snip, we going to show you how you can implement cursors in your stored procedures in SQL. Alter PROCEDURE dbo.sp_InsertRecords AS Declare @id int -- first we'll pull some records out of our table. DECLAR...

First of all, I would like to introduce you all in to the situations that lead to Import and Export of data. When your company has purchased a new/better application that function well in some other database than the one that you are currently using, you will need to transfer data from one database to another, keeping database integrity. That is just one case in which you will need to make use of the data transformation services of SQL Server. There can be many others like, when there are multiple applications and databases managing the busines...