Implement Repository, UnitOfWork with Audit support in Composable Service End

Implement Repository, UnitOfWork and Audit Log in Composable Service End

Entity framework supports optimistic concurrency out of the box but using pessimistic concurrency requires manual implementation. This article explains why simple solutions don't work and provides a working solution.

You can create a data alert to email notification in SQL Server 2012 reporting services. This data alert sends e-mail notification when only when specific conditions in the data are true at a schedule time. This Date Alerting feature is available only when reporting services runs in sharepoint integ...

Entity Data Model: The version of SQL Server in use does not support datatype ‘datetime'

Enabling SSIS logging is a tedious process in earlier versions. Integration Services Packages has the two options to log the information during the execution, one option is configure the log providers in each package and associate them to executables within the package. Second option is to use SQL s...

A sneak peak at the upcoming async capabilities in EF 6.0

AutoDetectChanges is one of the performance tuning options inside Entity Framework. This article explores how AutoDetectChanges effects performance and how and when it can be used with Entity Framework.

An explanation of how navigation properties in Entity Framework can be used. It gives basic examples of what you get by default and the additional configuration you can do with the model builder.

I recently did a presentation on performance with Entity Framework. This article presents a set of tips for how you can get the best from EF.

This is a verry short introduction to SQL Server Express 2012, LocalDB, and I’ll show you how to use it in conjunction with SisoDb (Simple, Structure, Oriented DB). I'll be using Chocolatey to install it.

A stored procedure can be called from another stored procedure as nested stored procedure. Recently on production server, we were asked for all stored procedures in which other stored procedures are called as nested. Here is simple script.

How to restrict VALID database users from INVALID machine IPs. Simple way to protect your SQL Server instance

In this episode, Woody sits down with Andrew Brust to discuss another “big” technology for developers and IT professionals: Big Data. Woody and Andrew talk about what Big Data is, who is using it, what tools are available and finally how we has technologists can use this for our products and service...