SQL

Who comes up with this? Is this a dummies for dummies book? In The Manga Guide to Databases, Tico the fairy teaches the Princess how to simplify her data management. We follow along as they design a relational database, understand the entity-relationship

Sometimes you want to know what the percentage is of null values in a table for a Column Or you might want to know what the percentage of all values in a Column is grouped by value You can get these answers by running the code below

A 5 part blogpost about the performance of a select statement done with ADO.Net using inline sql, and stored procedures (even some dynamic sql) and then nHibernate to get the same results. But this one has an alternate ending.

List of SQL Server programming hacks, tips and tricks