Category Archives: Databases

Articles about SQL Server, MySQL, and Access databases. I do a lot of work with databases.

How Amazon’s Recommendation Engine May Shape Your Destiny

I have recently discovered that Amazon’s recommendation engine is powered by an open source artificial intelligence framework called Deep Scalable Sparse Tensor Network Engine (DSSTNE), pronounced “destiny”. I have tried to figure out how the Deep Scalable Sparse Tensor Network … Continue reading

Posted in books, Databases, General, Writing | Tagged , , , , , , , | Leave a comment

Saying Goodbye To Microsoft SQL Server 2005

Microsoft SQL Server 2005 reached its end of life today and will no longer be supported. So today at work I migrated my databases to Microsoft SQL Server 2008 and uninstalled Microsoft SQL Server 2005. I figured I might as … Continue reading

Posted in Business, Databases, General, Programming | Tagged , | Leave a comment

More Startup Progress

Today I began work on the web site for users to sign up for my service. I plan to use the built-in Membership system of an ASP.NET web application. Unfortunately I’ve never really used this and it has changed a … Continue reading

Posted in ASP.NET, Databases, General, Programming | Tagged , , , | Leave a comment

Offline Database On iPhone Using SQLite

I like to take my iTouch with me on my trips to New York City so I can listen to music during the long bus trip. I also copy my compiled HTML notes on New York City to my iTouch … Continue reading

Posted in Databases, Mobile, Programming, Web | Tagged , , , , , | 3 Comments

How To Create A JSON Web Service In ASP.NET

ASP.NET makes it easy to create web services but they usually return XML. Like many web developers I now prefer JSON. This article and sample code will show you how to get your web service to return data in the … Continue reading

Posted in ASP.NET, Databases, JavaScript, Programming, Web | Tagged , , , , , | 42 Comments

Visual Studio 2008, SubSonic

I finally have Visual Studio 2008 installed on my home computer. I have not used it much except for compiling the Video.Show open source video sharing site. However you can use Visual Studio 2008 to work on an ASP.NET 2.0 … Continue reading

Posted in ASP.NET, Databases | Leave a comment

SQL Server 2005 Annoyances

One of the many annoying things about SQL Server 2005 is how it replaces SELECT ALL written as “SELECT * FROM” with a complete list of the column names. After testing a SQL statement in the SQL Pane to determine … Continue reading

Posted in Databases | Leave a comment

Transaction Savepoints

Today I learned how to roll back multiple database queries using transaction savepoints. This is useful when you have several related record inserts, updates, or deletes that should all succeed or all fail in order to maintain your data integrity. … Continue reading

Posted in ASP.NET, Databases | 1 Comment

Utility To Troubleshoot SQL INSERT Statements

Today I wrote a Windows application in C# to help me troubleshoot SQL INSERT statements which do not have an equal number of columns and values. Unfortunately, SQL Server does not provide very informative error messages. It can be difficult … Continue reading

Posted in Databases | Leave a comment

SQL Server Data Import – How To Preserve Primary Keys and Identity Fields

One of my biggest problems working with SQL Server databases is preserving my primary keys and identity fields when I try to copy tables from one database to another. The SQL Server Import and Export Wizard likes to remove primary … Continue reading

Posted in Databases | 8 Comments