.NET Core 2.0 brings a lot of improvements to the system, and it brings a lot of pain to the developers as well. I had a lot of problems upgrading .NET Core 1.x apps to .NET Core 2.0; I yet have to feel the promise it makes about performance and so, but let us see how to upgrade our existing applica

T-SQL

C#7.0

SQL

.NET-Core

ASP.NET-Core

entity-framework

Dev

FOR XML Basics (AUTO Mode): 2 of 4

2 Jun 2017 by AhsanAhmed

A brief introduction on how to use FOR XML clause in AUTO mode in Microsoft SQL Server to return data in XML format

Debug Stored Procedures in Visual Studio and SSMS

18 Feb 2016 by Kuv Patel

Debug stored procedures in Visual Studio and SQL Server Management Studio.

How to extract overlapped polygons and calculate the overlapped area and write an API for it?

21 Oct 2017 by mahmood kabi

extract overlapped polygons and calculate the overlapped area and write an API for it

Automating the SQL Database Mirroring Setup

30 Dec 2019 by Dathuraj Pasarge

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

ASP.NET Web Component for editing SQL tables

29 Nov 2012 by RovenetBill

ASP.NET c# component for editing SQL tables with plug-in column format adapter architecture.

Unattended installation of SQL Server 2012

11 Jul 2016 by Jesus Carroll

Despite the references of several sources of unattended installation of Microsoft SQL Server Database Engine, in this article describes a script tested in real production environments and it can be used with minimal or - perhaps - no modifications.

Data Version Control on MS SQL Server (using a generic trigger)

4 Oct 2016 by Martin Lachman

How to create a system on MS SQL Server for detection of actual changed records in a database table.

FOR XML Basics (EXPLICIT Mode): 3 of 4

1 Jun 2017 by AhsanAhmed

A brief introduction on how to use FOR XML clause in EXPLICIT mode in Microsoft SQL Server to return data in XML format

spSearchTables: Search and Find Tables or Columns by Name or Value

21 Nov 2023 by Federico Di Marco

spSearchTables: a helper T-SQL stored procedure for digging into (large) databases

Decrypt SQL Server Objects

7 Dec 2016 by Kuv Patel

Decrypt Stored Procedures, Views, Functions, and Triggers in SQL Server

OVERachieving Progressive Sums in T-SQL

21 Apr 2016 by Emmanouil Gimissis MSc ICSD

Calculating progressive sums in T-SQL

T-SQL

SQL

SQL-Server

Dismantling Reggie

8 Nov 2021 by honey the codewitch

Deep dive some advanced source generation in a real world application

SQL Server Brute Force Attack Detection: Part 4

30 Apr 2018 by Ryan G Conrad

Using Powershell and Windows Task Scheduler API to detect malicious login attempts on a remotely accessible SQL Server database

Using NServiceBus in Azure Service Fabric

6 Jun 2018 by Gunnar S

Third article in a series of three regarding NServiceBus, WebAPI and Azure Service Fabric

OLAP for Free

20 Jun 2019 by IChechin

How to implement free OLAP cube in your project

T-SQL

OLAP

Continuous Integration for Database Development

14 Mar 2011 by Redgate Software

Continuous integration makes development more efficient – allowing bugs to be caught earlier, and providing rapid validation. But for too long, it hasn’t been standard practice for databases. This is an overview of implementing CI so you can bring database code in line with application development.

Filtering LINQ Queries Using Business Rules Engine

19 Nov 2012 by Code Effects

This article discusses the use of one such new feature, namely, rule-based filtering of LINQ queries using Web Rule, the XML-based super-fast rules engine, implementable as an ASP.NET or MVC component.

Visual Basic Using Reflection to Map DataTable in MySQL Database

5 Sep 2013 by Mr. xieguigang 谢桂纲

Easy way to map the table in the mysql database.

Searching SQL Server Databases with Red Gate’s SQL Search

1 Aug 2014 by Chris_Yates

When managing a large amount of servers and databases, having an efficient way to search for objects in a particular database, SQL Server instance or the object metadata is crucial. DBA Chris Yates tells us why SQL Search from Red Gate helps him achieve this with ease, and at no cost.

This will not be in BI (Purchasing a BI tool, you do not get this)

17 Apr 2016 by Alex_2979

A lot of modern Business Intelligence solutions offer to transfer work of analysts to developers or rise technical level of business analysts, make them closer to developers. Instead of it, I advise to consider a solution, which takes information from Database and gives it to business analysts.

