The Working Programmer: Cassandra NoSQL Database, Part 3: Clustering
Talk about big data, this database can scale to “ridiculous” sizes, says Ted Neward. One firm claimed to use Cassandra to store more than 50PB of information. Learn how clustering makes such implementations possible straight out of the box.
Async database polling with EntityFramework 5
How to asynchronously poll a database for an Entity with EntityFramework 5
The Baker’s Dozen Doubleheader: 26 Productivity Tips for Optimizing SQL Server Queries (Part 2 of 2)
In part two of this series on optimizing SQL Server queries I’m going to continue with some T-SQL scenarios that pit one approach versus another. I’ll also look at what SQL developers can do to optimize certain data access scenarios. I’ll also compare approaches with temporary tables versus table variables, and stored procedures versus views.
The Working Programmer: Cassandra NoSQL Database, Part 2: Programming
Ted Neward explains how to connect to the Apache Cassandra NoSQL database from the Microsoft .NET Framework, how to read and write data to it, and more.
Dynamically Map SQL Resultset to Business Object
Dynamically map a DataTable to type-safe business objects using reflection and generics.
Generating menu from database according to user privilege
Dynamic menu generation according to user privileges from database.
MySqlBackup.NET - MySQL Backup Solution for C#, VB.NET, ASP.NET
Unicode, UTF8 character backup and restore of MySQL database in C#, VB.NET, ASP.NET
Using Spatial Data with SQL Server 2012, Entity Framework 5 and ASP.NET MVC
One of the highly-anticipated features in the Entity Framework 5 is a Spatial support.
The Working Programmer: Cassandra NoSQL Database: Getting Started
Ted Neward explores Cassandra (the NoSQL database software, not the figure from Greek mythology), which is “an open-source, distributed, decentralized, elastically scalable, highly-available, fault-tolerant, tuneably consistent, column-oriented database that bases its distribution design on Amazon’s Dynamo and its data model on Google’s Bigtable.”
Pitfalls and Pointers for a Base Logging Class in EF Models
An unfortunate use of a base class to provide logging data for all classes in an Entity Data Model creates chaos in the database. Learn why this happens and how to avoid the problem.