SQL Server

SQL-Server

Great Reads

How to Set Default Value or Binding for BLOB DataTypes on SQL Server

by Wonde Tadesse

This tip/trick helps to set a default value for blob data type such as Image, VarBinary.

Entity Framework: Storing Complex Properties as JSON Text in Database

by Jovan Popovic(MSFT)

Mapping properties in EF model to database columns that contain JSON

AJAX-enabled Name Selector User Control

by Steve Krile

Fully AJAX-enabled user control used to select names from a database in a drop-down format.

Create & Populate Time Dimension with 24 Hour+ Values

by Mubin M. Shaikh

Create time dimension with 24 hour plus values and time buckets in your data warehouse

Latest Articles

SQL Table Dependency Diagram Generator (SSMS 19)

by Bert O Neill

This article provides an overview for developers, on how to quickly generate a dependency Entity Relationship Diagram for a table and its immediately related tables, within SQL Server.

Reorganize and Rebuild Indexes and Update Statistics

by GabrieleTronchin

A simple stored procedure to add at your database to keep it reactive

Automatic Missing Indexes Creation Statements

by GabrieleTronchin

Automatic creation of non clustered indexes using system SQL entities

POCO Generator

by yuvalsol

POCO generating application for SQL Server

All Articles

top

SQL Server

A Gallery of Useful Programming Books

19 Jul 2014 by B. Clay Shannon

A list of useful programming books, some general, some platform- or language-specific

Javascript

CSS

.NET