Click here to Skip to main content
14,301,556 members

Database

Great Reads

by Jovan Popovic(MSFT)
Complex properties in entity Framework models such as arrays, dictionaries, and objects can be serialized in SQL Server database in JSON format. In this article I will show you how to map your properties in EF model to database columns that contain JSON.
by Daniel Miller
This article describes the C# implementation for a high-performance user/role security principal hierarchy.
by Wonde Tadesse
This tip/trick helps to set a default value for blob data type such as Image, VarBinary.
by Mubin M. Shaikh
Create time dimension with 24 hour plus values and time buckets in your data warehouse

Latest Articles

by Niemand25
Designing a simple yet functional database for financial accounting application.
by Shameel
This article describes different ways of setting up generated (computed) columns in different versions of PostgreSQL.
by Niemand25
Designing a simple yet functional database for financial accounting application
by Evgeniy Gribkov
Some aspects of LINQ query optimization for MS SQL Server

Discussions

by on article "SQL Index Manager – Free GUI Tool for...
by on article "SQL Index Manager – Free GUI Tool for...
by on Article "w to easily test your ADO.NET...
by on article "SQL 2016 - New Features"
by on article "MySQL Auto Failover using Keepalived...

All Articles