The benefit of this approach is that you can then regularly scan your entire code base for the use of .ExecuteReader and .ExecuteNonQuery knowing that there should be no cases of those methods, other than the exception cases you expect.

SQL

.NET

MySQL

SQL-Server

SQL COALESCE Function and NULL

23 Feb 2020 by essentialSQL

SQL COALESCE function and how you can test for null, and when present, substitute it for another value

SQL

SQL-Server

Using Docker for Local SQL Server Development

4 Feb 2020 by OwenDavies

This post outlines how to use Docker image for local SQL Server development.

Why is My SQL Server Query Slow?

7 Jan 2020 by Rion Williams

Troubleshooting SQL performance: identifying issues, optimizing queries, utilizing tools efficiently

SQL

SQL-Server

Use SQL to Calculate Median Values

29 Dec 2019 by essentialSQL

How to calculate the median value using SQL

SQL

SQL-Server

calendar

The Bug That Got Away

22 Dec 2019 by Rion Williams

Bug stories: Exposition, action, climax, resolution, or epic failures.

How to Shrink SQL Server Database Log File

2 Nov 2019 by Ghanshyam N Patel

How to shrink SQL Server database log file

SQL

SSMS

SQL-Server

Migrating your SQL Server Workloads to PostgreSQL

22 Sep 2019 by Shameel

This multi-part article series discuss migrating your databases, applications and services from SQL Server to PostgreSQL and discusses all the important information you need to be aware of, before beginning a migration project..

Migrating your SQL Server Workloads to PostgreSQL – Part 3

22 Sep 2019 by Shameel

Part 3 of this multi-part article series discusses the actual migration process: Schema and data migration, ETL/ELT, Reporting & OLAP, Scheduling and Applications & Services migration.. The post Migrating your SQL Server Workloads to PostgreSQL – Part 3 appeared first on The Developer Space..

PostgreSQL 12: New Features and Enhancements

21 Sep 2019 by Shameel

This article walks you through the summary of most important new features. enhancements and breaking changes in PostgreSQL 12.. The post PostgreSQL 12: New Features and Enhancements appeared first on The Developer Space..

PostgreSQL finally gets Stored Procedures

21 Sep 2019 by Shameel

This article describes the new Stored Procedure feature in PostgreSQL 11.5 and shows you how it differs from Functions.. The post PostgreSQL finally gets Stored Procedures appeared first on The Developer Space..

Migrating your SQL Server Workloads to PostgreSQL – Part 4

21 Sep 2019 by Shameel

Part 4 of this multi-part article series discusses Maintenance and Monitoring, High Availability, Load Balancing, and Replication and Environment Stabilization.. The post Migrating your SQL Server Workloads to PostgreSQL – Part 4 appeared first on The Developer Space..

Migrating your SQL Server Workloads to PostgreSQL – Part 2

21 Sep 2019 by Shameel

Part 2 of this multi-part article series compares SQL Server and PostgreSQL article, database structure, language differences, data type mappings, functions and operators and other important considerations for migration..

SQL Server’s sp_executesql Does Not Protect You from SQL Injection

18 Aug 2019 by Rob Kraft

SQL Server’s sp_executesql does not protect you from SQL Injection

SQL

SQL-Server

Query Plans in SQL

14 Aug 2019 by essentialSQL

Query plans in SQL

What is a Database Trigger?

14 Aug 2019 by essentialSQL

What is a Database Trigger?

SQL Truncate and Delete

14 Aug 2019 by essentialSQL

Truncate and Delete in SQL

SQL

Oracle

SQL-Server

What is the Difference between WHERE and HAVING Clauses?

14 Aug 2019 by essentialSQL

Difference between WHERE and HAVING clauses

SQL

SQL-Server

How Do I Combine Results from Several SQL Tables (Hint: There Are Three Ways)

14 Aug 2019 by essentialSQL

How to combine results from more than one table

SQL

SQL-Server

What are the Major Parts of a SQL DB?

14 Aug 2019 by essentialSQL

This post discusses the major parts of a SQL database

Learn about Stored Procedures

14 Aug 2019 by essentialSQL

In this blog post, you will learn about stored procedures

What is a SQL Server Data Dictionary?

14 Aug 2019 by essentialSQL

What is a Data Dictionary in SQL Server?

SQL

SQL-Server

Learn to Use SQL Server Date Functions

14 Aug 2019 by essentialSQL

How to use SQL Server Date functions

SQL

SQL-Server

Smooth Transactions with TransactionScope

3 May 2019 by Rion Williams

Smooth transactions with TransactionScope

SQL COALESCE Function and NULL

26 Apr 2019 by essentialSQL

SQL COALESCE Function and NULL

SQL

SQL-Server

SQL Server Hierarchical Query using the hierarchyid Type

26 Apr 2019 by essentialSQL

