Tutorial on how to set up an email subscription for reports generated in SSRS (SQL Server Reporting Services). Step by step explanations with a lot of images.

SQL

WCF

How to Write SQL – Understand Database Table Meanings and Relationships – Step 1

19 Jan 2016 by essentialSQL

How to Write SQL – Understand Database Table Meanings and Relationships – Step 1

SQL

database

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

Data Modeling Principles in Action

30 Dec 2017 by essentialSQL

How to do some basic data modeling

SQL

Learn about Stored Procedures

14 Aug 2019 by essentialSQL

In this blog post, you will learn about stored procedures

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.

Solution to the MSSQL Server “Suspect”

3 May 2013 by Shahriar Iqbal Chowdhury/Galib

Solution to the MSSQL Server “Suspect”

Generate insert Statements from a Specific Table Data using SQL Server

27 May 2013 by Tharaka MTR

Generate insert statements from a specific table data using SQL Server

ASP.NET MVC: Configuring ASP.NET MVC 4 Membership with a SQL CE Database

2 Dec 2013 by John Atten

Configuring ASP.NET MVC 4 membership with a SQL CE database.

SQL

MVC

ASP.NET

No More Stray User Tables in Master

19 Jul 2014 by Tim Golisch

The Master database often seems to be the "Lost & Found" bin of the SQL Server world. There are two popular ways for preventing this kind of problem. Read on...

Get Ready to Learn SQL: 10. Database Second Normal Form Explained in Simple English

21 Oct 2014 by essentialSQL

Database Second Normal Form explained in simple English

Get Ready to Learn SQL Server: 14. Introduction to Outer Joins

22 Oct 2014 by essentialSQL

Introduction to Outer Joins in SQL Server

SQL

dbase

SQL-Server

Get Ready to Learn SQL Server: 13. Introduction to Inner Joins

22 Oct 2014 by essentialSQL

Introduction to Inner Joins in SQL Server

SQL

SQL-Server

DBA

Postgresql: PostgreSQL Query Tuning - Indices

17 Jan 2015 by Ivan Korhner

Postgresql: PostgreSQL Query Tuning - Indices

SQL

Progress Bar in Cell – Excel

18 Mar 2016 by johnniealan

This article describes about adding progress bar in cell.

Azure Functions Tutorial – SQL Database

18 Apr 2018 by Sarmaad Amin

Often a service is required to connect to a database to perform some operations. In this post, we are going to look at having an Azure Function connect and insert a record in database table. We will showcase the usage on nuget packages and usage in Azure Function to automate package management.

Azure SQL vs AWS RDS: Performance and Cost

11 Aug 2017 by Jeremy Hutchinson

Azure SQL vs AWS RDS - performance and cost

SQL

WCF

What is the Difference Between a Subquery and Inner Join?

30 Dec 2017 by essentialSQL

In this puzzle, we’re going to learn how to rewrite a subquery using inner joins.

SQL

Get Started with Power BI Desktop

13 Mar 2019 by essentialSQL

In this guide, I’ll show you how to get started using Power BI. We’ll then get some sample data and use it to build a simple project.

Look Behind the IQueryable Curtain

21 Jul 2020 by Jeremy Likness

Learn how to parse complex expression trees, and even modify them to alter IQueryable results.

How to Deploy Entity Framework Database Migrations

2 Mar 2023 by Lee P Richardson

Deploy EF database migrations while avoiding security flags

SQL

security

database

Programming for Date Ranges

25 Sep 2009 by Charles Boyung

How to program for date ranges

SQL

Windows

Modifying GhostDoc XML Comment

15 Mar 2010 by Mahmudul Haque Azad

A simple trick to add to custom node to the XML commenting.in GhostDoc

What are the SQL Server Management Objects

29 Jul 2010 by User 6619207

About SQL Server Management Objects

SharePoint User Profile Export from the UserProfile Database

7 Sep 2011 by Eric Xue (brokensnow)

Extracting the entire UserProfile AD user details into a CSV file

SQL

Windows

Dev

SQL SERVER – Bad Practice of Using Keywords as an Object Name – Avoid Using Keywords as an Object

10 Dec 2011 by pinaldave

Avoid Using Keywords as an Object

SQL

SQL-Server

Counting Consecutive Dates Using SQL

17 Feb 2013 by Tharaka MTR

How to count consecutive dates using SQL

ADO.NET – What is Meant by SQL Injection Attack?

10 Feb 2014 by Arun Ramachandran India

ADO.NET - What is meant by SQL injection attack?

SQL

WCF

Get Ready to Learn SQL Server: 15. Combine Table Rows Using UNION

