Category Archives: Databases

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

Recommender Systems And Their Significance

Posted on 5/14/2017 by Robert S. Robbins

Recently I bought an expensive book, Recommender Systems: An Introduction, by Dietmar Jannach, Markus Zanker, Alexander Felfernig, Gerhard Friedrich. This book could be used as a textbook for a class which may explain why it was so expensive. I bought … Continue reading →

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

How Amazon’s Recommendation Engine May Shape Your Destiny

Posted on 4/18/2017 by Robert S. Robbins

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

Posted on 4/12/2016 by Robert S. Robbins

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

Posted on 4/1/2016 by Robert S. Robbins

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

Posted on 8/4/2010 by Robert S. Robbins

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

Posted on 7/27/2009 by Robert S. Robbins

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 , , , , , | 46 Comments

Visual Studio 2008, SubSonic

Posted on 2/29/2008 by Robert S. Robbins

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

Posted on 7/9/2007 by Robert S. Robbins

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 that … Continue reading →

Posted in Databases | Leave a comment

Transaction Savepoints

Posted on 6/28/2007 by Robert S. Robbins

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

Posted on 6/14/2007 by Robert S. Robbins

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

Posted on 3/6/2007 by Robert S. Robbins

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