Comparing Rows in SQL Server and Azure SQL Database

16 Jun 2016 by Jovan Popovic(MSFT)

How to easily compare two rows in SQL Server using new JSON functionalities

T-SQL

Azure

SQL-Server

Introducing SQL Clone

10 Mar 2017 by Redgate Software

SQL Clone exploits the existing virtualization technology within Windows to take much of the sting out of the traditional problems surrounding database provisioning.

SQL Coding Productivity in Visual Studio Enterprise with SQL Prompt Core

22 Sep 2017 by Redgate Software

If you could gain an extra hour in your working day, what would you spend it on? One way to save time and work efficiently, is to use tools available at your fingertips. Learn how SQL Prompt Core, included free in Visual Studio Enterprise, helps you speed up working with SQL and be more productive.

T-SQL

SQL

product-showcase

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

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

How to Repair Corrupt SQL Database using DBCC CHECKDB Command?

22 Aug 2024 by Stellar Data Recovery

Discover step-by-step instructions to repair SQL databases with DBCC CHECKDB, plus explore advanced tools for a quick and secure repair.

T-SQL

SQL

repair

Hidden Gems of DEFAULT TRACE in SQL Server

21 Mar 2016 by Sergii Syrovatchenko

Starting from SQL Server 2005, the default trace is enabled by default on every SQL server. Default trace is a lightweight system trace, which stores a lot of useful information about the changes in the system...

SQL Server Brute Force Attack Detection: Part 1

25 Mar 2018 by Ryan G Conrad

Prevent brute-force login attacks on a remotely accessible SQL Server database using T-SQL

Use one SSRS Report to Find All Your Microsoft SQL Servers, Out of Date Editions, and Service Packs

3 Oct 2016 by Mark W Solomon

In this article, I developed a way to determine all the SQL Servers in our environment at will and filter this information into Microsoft's Sunset report for Microsoft SQL Server and present all this information in an SSRS report.

Kerosene Dynamic Data Services

11 Mar 2014 by mbarbac

Implementing the Repository and Unit of Work Patterns dynamically using Kerosene ORM

FOR XML Basics (RAW Mode): 1 of 4

2 Jun 2017 by AhsanAhmed

A brief introduction on how to use FOR XML clause in RAW mode in MS SQL Server to return data in XML format

Using SQLite in C#/VB.Net

25 Jun 2018 by Dirk Bahle

A quick guide to managing 100000'ish records efficiently with SQLite and C#/.Net.

Node.js for .NET Developers by WCF

3 Apr 2019 by Mahsa Hassankashi

This article illustrates how to use Node.js by WCF which is written in C# and using node.js as real time communication technology with the aid of C# code to connect MS SQL Server.

SQL Server Monitor with Version Control

2 Dec 2011 by Huisheng Chen

Monitor SQL Server processes and jobs, view executing SQL query, kill process / job, object explorer, database shrink/log truncate/backup/detach/attach, object version control & compare

SQL for Developers: Basic Data Retrieval

11 Jan 2011 by Tim Corey

The developer’s guide to writing powerful SQL commands while avoiding the pitfalls that come from an incomplete knowledge of what is going on under the hood.

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!

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

SPADA-small SCADA for Arduino

24 Mar 2014 by jurhas

Supervisory Control and Data Acquisition for ARDUINO

Validate XML File with XSD Schema in SQL Server

7 Aug 2016 by Rahul S Chavhan

Validate an XML document in SQL Server using XSD by Rahul Chavhan

Simple Dynamic Scheduler

23 May 2016 by Miljan Radovic

Simple, open-source, fully customizable, lightweight SQL Server scheduler

High Level Data Profiler Script

3 Mar 2016 by Gene R. Browning

Get a quick look at your data characteristics using this tool.

Input, Output and Input/Output SqlParameter Behavior Explained

1 Nov 2016 by Bob Crowley

In this article, I will explain the sometimes surprising behavior of the ADO.NET SqlParameter and particularly the effects of ParameterDirection, null value and DBNull.Value on how the parameter is sent to the database.

What is Multi-tenancy

6 Feb 2017 by Anuja Pawar Indore

Multi-Tenancy means same instance shared amongst all customers.

SQL Wizardry Part One - Joins

23 Jan 2014 by Christian Graus

The first in a series of articles seeking to explain the intermediate to advanced features of T-SQL

T-SQL

SQL

SQL-Server

Introducing the Boomerang Framework

27 Sep 2010 by psined