SQL Server Hierarchical Query using the hierarchyid type

SQL

SQL-Server

SQL DISTINCT Clause For SQL Server

25 Apr 2019 by essentialSQL

SQL DISTINCT Clause For SQL Server

SQL

SQL-Server

combination

Common Data Types used in SQL Server

13 Mar 2019 by essentialSQL

Examples of common data types in SQL Server and how to define them

SQL

SQL-Server

A Simple Way to Check Vulnerability Status of your SQL SERVER Database

10 Mar 2019 by Rajat-Indiandotnet

As a product owner, you always worried about the different security aspects of your application and SQL Server Database is one of the main important parts for which you might worry.

The Content Database has a Schema Version which is Not Supported by this Version

6 Mar 2019 by Melick

How to copy your production SharePoint database to development environment

Use Subquery with Bill of Materials

3 Mar 2019 by essentialSQL

In this puzzle, we’re going to learn how to work with the AdventureWorks Bill of Materials table. Companies use a BOM (Bill of Materials) to itemize the products that are used or contained in another product. Solving puzzles is a great way to learn SQL.

SQL

SQL-Server

Random Value Per Row in SQL

8 Jan 2019 by Jeremy Hutchinson

Update table rows with varying random values in SQL

SQL

SQL-Server

Azure – Creating an Azure SQL Database

27 Dec 2018 by Vivek Johari

Creating an Azure SQL Database Contents Introduction Creation of Azure SQL Database Step 1: Select Database Name Step 2: Select Azure Subscription Step 3: Choose Resource Group Step 4: Choose Database Source Step 5: Choose SQL Server Step 6: Choose Elastic Pool Option Step 7: Choose Service Tier for

Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool

24 Nov 2018 by Vivek Johari

Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool Contents Introduction Microsoft Database Migration Assistant (DMA) tool Migrate SQL Server database To Azure SQL Instance using DMA tool Detecting the compatibility issues using Assessment Type

Computed Columns in SQL Server

29 May 2018 by Manjuke Fernando

Computed columns in SQL Server

How Easily You Can Unpivot the Pivot Data in SQL Server?

22 Apr 2018 by Rajat-Indiandotnet

How to easily unpivot pivot data in SQL Server

SQL-Server

ROW LEVEL Security SQL SERVER 2016

22 Apr 2018 by Rajat-Indiandotnet

Row Level security SQL Server 2016

SQL-Server

security

Why Would You Use Common Table Expressions?

10 Apr 2018 by Gaston Verelst

Why you would use Common Table Expressions

SQL Server’s LocalDB Database Engine

22 Jan 2018 by Steve Naidamast

SQL Server's LocalDB database engine

SQL-Server

Learn to Use the Data Dictionary in SQL Server

30 Dec 2017 by essentialSQL

In this puzzle, we’re going to learn how to query the data dictionary using SQL Server.

SQL

SQL-Server

Learn How to Calculate the Median Value using PERCENTILE_DISC

30 Dec 2017 by essentialSQL

In this puzzle, we’re going to learn how to find the person whose birthday, among others, is in the middle.

SQL

SQL-Server

What is a Dynamic Pivot Table?

30 Dec 2017 by essentialSQL

In this puzzle, we’re going to learn how to create a dynamic pivot table using SQL Server.

SQL

SQL-Server

Use SQL Server to Create a Cross Tab Query

30 Dec 2017 by essentialSQL

In this puzzle, we’re going to learn how to create a cross tab query using SQL Server.

SQL

SQL-Server

Learn How to Work Joins and Messy Data

30 Dec 2017 by essentialSQL

How to join dirty data using SQL Server

SQL

SQL-Server

How Do I Use the Like Clause in SQL Server?

30 Dec 2017 by essentialSQL

In this video, we'll walk you through how to use the LIKE clause.

SQL

SQL-Server

Introduction to Stored Procedures for SQLServer

30 Dec 2017 by essentialSQL

Benefits of stored procedures and how to create and execute them

SQL-Server

SQL Server and Set Operations

30 Dec 2017 by essentialSQL

SQL set operations

SQL-Server

C#. Static Cache and Multithreading

22 Sep 2017 by Anton Burtsev

A few months ago, I had to optimize web portal (classified ad). The portal was built on ASP.NET 1.1. It seemed that portal had two main problems. Here is how I solved them.

SQL-Server

ASP.NET

Schedule a Daily Backup with SQL Server Express

30 Jun 2017 by outcoldman

Schedule a daily backup with SQL Server Express

Change Tracking Example -SQL Server

1 Mar 2017 by Neeraj Kaushik1980

Following are the step by step instructions to enable and use the change tracking feature in SQL Server.

SQL-Server

Cross Join Introduction – Create Row Combinations

29 Dec 2016 by essentialSQL

Introduction to cross join - create row combinations

Uncommon SQL Server Data Types

29 Dec 2016 by essentialSQL

