Now Reading
Planned books:
None
Current books:
-
Mathematics for the Digital Age and Programming in Python by Maria Litvin and Gary Litvin
-
Statistics In Plain English by Timothy C. Urdan
Recent books:
- Practical Machine Learning in R by Fred Nwanganga, Mike Chapple
- Statistical Inference via Data Science: A ModernDive into R and the Tidyverse by Chester Ismay and Albert Y. Kim
- The Nature of Code by Daniel Shiffman
- Story: Substance, Structure, Style and the Principles of Screenwriting by Robert McKee
- The Red Queen: Sex and the Evolution of Human Nature by Matt Ridley
-
Category Archives: Databases
Recommender Systems And Their Significance
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
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
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 Microsoft SQL Server 2005, Microsoft SQL Server 2008
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 ASP.NET, Azure, Identity, Membership
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 databases, iPhone, iTouch, offline web applications, Safari, SQLite
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 ASP.NET, C#, jQuery, JSON, MySQL, web service
46 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 that … 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
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