Introduction to Boomerang Framework

SQL Server Table and Column Naming Conventions

30 Dec 2015 by Daniel Miller

This article describes standard naming conventions for tables and columns, and it provides code that leverages the conventions to visualize dependencies and automatically validate and generate foreign key constraints.

Active Directory Query using CLR Stored Procedure

17 Sep 2016 by Snorri Kristjansson

A SQL server CLR Stored Procedure that can query the Active Directory directly in T-SQL code

What Can JSON Do For You in SQL Server Database?

13 Jul 2018 by Jovan Popovic(MSFT)

Learn about various use cases how you can leverage JSON support in SQL Server and Azure SQL Database

DimDate Revisited (The Power of a View and Nested Whiles)

10 Dec 2017 by Steven L. Wentworth (12896862)

Straightforward generation of and ensuring accuracy for DimDate values

Using WCF REST HTTP to call Stored Procedures on SQL Server

11 Jun 2013 by Tom Glick Philadelphia, US

Using WCF REST Service to call Stored Procedures and run queries on SQL Server.

Single Page Application (SPA) for Enterprise App (Angular2 & WebApi) - Part 1 - Overview

20 Nov 2018 by tranthanhtu.vn

How to build the SPA for enterprise application using Angular2 and WebApi (RESTful)

SQL-File Technology for Transact-SQL

19 Dec 2022 by Sergei Y.Kitáev

Introduction to statically parameterized SQL language

SQL Simple Utilities

22 Sep 2016 by Alexandros Pappas

This project provides utilities for SQL server, such as executing a list of SQL scripts, exporting data to an SQL script, and displaying relationships between records.

Service for StackExchange: Implementing a Data Provider

5 May 2014 by Shuqian Ying

Client side data provider for data importing to a relational data service build for StackExchange data dump.

Database Mirrors with Differing Vendors

8 Jul 2011 by Dr Bob

SQL Server ISS can simplify database mirrors across multiple vendors

SqlDependency .NET library can work to detect updates automatically

24 May 2017 by Zahid Nawaz Ch.

SqlDependency ,can be used to pick changes without executing query to see there is any update from database , WHERE CLAUSE can also be applied for narrowing scope, Its way to push changes from SQL Server to SQLDependency , .NET library , SQL Server Broker service sends updates to SQLDependency.

Stored Procedure for Single & List Object in ASP.NET MVC with angularJS

9 Oct 2016 by Md._Mehedi_Hasan

CRUD operation in .net MVC using Stored Procedure for Single and List Object Data along with SQL Transaction.

SQL for Developers: Data Crunching

24 Jan 2011 by Tim Corey

The developer's guide to getting the right information out of mountains of data. Learn how to boil down the data into useful information while being confident that you haven't left any data behind.

The ETL Process and Range Lookups

3 Jan 2018 by Member 11127135

The ETL Process and Range Lookups

SQL Table Hierarchy

16 Aug 2016 by Alexandros Pappas

An SQL script to see the table hierarchy in a database.

URL Decode in T-SQL

1 Jul 2015 by Frank J. Yang

This article provides code for decoding strings that have been encoded for URL transmission in pure T-SQL that works properly for all URL encoded strings.

Add some AI to your combo box lookups

15 Dec 2010 by hector [.j.] rivas

Helping the combo box autocomplete function with a frequency count.

artificial-intelligence

Creating Date dimension from scratch in Microsoft SSAS

12 Dec 2015 by Miljan Radovic

Script to generate DimDate for specified date range

How to use geometry datatype in SSIS for an intersect query

21 Nov 2016 by sunettew

In this article we will show how you can use SSIS with geometry and intersect.

T-SQL

.NET

data

SqlCommand to T-SQL Printer

22 Mar 2018 by Robert Vandenberg Huang

An Entity Framework log printer that converts SQL commands to executable T-SQL statement

LINQ-to-EF Efficiency: A Cautionary Tale

26 May 2012 by meduff

Avoid Entity Framework lazy-loading relationship navigation when iterating large record sets.

Using locks to manage concurrent access to compound relational documents - for MS SQL and other servers

24 Aug 2016 by Roman Ivantsov

The article provides a comparative analysis and gives patterns of using explicit locks to manage concurrent access to database documents (data split over multiple tables) in MS SQL Server, MySql, PostgreSql and Oracle. As it turned out, the solution is not always obvious or simple.

Capture of a Typical SQL Server Database Workload

29 May 2017 by Tomáš Bauer