Great infographic on Shopping Cart Abandonment Rate Statistics
Source: invesp.com
Source: codeproject.com
Types of NoSQL datastores
Here’s an excerpt from an excellent article by Robert Rees @ ThoughtWorks…
Source: thoughtworks.com
Managing Geeks?
then read this…
Embed Source Code In Tumblr Blog Posts Using GitHub Gist
Being a developer, we often write code related blog posts and often struggle with its’ formatting. Here’s what I need:
- Render code with good formatting
- Allow copy and paste
- Allow me to manage changes to the code
It’s been around for a while now, but Gist deserves to be the source view provider on all blogs. This post details how to get that to work on Tumblr in less than 5 minutes.
All CSS Vertical Navigation Menu Ribbon
Here’s a working demo.
I was on a mid size business site recently and happened to discover how they did their vertical navigation menu ribbon. This is no rocket science, but was surprised that they had built a space ship by embedding image tags and additional spans, stuff that should be pure CSS concern, to their DOM.
Inserting Large Amounts Of Data In SQL Server
SQL Server supports importing data from text files. This is a really performant way to insert large data sets in a single operation. The following example imports it from a CSV file:
bulk insert test from ‘C:\data.csv’
with
(
fieldterminator=’,’,
rowterminator=’\n’
)
I used this technique in Socialtops to insert large amount of data for SQL processing.
SQL Server Data Archiving
Lets say you want to archive data (from @table1) between a date range to an archive table (@table2). SQL Server 2008 and beyond support the following:
delete from @table1
output deleted.* into @table2
where CreatedOn >= @dateDay1 and CreatedOn < @dateDay2
As soon as rows are deleted from @table1, they are first moved to the DELETED internal table, which are then copied to @table2
Source: sqlservercurry.com
EF Annotations List
From EF 4.2 Code First Walkthrough:
The full list of annotations supported in EF is;
- KeyAttribute
- StringLengthAttribute
- MaxLengthAttribute
- ConcurrencyCheckAttribute
- RequiredAttribute
- TimestampAttribute
- ComplexTypeAttribute
- ColumnAttribute
Placed on a property to specify the column name, ordinal & data type- TableAttribute
Placed on a class to specify the table name and schema- InversePropertyAttribute
Placed on a navigation property to specify the property that represents the other end of a relationship- ForeignKeyAttribute
Placed on a navigation property to specify the property that represents the foreign key of the relationship- DatabaseGeneratedAttribute
Placed on a property to specify how the database generates a value for the property (Identity, Computed or None)- NotMappedAttribute
Placed on a property or class to exclude it from the database
Source: blogs.msdn.com
