Raymond Lewallen

Browse by Tags

• .Net Development
• Database Basics
• Extreme Programming
• Generalities
• Patterns and Practices
• TDD

• Database Basics Part Three - Isolation

  Author Raymond Lewallen In an effort to provide information for those of you who are newcomers to databases, these Database Basics series of posts are targeted directly at you to help you understand and build better databases. Posted Jan 10 2006, 09:01 PM by Raymond Lewallen with | with 5 comment(s) Filed under: Database Basics, Most Popular, Sql Development

• Database Basics Part Two - Normalization

  Author Raymond Lewallen In an effort to provide information for those of you who are newcomers to databases, these Database Basics series of posts are targeted directly at you to help you understand and build better databases. Posted Jan 04 2006, 11:18 AM by Raymond Lewallen with | with 18 comment(s) Filed under: Database Basics, Most Popular, Sql Development

• Database Basics Part One - The ACID Model

  Author Raymond Lewallen In an effort to provide information for those of you who are newcomers to databases, these Database Basics series of posts are targeted directly at you to help you understand and build better databases. Posted Dec 28 2005, 04:46 PM by Raymond Lewallen with | with 8 comment(s) Filed under: Database Basics, Most Popular, Patterns and Practices, Sql Development

• A recap of popular and helpful posts for developers

  I haven’t posted in about a week because I’ve been busy. Tomorrow I leave on vacation, so I won’t be posting for at least another week. So I thought I would leave you with links to some of the most popular and most read posts on my blog, incase you missed... Posted Aug 24 2005, 11:08 AM by Raymond Lewallen with | with 1 comment(s) Filed under: .Net Development, Extreme Programming, Generalities, Most Popular, Patterns and Practices, Sql Development, TDD

• New INTERSECT and EXCEPT operators in Sql Server 2005 T-SQL

  How to use two new operators in Sql Server 2005 T-Sql Posted Aug 01 2005, 01:46 AM by Raymond Lewallen with | with 3 comment(s) Filed under: Most Popular, Sql Development

• Software Development Life Cycle Models

  A look into the software life cycle models commonly used. Posted Jul 13 2005, 08:13 AM by Raymond Lewallen with | with 324 comment(s) Filed under: .Net Development, Extreme Programming, Generalities, Most Popular, Patterns and Practices, Sql Development, TDD

• Updated random password or string generator in T-Sql for Sql Server

  Here is an updated version of my random string or password generator for T-Sql, made into a stored procedure with some other modifications. The stored procedure /*************************************************************************** * Created By... Posted May 17 2005, 05:21 AM by Raymond Lewallen with | with 21 comment(s) Filed under: Most Popular, Sql Development

• Sql Server script to automate the removal of logins

  Here is another one of those files that just floats around in a SqlScripts directory on my computer. I've found this script useful many times. This was written by Clinton Herring many moons ago. This script will remove a login from Sql Server. What's... Posted May 13 2005, 05:42 AM by Raymond Lewallen with | with 18 comment(s) Filed under: Most Popular, Sql Development

• The difference in TRUNCATE and DELETE in Sql Server

  I’ve answered this question many times, and answered it again this weekend. What is the difference when doing a DELETE TableA instead of TRUNCATE TableA ? A common misconception is that they do the same thing. Not so. In fact, there are many differences... Posted May 09 2005, 05:45 AM by Raymond Lewallen with | with 49 comment(s) Filed under: Most Popular, Sql Development

• Generate an Excel XLS spreadsheet from T-Sql in Sql Server

  Sometimes you find these really old files floating around on your harddrive and you forget that you ever downloaded them. Here is one such example. I have no idea where I got this or who to credit for its creation, but I've had it for awhile and came... Posted May 04 2005, 06:41 AM by Raymond Lewallen with | with 7 comment(s) Filed under: Most Popular, Sql Development

• Generate Sql Server data dictionary table

  Here’s a quick example on how to generate a data dictionary for your sql server database. T-SQL Data Dictionary create table #dd ( table_id int NULL, table_name nvarchar(128) NULL, column_order int NULL, column_name varchar(60) NULL, column_datatype varchar... Posted Mar 04 2005, 11:08 AM by Raymond Lewallen with | with 33 comment(s) Filed under: Most Popular, Sql Development

• Exception Handling in Sql Server 2005

  SQL Server 2005 provides a new exception-handling mechanism in the form of TRY...CATCH. In current version of Sql Server you have to include GOTO statements, and check @@ERROR after every statement is executed to determine if an error had occurred at... Posted Jan 20 2005, 11:56 AM by Raymond Lewallen with | with 12 comment(s) Filed under: Most Popular, Sql Development