22 Oct 2014 by essentialSQL

How to combine table rows using UNION in SQL Server

SQL

DBA

database

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.

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

Always Encrypted Feature in SQL Server 2016

19 Oct 2016 by Manjuke Fernando

Always encrypted feature in SQL Server 2016

Can I have a CASE Statement in the WHERE Clause?

13 Mar 2019 by essentialSQL

A common question I get ask is whether I can have a CASE Statement in the WHERE Clause.

SQL

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

Conquer ASP.NET Boilerplate Query Performance in LINQPad, (Announcing LINQPad.ABP)

30 Jan 2020 by Lee P Richardson

Description of two ways to use LINQPad with ABP apps to solve performance problems

SQL

ASP.NET

ASP

Order of Execution in SQL Explained

7 Mar 2022 by essentialSQL

In this blog entry we do an overview of the order if execution in SQL.

SQL

database

3 Ways To Refactor EF Linq Queries w/o Killing Perf

7 Sep 2019 by Lee P Richardson

This blog post lists 3 days to refactor EF Linq queries without killing Perf

Execute Stored Procedures in Parallel

23 Mar 2010 by Raymund Macaalay

How to execute stored procedure in parallel

SQL

Repairing Suspect SQL Database

23 Aug 2010 by Raymund Macaalay

Repairing Suspect SQL Database

SQL

DBA

LINQ to SQL: Update several rows

13 Mar 2011 by Kristofer Kallsbo

Updating several rows using LINQ to SQL.

SQL

LINQ

How to Update a Table with a columnstore Index

15 Jul 2011 by rusanu

A technique to make tables with columnstore indexes updateable

How to Use Update Cursors in SQL Server

28 Jul 2011 by Manjuke Fernando

Using Update Cursors in SQL Server

SQL

Windows

ATL

Missing Server side dependencies - Problems and Solutions

7 Sep 2011 by Eric Xue (brokensnow)

Missing Server side dependencies - Problems and Solutions

SQL

Windows

Singularize Function in TSQL

13 Sep 2011 by Raymund Macaalay

Singularize Function in TSQL

SQL

All-Topics

Creating .In and .NotIn Extension Methods for NHibernate 3 Linq Provider

22 Jan 2012 by Gediminas Geigalas

Creating .In and .NotIn Extension methods for NHibernate 3 Linq provider

SQL

Utility to Generate Word Documents from Templates Using Visual Studio 2010 and Open XML 2.0 SDK - Part 4

24 Jan 2012 by atverma

Utility to Generate Word Documents from Templates Using Visual Studio 2010 and Open XML 2.0 SDK - Part 4

Join Hint in SQL - Guest Post by Joydeep Das

29 Jan 2012 by Kunal Chowdhury «IN»

Join Hint in SQL - Guest post by Joydeep Das

SQL

SQL-Server

NLog LayoutRenderer for Assembly Version

22 Nov 2012 by Sebastian Solnica

NLog LayoutRenderer for Assembly Version

Using LINQ to SQL for ETL projects

20 Jun 2013 by Bryan O'Connell

Using LINQ to SQL for ETL projects.

TSQL Function to Replace HTML Tags with Delimiter

6 Aug 2013 by Shahriar Iqbal Chowdhury/Galib

A custom function that will hunt down HTML tags and remove them

SQL

Windows

Best Practice Front-end Architecture using Microsoft ASP.NET MVC and Rivets.js

28 May 2014 by Ben Liebert

Best practice front-end architecture using Microsoft ASP.NET MVC and Rivet.js

Get Ready to Learn SQL: 7. Simplified Data Modeling

23 Oct 2014 by essentialSQL

Simplified Data Modeling in SQL

Get Ready to Learn SQL: 6. How to Group and Summarize your Results

23 Oct 2014 by essentialSQL

How to Group and Summarize your Results in SQL

Get Ready to Learn SQL: 5. Query Results Using Pattern Matching

23 Oct 2014 by essentialSQL

Query Results Using Pattern Matching in SQL

Getting Started With SQL Server: 2. Sort Your Query Results

24 Oct 2014 by essentialSQL

How to sort your query results in SQL Server

Get Ready to Learn SQL Server: 6 – Group and Summarize Your Results

29 Oct 2014 by essentialSQL

Grouping results returned from your queries using the GROUP BY clause

Using Dynamic SQL to create a Pivot Table

19 Mar 2015 by JammoD87

Using Dynamic SQL to create a Pivot Table

SQL

WCF

How Can I Find Duplicate Values in SQL Server?

4 Jan 2016 by essentialSQL

How to find duplicate values in SQL Server

SQL

server

