Category: SQL

0

Leverage FluentMigrator in ASP.NET Core 2.0

Let’s see how easy it is to use FluentMigrator in ASP.NET Core 2.0 🙂 If this is the first time you hear about FluentMigrator then here is the description from https://fluentmigrator.github.io/ Fluent Migrator is a migration...

0

SQL Server 2016 Live Query Statistics

The final version of SQL Server 2016 is been out for some time but I haven’t get a chance to talk about some of the new features. So it’s time to take a look...

Merge records in SQL Server 1

Merge records in SQL Server

Sometime multiple records have to be compared and somehow merged to update one record. Logically there should be some kind of for loop to go through all the records and find those matching and...