Tableau is one of the powerful reporting tool which is on the market for over a decade. Here's a quick tour in designing BI reports with Tableau using Microsoft Dynamics AX 2012 R3/ Microsoft Dynamics 365 Finance and Operations.

Autogenerate Unit Tests For Your Database Objects - Visual Studio 2019 & 2022 (amd64) Extension

by Bert O Neill

Features and functionalities associated with Autogenerate DB Unit Test app

SQL-File Technology for Transact-SQL

by Sergei Y.Kitáev

Introduction to statically parameterized SQL language

All Articles

top

SQL Server

Understanding how SQL Server executes a query

2 Aug 2013 by rusanu

This article will help you write better database code and will help you get started when you have to investigate performance problems.

SQL-Server

Considerations for SQL Server on Linux

18 Dec 2016 by Afzaal Ahmad Zeeshan

Overview of SQL Server on Linux

Linux

SQL-Server

Why Would You Use Common Table Expressions?

10 Apr 2018 by Gaston Verelst

Why you would use Common Table Expressions

How to Fix Orphaned SQL Users

26 May 2013 by Tharaka MTR

This post will show you how to fix orphaned SQL users.

Cross Join Introduction – Create Row Combinations

29 Dec 2016 by essentialSQL

Introduction to cross join - create row combinations

Good Practices for Starting with Containers

2 Jun 2020 by Kevin Mack

Few ideas for strengthening micro-services architectures

Query Plan Caching - My SQL Server Nightmare

30 Apr 2012 by Martin Thwaites

If you have an issue with a slow part of a site after a large dataload, that you can't replicate after a DB restore, it's likely you could be dealing with a similar issue.

Windows

SQL-Server

SQL-Server-2005

Learn How to Work Joins and Messy Data

30 Dec 2017 by essentialSQL

How to join dirty data using SQL Server

SQL

SQL-Server

The Bug That Got Away

22 Dec 2019 by Rion Williams

One thing that I've always loved hearing about from fellow engineers or reading about on technical blogs are bugs. Nasty ones. Ones that keep you up at night and those that will wake you from a dead sleep. These are the ones that great stories are built upon, because like.

Uploading the Files – HTML5 and jQuery Way!

28 Nov 2014 by Afzaal Ahmad Zeeshan

Uploading the files - HTML5 and jQuery way

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

ROW LEVEL Security SQL SERVER 2016

22 Apr 2018 by Rajat-Indiandotnet

Row Level security SQL Server 2016

SQL-Server

security

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.

How to Bulk Insert Efficiently

23 Jul 2012 by Rui Inacio

To bulk insert efficiently, the SqlBulkCopy class must be used.

ADO.NET

SQL-Server

Fixing SSDT Unresolved Reference to Object Error

21 Mar 2013 by Rui Inacio

Fixing the SSDT unresolved reference to object error

SQL-Server

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

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

Progress Bar in Cell – Excel

18 Mar 2016 by johnniealan

This article describes about adding progress bar in cell.

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

SQL Server’s LocalDB Database Engine

22 Jan 2018 by Steve Naidamast

SQL Server's LocalDB database engine

SQL-Server

Deploying Full Stack ASP.NET Core with API and SQL Server Databases to Docker Containers

1 Dec 2022 by DotNetLead.com

Deploy existing ASP.NET Core UI, API, and SQL Server to Docker containers

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

Creating a Simple Sheet Designer in C#

11 Apr 2010 by Mohammad Elsheimy

Give the user the flexibility to design his sheet, report, bill, invoice, whatever.

What are the SQL Server Management Objects

29 Jul 2010 by User 6619207

About SQL Server Management Objects

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

SQL Server: Search Stored Procedure Create/Modify Date or Text using T-SQL

18 Mar 2012 by Justin Cooney

How to search Stored Procedure create/modify date or text using TSQL

SQL-Server

Gotcha #121008: SELECT @Variable vs SET @Variable in SQL-Server

23 Oct 2012 by MBigglesworth79

SELECT @Variable vs SET @Variable in SQL-Server

SQL-Server

Counting Consecutive Dates Using SQL

