Browse by Tags

• .NET
• 3.5
• 7
• 7.0
• AASP
• ASP.NET
• Backup
• BSOD
• Code
• Error
• Forum
• GoDaddy
• Hosting
• IIS
• Installation
• LINQ
• Membership
• Microsoft
• Mouse
• Open
• Programming
• Query
• Restore
• Script
• Server
• Software
• Source
• SqlMembershipProvider
• Studio
• SVN
• T61p
• Thinkpad
• Visual
• Visual Studio
• Warning
• Windows
• x64
• YAF

• MS SQL Check If Column Exists

  The following SQL script checks if a certain column exists in a certain table, then prints some text to the output window. I'm getting into the best practice habit of creating SQL scripts that can be re-run without any errors and this is useful in... Posted Jul 08 2009, 10:38 AM by Matt Williamson with | with 1 comment(s) Filed under: Script, Software, Code, SQL, Query

• SQL Replace Function on NTEXT Data

  Today I've made some changes to my hosted environment. I've decided to enforce my websites URL as always 'http://www.bunkerhollow.com' instead of 'http://bunkerhollow.com'. This will keep the URL the same whether I'm inside... Posted Jun 07 2009, 04:39 PM by Matt Williamson with | with 1 comment(s) Filed under: Error, Script, Code, SQL

• MS SQL Loop Through Table Scripts

  At some point you may want to loop through every row in a table and perform operations based on the fields in each row. After a bit of investigation, I've found the 2 most common ways of doing it. Loop Through All Rows of a Table Using a Counter This... Posted Mar 10 2009, 10:24 AM by Matt Williamson with | with 3 comment(s) Filed under: Script, Software, Code, SQL, Programming, Microsoft

• SQL Find All (Search) Scripts

  The following is a running list of MS SQL scripts I've used to search for items within databases. Wouldn't it be great if they just had a better Find function in SQL Management Studio?! Find All Tables with Certain Text in the Table Name use YourDataBaseNameHere... Posted Mar 09 2009, 09:14 AM by Matt Williamson with | with no comments Filed under: Script, SQL

• SQL Server Insert Using Identity

  While developing SQL scripts you'll probably find yourself inserting rows with identity columns at some point. You'll then probably want to obtain those newly created identity rows (generally ID columns of some sort) and want to insert new rows... Posted Feb 18 2009, 08:45 AM by Matt Williamson with | with no comments Filed under: Script, Software, SQL

• Introducing the American Academies of Sports Practitioners!

  It's been 9 months in the making and the American Academies of Sports Practitioners (AASP) is finally live! I was given the logo you see above and I built the entire site around it, mostly from scratch. I implemented a forum system using YetAnotherForum... Posted Jan 04 2009, 03:57 PM by Matt Williamson with | with 2 comment(s) Filed under: Software, SQL, ASP.NET, Hosting, LINQ, AASP

• ASP.NET Site Hangs Forever When Accessing Database via LINQ to SQL

  I finally published a project of mine to some hosting I purchased from DiscountASP.NET. I'm very pleased with their service and minus the inability to contact them by phone, I prefer them over GoDaddy. So after purchasing all the Add-Ons I needed... Posted Jan 04 2009, 02:41 PM by Matt Williamson with | with no comments Filed under: Software, SQL, ASP.NET, Hosting, LINQ

• Working with YAF Source Code from SVN Repository

  I've been working with YetAnotherForum for a while now. It's an open-source .NET forum control written in C#, and it's great software. I've made some contributions here and there with a smiley pak , an avatar collection , and helping others... Posted Dec 06 2008, 10:03 AM by Matt Williamson with | with 5 comment(s) Filed under: Software, SQL, Visual, ASP.NET, Forum, YAF, SVN, Source, Studio, Open

• SQL Server 2008 - Saving Changes Is Not Permitted

  Using the import data wizard I created a new table from a spreadsheet and then tried to delete some columns and add a primary key. When I tried to save my changes in SQL Server Management Studio, this error appeared: Saving changes is not permitted. The... Posted Sep 14 2008, 09:26 AM by Matt Williamson with | with 5 comment(s) Filed under: Error, Server, Software, SQL

• Publish a .NET 3.5 Website to Windows Server 2008 IIS 7

  Install the Web Server Role In Role Services, select ASP.NET and continue. Install the .NET 3.5 Framework On your webserver, install the .NET 3.5 framework . Publish Your Application In Visual Studio, publish your web project to a local folder, like on... Posted Jun 18 2008, 07:42 PM by Matt Williamson with | with no comments Filed under: 7, Server, Windows, IIS, Software, SQL, ASP.NET, 3.5, .NET

• GoDaddy SQL Database Backup and Restore

  Through the GoDaddy web interface, there are options to backup or restore your SQL Server databases. The databases are backed up and restored from a folder in the root of your FTP filesystem called '_db_backup'. The unfortunate thing is, you cannot... Posted May 14 2008, 10:45 AM by Matt Williamson with | with 4 comment(s) Filed under: GoDaddy, Backup, Restore, SQL

• SQL Server Management Studio BSOD

  When opening a table or view in SQL Server Management Studio I would frequently get a blue screen of death. I just found the solution and it's down right crazy... uninstall Microsoft IntelliPoint! Yeah... unbelievable but it works. You can remove... Posted Apr 28 2008, 09:57 AM by Matt Williamson with | with 5 comment(s) Filed under: BSOD, SQL, Mouse

• Why is Sql Server on my Thinkpad?

  The only software I chose while configuring my T61p online was Vista Business 64, but of course a bunch of junk comes preloaded. So I'm trimming the fat and installing my developer tools. I'm about to install the Sql Server 2005 Developer Edition... Posted Mar 12 2008, 12:21 PM by Matt Williamson with | with no comments Filed under: Server, Software, SQL, Thinkpad, T61p

• .NET 2.0 Custom SqlMembershipProvider

  While I'm waiting for my development machine to come in (Thinkpad T61p !!!), I'm doing some prep work on my desktop. I installed SQL Server 2005 Standard x64, Visual Studio 2008 Professional x64, and all of the service packs and updates. During... Posted Feb 03 2008, 10:56 AM by Matt Williamson with | with no comments Filed under: Server, Visual Studio, x64, SQL, SqlMembershipProvider, Membership

• SQL Server 2005 IIS Warning

  So after heeding the IIS warning during installation and installing IIS, I was still receiving this warning: Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS... Posted Feb 03 2008, 12:25 AM by Matt Williamson with | with 1 comment(s) Filed under: Server, IIS, Warning, SQL, 7.0, Installation