Uncommon SQL server data types

SQL-Server

Considerations for SQL Server on Linux

18 Dec 2016 by Afzaal Ahmad Zeeshan

Overview of SQL Server on Linux

Linux

SQL-Server

Understanding JOINs in SQL Server

4 Dec 2016 by Manjuke Fernando

It's very important to know what sort of JOINs are available in SQL Server and where exactly we can use them, in order to produce accurate results.

Introduction to SQL Server Data Modification Statements

4 Nov 2016 by essentialSQL

Introduction to SQL Server Data Modification statements

SQL-Server

Always Encrypted Feature in SQL Server 2016

19 Oct 2016 by Manjuke Fernando

Always encrypted feature in SQL Server 2016

Creating Custom Key Store Provider for SQL Always Encrypted (Without Key Vault Example PoC)

16 Oct 2016 by Z Kavtaskin

How to create a Custom Key Store Provider for SQL Always Encrypted (Without Key Vault Example PoC)

DROP IF EXISTS in SQL Server 2016 (DIE)

24 Aug 2016 by Manjuke Fernando

DROP IF EXISTS in SQL Server 2016 (DIE)

Non Recursive CTEs Explained

14 Jul 2016 by essentialSQL

In this article, we explore non recursive CTEs (Common Table Expressions). This is a broad class, and basically covers every form of CTEs except those that call themselves. This other class is called the recursive CTEs; they are covered in the next article.

SQL

SQL-Server

CTE

Keyboard Query Shortcuts In SQL Server Management Studio

12 May 2016 by Sibeesh Passion

Some shortcuts that may be useful to you when you work with SQL Server Management Studio

SQL-Server

Generic Repository Pattern MVC

29 Apr 2016 by Mayur V Lohite

Generic Repository Pattern MVC

Progress Bar in Cell – Excel

18 Mar 2016 by johnniealan

This article describes about adding progress bar in cell.

Log4j2.xml Tweaks

3 Mar 2016 by Jameson Triplett

Log4j2.xml Tweaks

Index REBUILD vs. REORGANIZE in SQL SERVER

16 Feb 2016 by Manjuke Fernando

What is the difference between Index REBUILD and REORGANIZE and when exactly should you use it

SQL-Server

Repository Generator

5 Feb 2016 by jgauffin

Griffin DAL Generator – Take 2

Built-In Functions (SQL Server)

11 Jan 2016 by essentialSQL

Basic concepts of built-In functions in SQL Server

SQL-Server

Commonly used SQL Server Data Types

5 Jan 2016 by essentialSQL

Commonly used SQL Server data types

SQL-Server

Introduction to SQL Server’s Built-In Logical Functions

4 Jan 2016 by essentialSQL

Introduction to SQL Server's built-in logical functions

SQL-Server

Introduction to SQL Server’s Common String Functions

2 Jan 2016 by essentialSQL

Introduction to SQL Server’s Common String Functions

SQL

SQL-Server

Introduction to SQL Server’s Built-In Conversion Functions

2 Jan 2016 by essentialSQL

Introduction to SQL Server's built-in conversion functions

SQL

SQL-Server

Christmas Carol: XML Signatures

30 Dec 2015 by Ivan Krivyakov

Christmas Carol: XML Signatures

SCALA : TESTING OUR CODE

14 Dec 2015 by Sacha Barber

So last time we looked at how to use Slick to connect to a SQL server database. This time we look at how to use one of the 2 popular Scala testing frameworks.

Scala

SQL-Server

Load XML And Show As li In Angular JS

17 Nov 2015 by Sibeesh Passion

How to load an XML file and show as li using ng-repeat in Angular JS

Using Black Falcon Software’s SQL Server Source Control for Developers

5 Nov 2015 by Steve Naidamast

How to use Black Falcon software's SQL Server source control for developers

SQL-Server

Installation of SQL Server Express 2014 on Windows 10

6 Oct 2015 by Mithun Pattankar

Step by step process of installation of SQL Server Express 2014 on Windows 10

Windows

SQL-Server

Test Cases Statistics with SSRS and TFS Data Warehouse

26 Apr 2015 by Anton Angelov

Tutorial how to create test cases statistics for the automation status and their distribution by priority. Steps how to setup SSRS and TFS Data Warehose.

XML Manipulation With XML Copy Editor

16 Feb 2015 by Keyhole Software

XML Manipulation With XML Copy Editor

Get Ready to Learn SQL Server 20: Using Subqueries in the Select Statement

6 Feb 2015 by essentialSQL

This is the second in a series of articles about subqueries. In this article, we discuss subqueries in the SELECT statement’s column list. Other articles discuss their uses in other clauses.

SQL

SQL-Server

How to Connect ASP.NET Website to Remote Database for CRUD Operations

10 Jan 2015 by Afzaal Ahmad Zeeshan