17 Feb 2013 by Tharaka MTR

How to count consecutive dates using SQL

Solution: The WITH MOVE Clause Can Be Used to Relocate One or More Files

9 Jan 2014 by Nitesh Kejriwal

The WITH MOVE clause can be used to relocate one or more files

SQL-Server

Processing SQL Server FILESTREAM Data: Part 2 - The Setup

22 Sep 2014 by Bob McGowan

Utilizing SQL Server FILESTREAM capabilities from .NET

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

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

Always Encrypted Feature in SQL Server 2016

19 Oct 2016 by Manjuke Fernando

Always encrypted feature in SQL Server 2016

Uncommon SQL Server Data Types

29 Dec 2016 by essentialSQL

Uncommon SQL server data types

SQL-Server

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

Serializing System.DateTime for SQL Server

28 Aug 2010 by Gediminas Geigalas

Learn how to serialize System.DateTime for use in SQL Server stored procedures

Windows

SQL-Server

Making the Best Use Out of Maintenance Plans on SQL Server

8 Sep 2010 by Raymund Macaalay

How to make the best use of the SQL Server Maintenance Plans

SQL-Server

How to Update a Table with a columnstore Index

15 Jul 2011 by rusanu

A technique to make tables with columnstore indexes updateable

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

How to Retrieve the File Size Used by a SQL Server Database on Hard Disk

17 Dec 2012 by Nitesh Kejriwal

How to retrieve the size of data files of all databases present in SQL Server and the actual amount used in these files.

SQL-Server

Dev

SQL Server: A Query Slow in SSMS, Fast in Application, WHY?

9 Jan 2013 by aasim abdullah

SQL Server: A Query Slow in SSMS, Fast in Application, WHY?

Get Ready to Learn SQL: 7. Simplified Data Modeling

23 Oct 2014 by essentialSQL

Simplified Data Modeling in SQL

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

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

10 Jan 2015 by Afzaal Ahmad Zeeshan

An overview for connecting an ASP.NET website or a web application to a remote SQL Server database

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

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)

SQL Server and Set Operations

30 Dec 2017 by essentialSQL

SQL set operations

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

SQL Server Hierarchical Query using the hierarchyid Type

26 Apr 2019 by essentialSQL

SQL Server Hierarchical Query using the hierarchyid type

SQL

SQL-Server

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

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

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.

How to unit test SQL Server 2008 database using Visual Studio 2010 – Part 3

23 Aug 2010 by atverma

This is the last article of the series “How to unit test SQL Server 2008 database using Visual Studio 2010”.

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

SQL-Server

SQL Server – Puzzle – Statistics are not Updated but are Created Once

4 Jun 2011 by pinaldave

SQL Server – Puzzle – Statistics are not Updated but are Created Once

SQL

SQL-Server

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – System and Time Data Types – Day 16 of 35

17 Aug 2011 by pinaldave

Tips from the SQL Joes 2 Pros Development Series – System and Time Data Types

SQL

SQL-Server

SQL Server Table Columns Under the Hood

31 Oct 2011 by rusanu

SQL Server table columns under the hood

SQL-Server

Serialization 101 - Part III: XML Serialization

1 Dec 2011 by MBigglesworth79

XML Serialization

SQL SERVER – Database Properties – Number of Users

26 Dec 2011 by pinaldave

SQL SERVER – Database Properties – Number of Users

SQL-Server

Use a SQL script to generate well formatted stored procedures in SQL Server

11 Feb 2012 by Rob Kraft

Use a SQL script to generate well formatted stored procedures in SQL Server

Windows

SQL-Server

Stored Procedure Naming Conventions

17 Apr 2012 by My Tech World

It is recommended that stored procedures shouldn't be prefixed with sp_ for two simple reasons.

SQL

SQL-Server

SQL SERVER – SmallDateTime and Precision – A Continuous Confusion

5 Jun 2012 by pinaldave

SQL Server - SmallDateTime and Precision - a continuous confusion

SQL

SQL-Server

SQL Server and Duplicate Indexes

6 Jun 2012 by Martin Thwaites