jQuery Datatable With Server Side Data

25 Feb 2016 by Sibeesh Passion

In this article, we will learn how we can work with jQuery Datatables with server side data.

Introduction to the Merge Statement

12 Feb 2017 by essentialSQL

In this article, well explore how to use the MERGE statement. We discuss some best practices, limitations, and wrap-up with several examples.

SQL

Insufficient SQL Database Permissions for User 'Name: doman\SP_UserProfiles SID:

13 Mar 2017 by Melick

Insufficient SQL Database Permissions for User 'Name: doman\SP_UserProfiles SID:

SQL

SQL Puzzle: How to Rank Student Scores

25 Mar 2017 by essentialSQL

How to identify the top and bottom 25 percent to rank student scores

SQL

WCF

How to Use SQL Union in Set Operations

30 Dec 2017 by essentialSQL

How to write a SQL UNION without using Set operations

SQL

Joins Versus Subqueries SQL Puzzle

30 Dec 2017 by essentialSQL

Joins versus subqueries in SQL

SQL

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

Troubleshooting SQL Code Using Comments

3 Feb 2018 by Alvin Bunk

How to troubleshoot SQL code using comments

SQL

WCF

WHILE Loops in T-SQL Stored Procedures

13 Mar 2019 by essentialSQL

In this lesson, we’re going to learn about the While Loop. So, what is a While Loop? Well, While Loop is set up using a While statement. While statements are used to repeatedly execute a block of SQL statements.

T-SQL

SQL

SQL Server Hierarchical Query using the hierarchyid Type

26 Apr 2019 by essentialSQL

SQL Server Hierarchical Query using the hierarchyid type

SQL

SQL-Server

Keeping the lights on! – Architecting for availability?

5 Nov 2019 by Kevin Mack

Hello all, It’s been a while since I did a blog post outside of the weekly updates. But I wanted to do one in terms of conversations that I’ve been having a lot lately and seems to be largely universal. High Availability.

What Are Some Things I Can Do to Improve Application Availability?

12 Mar 2020 by Kevin Mack

What kinds of things should I avoid, or remove from my applications to improve my position moving forward

A Basic Walkthrough of SQL Schema

7 Dec 2020 by Jin Vincent Necesario

This article shows you the basics of SQL Schema using the DDL statements.

SQL

SQL-Server

schema

Postgres Notify for Real Time Dashboards

24 Mar 2021 by Arctype SQL

Using pg_notify in Postgres alongside the NOTIFY and LISTEN syntax is all that's needed to build a real time updating dashboard

SQL

PostgreSQL

Create a SQL Server Management Studio Extension

2 Jul 2021 by Kevin Chadney

Creating a simple SSMS extension which accesses the query window and object browser.

SQL

SSMS

SQL-Server

A Complete Tutorial to Connect Android with ASP.NET Core Web API

21 Jul 2021 by Aram Tchekrekjian

In this tutorial, we will learn how to connect Android with ASP.NET Core Web API.

What is a Database Cursor?

7 Mar 2022 by essentialSQL

Learn about a database cursor with an example and when to use it in a SP

SQL

database

How to Use SQL Variables in Queries

7 Mar 2022 by essentialSQL

In this video and the following article, we’ll take you step-by-step through the process of changing a query’s filter criteria into a SQL variable, then ultimately into a stored procedure.

SQL

database

Error Accessing Oracle Database Objects via Linked Server in SQL Server (The OLE DB provider "OracleOLEDB.Oracle" for linked server reported an error. Access denied.)

20 Jan 2016 by Manjuke Fernando

Error accessing Oracle Database Objects via Linked Server in SQL Server

Three-tier .NET Application Utilizing Three ORM Technologies

23 Dec 2009 by Bryan Thomas Weikel

CodeProject"LEK" is a three-tier .NET WinForms accounting application that can be configured at run time to use either LINQ to SQL, Entity Framework or NHibernate to access data in either a "main" or "testing" SQL Server database.

Serializing ArrayLists of Disparate Objects to XML Strings

7 Jan 2010 by Steve Wellens

In an earlier post here, I wrote two functions to Serialize and Deserialize objects to XML strings. Since then, while reading a book about XML, I learned of even more power in the .NET XML Serialization libraries*...

XML

SQL

Windows

SQL: Cleaning Up After the Database Tuning Engine Advisor

1 Nov 2010 by Martin Jarvis

Cleaning up after the database tuning engine advisor in SQL

SQL

Ad-hoc Pagination Support with SQL Server codenamed “Denali”

16 Nov 2010 by mazhou

Ad-hoc pagination support with SQL Server codenamed “Denali”

T-SQL

SQL