An overview of how to design a scalable Multi-Tenant Database using Row-Level Security Predicate Functions and DDL triggers to enforce that all shared tables are always restricted according to the tenant.

SQL

SQL-Server

Audit Tables and Data Versioning on SQL Server

23 Nov 2021 by Rick Drizin

Simple structure for keeping SQL Server Auditing Tables and Versioned Records in the same set of tables, using Audit Triggers and Entity Framework

NoSQL or not NoSQL?

9 Nov 2021 by Daniele Fontani

That is the question. A comparison between these two technologies and some tips to choose the best that suits your needs.

SQL Index Manager – Free GUI Tool for Index Maintenance on SQL Server and Azure

7 Nov 2021 by Sergii Syrovatchenko

Open source index maintenance tool for SQL Server and Azure

Entity Factory - Get Your ORM-less Freak On!

4 Nov 2021 by #realJSOP

A tool to generate model and viewmodel classes directly from your selected database

Configure Named Pipe and TCP/IP Settings of SQL Server

27 Oct 2021 by Hardik.Sheth1717

How to configure Named Pipe and TCP/IP settings in SQL Server

SQL-Server

Step by Step Installation of Microsoft SQL Server on Windows System

26 Oct 2021 by Hardik.Sheth1717

How to install Microsoft SQL Server on a Windows system

SQL

SQL-Server

SQL Server JSON: Performance Cookbook

25 Jul 2021 by Sergii Syrovatchenko

Here's everything you need to know about high-performance JSON parsing for SQL Server

Rednet DataAccess

18 Jul 2021 by Rednet Software

Rednet.DataAccess is yet another component to work with data that simplifies your use.

6 Steps to Enable Transactions in WCF

23 Jun 2021 by Shivprasad koirala

6 steps to enable transactions in WCF

Artisan Way of Data Reply

10 Jun 2021 by Vadim Loboda

A way to deliver more details about an error or exception from an SQL Server database through an ASP.NET web application to a web client.

.NET

ADO.NET

SQL-Server

Vector: A Concept-Driven Approach to SQL UDT

26 May 2021 by Giovanni Bejarasco

A walkthrough in UDT programming with primary focus on database concepts

Intelligent Combobox for MySQL/SQL Server Database Applications using VB.NET/C#

8 May 2021 by Ralf Meier, Shah Samiur Rashid

Codeless Combobox for VB.NET/C# platform with MySQL/SQL Server database applications

SQL Server Express Edition on Steroids

13 Mar 2021 by Sergii Syrovatchenko

How to omit many restrictions on SQL Server Express Edition

A Connection String Manager for Multi-Environment Ecosystems

9 Mar 2021 by #realJSOP

This library is intended for use in a multi-environment system, but it certainly be used under less stringent environmental confines, even down to a single desktop machine taht needs to connect to a single database server.

EF Core 5 Data Migration in .NET 5: in a Separate Library and Automatic Deployment

15 Feb 2021 by kusnaditjung

How to create Entity Framework Core 5 data migration in .NET 5

A Model to Represent Directed Acyclic Graphs (DAG) on SQL Databases

26 Jan 2021 by Kemal Erdogan

Addressing the general problem of representing directed acyclic graphs (DAGs) in SQL databases

Using the PetaPoco ORM to Manage SQLServer, SQLIte, MySQL and ProgreSQL Databases

10 Dec 2020 by Leif Simon Goodwin

Simple WPF app that shows how to use PetaPoco library to manage an SQL database

Introduction to NoSqlOnSql Implementing NOSQL on SQL

15 Oct 2020 by Jose Segarra

Implementing NOSQL on SQL

Export All Tables from Microsoft SQL Server Database in Flat File format (csv, txt) at one Go !!

14 Jul 2020 by Mubin M. Shaikh

Walkthrough of the process for one of the industry best practices to export all SQL tables in Flat file format

SQL Query Performance Improvement in SQL Server

4 Jul 2020 by Mahesh Pratap Singh

SQL Query performance improvement in SQL Server for large data

Artisan.Orm or How to Reinvent the Wheel

15 Jun 2020 by Vadim Loboda

ADO.NET Micro-ORM to SQL Server

Instant Low Code Database Web App - ASP.NET Core 3.1 Single Page Application(SPA).

2 May 2020 by Kalvin Lawrence Ernst

A sample application code which is an alternative to using libraries such as AngularJS, React, Vue, etc. Only jQuery and bootstrap are used in conjunction with vanilla JavaScript, HTML and CSS.

Creating Simple Audit Trail With Entity Framework Core

11 Apr 2020 by DiponRoy

Store all data change history in a table using Entity Framework Core

entity-framework

SQL-Server

A Fast and Lightweight Solution for CQRS and Event Sourcing