Finding and removing indexes in SQL Server is an excellent way to remove bottlenecks, especially if you've "inherited" the application.

Random Performance Findings

20 Aug 2012 by Andrei Ion Rînea

Some performance tips

SQL Server: Disable Logon Trigger Using DAC to Resolve Login Problem

17 Sep 2012 by aasim abdullah

Using logon trigger, users from valid IP addresses can be restricted, but what if you forgot to add in safe list. You will be unable to login though you have sysadmin rights. Use DAC to disable logon trigger.

SQL-Server

SQL-Server-2008

SQL-Server-2005

Data Import from Excel File and Build an Automated Insert Script to Export into Excel File or to Export into SQL Server Table

21 Jan 2013 by MJ Ferdous

Data Import from Excel File and building an Automated Insert Script to Export into Excel File or to Export into SQL Server Table

SQL-Server

Easy 8 Step HTML To SQL Data Transfer in a ASP.NET Web Form using jQuery, JSON, XML, Web Methods, node() Methods and Extension Methods.

7 Feb 2013 by Patrick Cunningham

This article uses 8 steps to create example of how to read and write from HTML to a SQL database in a .NET web application using jQuery, JSON, and XML.

TSQL Split a String by Delimiter

13 Apr 2013 by Shahriar Iqbal Chowdhury/Galib

TSQL split a string by delimiter

TSQL Recursive Split Function

3 May 2013 by Shahriar Iqbal Chowdhury/Galib

TSQL Recursive Split function

Transfer Users from One SQL Server to Another Including SID’s the Easy Way

5 Oct 2013 by Raymund Macaalay

How to transfer users from one SQL Server to another including SID's the easy way

SQL-Server

What are the Different Types of Database Backups?

14 Sep 2014 by derekman9707

Different types of database backups

Shrink All Databases on SQL Server

2 Nov 2014 by Manas Bhardwaj

This post is intended to be used as a hack for developers to release some disk space. Please do not use on actual production environments.

SQL

SQL-Server

DBA

XML Manipulation With XML Copy Editor

16 Feb 2015 by Keyhole Software

XML Manipulation With XML Copy Editor

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

Log4j2.xml Tweaks

3 Mar 2016 by Jameson Triplett

Log4j2.xml Tweaks

Introduction to SQL Server Data Modification Statements

4 Nov 2016 by essentialSQL

Introduction to SQL Server Data Modification statements

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

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

Random Value Per Row in SQL

8 Jan 2019 by Jeremy Hutchinson

Occasionally you need to update a table with a random value per row. And thanks to some optimizations SQL Server does, it’s not exactly straight forward.. If you just try to update with a random value like this, every row ends up with the same ‘random’ value.. update. MyTable. set.

SQL

SQL-Server

Common Data Types used in SQL Server

13 Mar 2019 by essentialSQL

In this video we’ll walk you though the common data types used in SQL Server; you’ll see examples of each type’s values, and how to define them.

SQL

SQL-Server

Why is My SQL Server Query Slow?

7 Jan 2020 by Rion Williams

As applications and their associated databases grow, things change. Rows get modified, schema get updated, and often, things can slow down.

SQL

SQL-Server

SQL Full Outer Join

29 Dec 2020 by essentialSQL

How to reconstruct full outer join in SQL using other join clauses

Update Progress with AJAX UpdatePanel

19 Nov 2009 by Kelum W. Ganegoda

This post demonstrates how to create an update progress with the UpdatePanel, similar to the one we can see in GMail.

SQL Server 2005

23 Dec 2009 by puri keemti

SQL Server 2005

SQL-Server

SQL-Server-2005

SQL Server - Undocumented Stored Procedure sp_MSforeachtable

14 Apr 2010 by Nuno M. F. Gomes

I'm not an every day SQL Server user but I use SQL Server regularly since 7.0 version until the 2005 version (not yet tried 2008 in a serious way) and from time to time I still find some nice hidden gems.A few days ago I needed to created a cleanup script for an application and one of the t

WPF: Merged dictionary parser depends on XML attribute order

13 Aug 2010 by Ivan Krivyakov

Attribute order should not matter in XAML, but sometimes it does...