Replace Text via SQL Replace in a DNN HTMLText Module By Patrick Santry In Dev / Tech, DotNetNuke, SQL, Oct 19 2008 6572 0 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... Continue Reading »
Beyond Stored Procedures: Defense-in-Depth Against SQL Injection By Staff In Security, SQL, Jul 26 2006 6480 0 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 ... Continue Reading »
Calling a stored procedure from ASP.Net By Patrick Santry In Dev / Tech, ASP.NET, SQL, May 04 2005 7121 0 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... Continue Reading »
Code Snip: Using Cursors in TSQL By Staff In Dev / Tech, SQL, Feb 03 2005 5228 0 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... Continue Reading »
SQL: Importing and Exporting Data By Staff In Dev / Tech, SQL, Jan 19 2005 5426 0 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... Continue Reading »