8 Apr 2020 by Daniel Miller

Describes a fast, lightweight implementation of the CQRS+ES pattern using C#

Return DataTable Using Entity Framework

5 Apr 2020 by DiponRoy

Select data as DataTable object for a database using Entity Framework

DayPilot - AJAX Monthly Event Calendar for ASP.NET MVC in 10 Minutes

11 Mar 2020 by Dan Letecky

Create an AJAX monthly event calendar (with drag and drop support) displaying data from SQL Server database in just 10 minutes (including a coffee break).

Automating the SQL Database Mirroring Setup

30 Dec 2019 by Dathuraj Pasarge

Database mirroring setup without any DBA effort - on every new database creation

SQL Server Performance Issue After An Upgrade

9 Dec 2019 by Kanishka Basak

Analysis and troubleshooting a database performance bottleneck

Line of Business Application, the New Way

29 Nov 2019 by Weifen Luo

The new way to develop LOB applications

.NET

WPF

SQL-Server

DBF to SQL Server

20 Nov 2019 by Igor Krupitsky

Application lets you copy tables from folder with DBF files to SQL Server

SQL-Server

SQL Browser

2 Nov 2019 by Alaa Ben Fatma

Explore your MMSQL server tables in a professional way

SQL Server Database :: Source Control, Continuous Integration and Continuous Deployment using Github, TeamCity and Octopus

20 Oct 2019 by Ravi K. Acharya

The complete step-by-step guide to build a CI/CD pipeline for your Microsoft SQL Server database using Github, TeamCity and Octopus.

SQL Server Database :: Continuous Integration using Github and TeamCity

20 Oct 2019 by Ravi K. Acharya

Second part of the step-by-step guide to build a CI/CD pipeline for your Microsoft SQL Server database using Github, TeamCity and Octopus

C++ Hibernate

25 Sep 2019 by Edwig Huisman

A hibernate framework for C++

Migrating Your SQL Server Workloads to PostgreSQL – Part 1

22 Sep 2019 by Shameel

Part 1 of this multi-part article series discusses Open Source considerations, history of SQL Server and PostgreSQL, choosing the right PostgreSQL version for your needs and On-Premise vs Cloud comparison

Restrict Access to SQL Server Data using a Facade Database

7 Sep 2019 by Shameel

This article describes a way to create a Facade Database to provide restricted access to specific tables in your databases to specific users without granting direct access to any of the underlying databases/tables.

SQL-Server

best-practices

database

Adding EntityFrameworkCore Support to .NET Core Project

13 Aug 2019 by Benktesh Sharma

Demonstrate how to add EF support in .NET Core project

My Favorite Filter Queries SQL, C#, Entity Framework, Lambda Expression

15 Jul 2019 by DiponRoy

Conditinal filter query example in SQL, Lambda Expression, C#

Using SQL Server 2017 Docker Container for Local Web API development in .NET Core

14 Jul 2019 by Viswanatha Swamy

In this article, we will be looking at how to use SQL Server 2017 Docker image for Local Web API development.

SQL Server: DateTime Range Pro

11 Jul 2019 by DiponRoy

Populating DateTime range in SQL Server

SQL

SQL-Server

DateTime

Sql Server: Just Started Working With CLR Using C#

2 Jul 2019 by DiponRoy

Creating CLR in SQL Server

SQL

SQL-Server

CLR

Using CURSOR in Different Databases

27 May 2019 by DiponRoy

Creating or using cursor in SQL-Server, Oracle, MySQL, PostgreSQL databases

Strange Behavior on JSON_VALUE When Table Contains Blank and Non-blank Values (JSON Text is Not Properly Formatted. Unexpected Character '.' is Found at Position 0.)

12 May 2019 by Manjuke Fernando

Observations made for a strange behavior on JSON_VALUE when table contains blank and non-blank values

Create Your Own SQL Server Management Studio 17 (SSMS) Extension

7 Apr 2019 by Stefan Timovski

A short tutorial on how to get started with creating SSMS extensions

Security on the Web by Advanced Encryption Standard (AES) and Security Assertion Markup Language (SAML)

3 Apr 2019 by Mahsa Hassankashi

Best approach for having more secure channel to transfer user information throughout the web

Automatic Table Generation in any Database by NHibernate ORM and CodeDom for Code Generation

3 Apr 2019 by Mahsa Hassankashi

This article enables you to generate table in any database such as Oracle, SQLServer, MySQL, SQLite, Sybase, etc. just by typing table name and its fields. Then you can use NHibernate facilities to make query for data layer.

Indexed Views and How It Can Help in Improving Query Performance

23 Mar 2019 by Minh Tuan Do

A considerable method to speed up query running time

Complete Guide to Install SharePoint in a Three Server Farm using AutoSPInstaller

14 Feb 2019 by Melick

This is a complete guide to install SharePoint in a three server farm using AutoSPInstaller

SharePoint 2016 Installation using AutoSPInstaller Online Part 1 – Setting up the Environment and Service Accounts

3 Feb 2019 by Melick

SharePoint 2016 Installation using AutoSPInstaller Online - how to set up the environment and service accounts

AppFabric Installation Failed Because Installer MSI Returned with Error Code: 1603

27 Jan 2019 by Melick

How to resolve the issue: AppFabric installation failed because installer MSI returned with error code: 1603

Authenticate .NET Core Client of SQL Server with Integrated Security from Linux Docker Container

10 Jan 2019 by Andi Kleinbichler

Illustrates the implementation of a .NET Core app, running in a Linux container, connecting to a SQL Server database with integrated security.

Point In Time Restore for Azure SQL Database

8 Jan 2019 by Vivek Johari

This article discusses the step by step process of point in time restore for Azure SQL database, Azure automatic backups as well as database backups retention period.

Document SQL Server Databases with CatFactory.UI

2 Jan 2019 by HHerzl

Document SQL Server Databases with CatFactory.UI

SQL-Server

Build Configurations for Publishing SQL Server Database Projects

30 Dec 2018 by mohghaderi

Add Debug/Release deployments to SQL Server database projects using build events and powershell

.NET

SQL-Server

Dev

Custom String Split Function with Few Enhancements

26 Dec 2018 by Wendelius

This article shows a custom SQL Server function to split a string delimited by a character or a set of characters. The function also contains a few handy enhancements.

Dynamic Pivoting with Cubes and eventhandlers in SQL Server

19 Dec 2018 by Herman<T>.Instance

In this article, the creation of dynamic pivots are explained. This works on SQL Server from version 2005 and above!

SQL Triggers – An Introduction

10 Dec 2018 by Vivek Johari

This article “SQL Triggers – An Introduction” will give you the detailed knowledge about the SQL Triggers which can be very helpful in your work.

How to Migrate SQL Database to Azure SQL Database using SSMS Deploy

25 Nov 2018 by Vivek Johari

This post discusses how to migrate SQL database to Azure SQL database using SSMS deploy.

How to Migrate SQL Database to Azure SQL Database using SSMS Export/Import

19 Nov 2018 by Vivek Johari

Migrating SQL Database to Azure SQL Database using SSMS Export/Import Contents

HoopDream

17 Nov 2018 by Terence Wallace

A brief article on how to utilize NBA Stats API in a WinForm application

ASP.NET Core 1.1 and Identity Adventures

13 Nov 2018 by Vlad Neculai Vizitiu

ASP.NET Core 1.1 and Identity Adventures

LINQPad, A Developer’s Best Friend

13 Nov 2018 by Vlad Neculai Vizitiu

LINQPad - a developer’s best friend

Migrate Data from SQL Server to Azure Cosmos DB

8 Nov 2018 by Srinivasa Dinesh Parupalli

Importing Documents from SQL Server to Azure Cosmos DB

MsSql.RestApi - The Easiest Way to Build the ASP.NET REST API

5 Nov 2018 by Jovan Popovic(MSFT)

Create powerful REST API with just few lines of C# code using MsSql.RestApi package

Web API in ASP.NET Core 1x

24 Oct 2018 by HHerzl

Creating Web API in ASP.NET Core 1x

Learning Entity Framework (Day 4): Understanding Entity Framework Core and Code First Migrations in EF Core

9 Oct 2018 by Akhil Mittal

Entity framework core, code first migrations and data annotations in EF Core

ASP.NET Core and Blazor on Mac: Dockerizing Applications

6 Oct 2018 by Vincent Maverick Durano

A step-by-step demo on how to build and dockerize ASP.NET Core and Blazor apps on MacOS

Learning Entity Framework (Day 2): Code First Approach and Migrations in Microsoft .NET Entity Framework

28 Sep 2018 by Akhil Mittal

Code First Approach and Migrations in Microsoft .NET Entity Framework

The Power of Combination Formulas (for design and quality assurance) and Joins (for execution).

11 Sep 2018 by Steven L. Wentworth (12896862)

Using combination arithmetic to improve quality of SQL table design and execution

Streamline Log Shipping Failovers

29 Aug 2018 by Micah Nikkel

SQL script that dynamically generates the DR scripts for failing over/back all Log Shipped databases. While it makes even a single database failover/failback a more streamlined process, it's most helpful for servers with multiple databases, such as SharePoint, consolidated SQL Servers, etc.

SQL - Pivot with Grand Total Column and Row

16 Aug 2018 by Narapareddy Shyamprasad

SQL Dynamic Pivots

SQL

Windows

SQL-Server