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.

SQL

SQL-Server

reporting

Microsoft

Four Pitfalls of SQL Processing with NULL Values

1 Nov 2022 by Tomas@PawSQL

How to cope with all scenarios regarding NULL value handling in your daily work

SQL

PostgreSQL

database

Auto Increment Column Options in Different Databases

4 Jul 2022 by DiponRoy

How to auto increment column options in databases

Build Dynamic Order by Clause in LINQ Query in C#

5 Jun 2022 by Ramesh Bevara

An overview of a helper class to build dynamic order by clause in LINQ query in C#

Schedule Generation of All Object Creation Scripts for All Specified SQL Server Databases

22 Apr 2022 by CMYork01

How to schedule generation of all object creation scripts

SQL

SQL for Listing Field(s) on Columns

11 Jan 2022 by Member 4206974

A tip to get a data list on 2 (or more) columns.

SQL

PHP

Delete All Rows in a Table in Entity Framework

28 Dec 2021 by DiponRoy

Delete all the records from the table using EF

Create .NET MVC Web Application using Visual Studio on Mac OS [Part 2]

1 Dec 2021 by Uladzislau Baryshchyk

Application that can be used to work with subd and connecting Amazon RDS to the project

Fetching Data from a Specific Week Relative to a Date in SQL

14 Sep 2021 by OriginalGriff

How do you get last weeks data only? It's a little more complex than you might have thought

SQL

Monitoring SQL Agent with Alerts for Long Running Jobs

2 Sep 2021 by Member 14691410

Providing admin with an alert mechanism via an SP

T-SQL

SQL

Windows

Why "Store Everything in UTC" is Bad Advice

4 Aug 2021 by Ondra Spilka

Let's explain the basics so developers understand weak spots of date and time handling

SQL

Javascript

UkrGuru.SqlJson is Perfect for your ASP.NET Core Web Application!

28 Jul 2021 by Oleksandr Viktor (UkrGuru)

Minimally simple UkrGuru.SqlJson package for your ASP.NET Core Web Application

Import a MS SQL Database to Amazon RDS

20 Jul 2021 by Uladzislau Baryshchyk

In this article, I'll show you how easy it is to move your MS SQL database to Amazon RDS cloud

Learn What is Cartesian Product in SQL

6 Jul 2021 by Toma Tsyhan

This article is about understanding the Cartesian Product in SQL followed by some examples.

SQL

Security Vulnerabilities – How to Find and Fix Them

2 Jul 2021 by datarockets

Finding a vulnerability, using it for data extracting from the database, and fixing it with just one line of code

Retrieve Unsaved/Lost SQL Script Files due to SSMS Crash or Accidental SSMS Termination

20 Jun 2021 by Elisha Cornelius

Recover SQL Script files that are lost due to SSMS Crash or whatever the other reasons

SQL

Control Maximum Number of Rows in a Table

1 Jun 2021 by Wendelius

How to prevent insert for record when maximum number of rows has been reached

SQL

Dev

Architect

Auto Generate a Lot of Columns in Reporting Services (RDL)

15 May 2021 by be05x5

SQL script that will generate XML code that you can copy paste into your RDL file and just do it that way

SQL

XML

RDL

Import or Restore BACPAC File using SQL Server Management Studio

6 Apr 2021 by Satya Karki

How to import or restore BACPAC file using SSMS

Compare Two Databases, Find Differences and Update using Visual Studio

5 Apr 2021 by Rijwan Ansari

How to compare two databases using SQL Server Database Project (Template) available in VS.

SQL

Visual-Studio

database

How to Create SQL Server Database Project With Visual Studio

4 Apr 2021 by Rijwan Ansari

Learn about SQL Server Database Project (Template) available in VS

Top 8 New SQL Features of MySQL 8

16 Mar 2021 by Yuri Danilov

An overview of Top 8 new SQL features of MySQL 8

SQL

MySQL

Freehand Drawing using Google Map and Spatial Search

15 Mar 2021 by Pablo A Martinez

How to use Google map and Spatial search to do freehand drawing

How to Calculate the Check Digit on a Columbia Gas Account Number

19 Nov 2020 by cattman1970

Function that consumes a Columbia Gas account number of 11+ digits and returns the check digit

SQL

SQL-Server

Dev

A PostgreSQL Notification Example

15 Oct 2020 by RickZeeland

PostgreSQL notifications Windows Forms application

RSA Encryption in PL/SQL

12 Aug 2020 by Juan F. Paleo

Encrypt data with RSA Public Key

Postgres Foreign Table Example

9 May 2020 by Carlos Luis Rojas Aragonés

Snippet to get started with foreign tables

SQL

PostgreSQL

data

Get a Customized Table Structure With Non Null Fields Using Dynamic SQL

9 Apr 2020 by Jesus Carroll

In Data Engineering, supporting Data Science, Data Mining and Reporting tasks, it is useful to get only fields that have data. We don't mind nulls values and we are grateful if this field's structure is dynamic. These ones might be a stat in the set of empty's kingdom.

Removing the minutes and seconds from a DATETIME

24 Mar 2020 by OriginalGriff

A basic user defined function to remove minute and second from a DATETIME

SQL

Dev

Cascading Dropdown In ReactJS

1 Mar 2020 by Sanwar ranwa

How to create a cascading dropdown using ReactJS and Web API

Javascript

SQL

ReactJS

SMO Scripting Based on Dependency

17 Feb 2020 by Thava Rajan

Prepare script for specific objects

SQL

Code Generator for SQL Server

8 Jan 2020 by Homero Ibarra Ramírez

Tool on T-SQL to code basic generator for SQL Server

How to Create and Use a Self-referencing Hierarchical Table

8 Jan 2020 by E. Scott McFadden

This article explains how to create and use a self referencing key in a SQL Server Table.

Types Don't Match between the Anchor and the Recursive Part in Column...

28 Dec 2019 by Wendelius

How to overcome the error message "Types don't match between the anchor and the recursive part in column..." for varchar columns in a recursive CTE query

Select users with birthdate in the next 10 days

26 Dec 2019 by OriginalGriff

Select users with a birthday in the next "n" days is pretty easy, if you use the day of year. The only slight complication is the need to "wrap" round the year end.

SQL

SQL Server Backup Utility

30 Oct 2019 by Charles T. Blankenship

Backup and Restore SQL Server utility (where there is no SMSS onsite)

Select a Default Row in SQL

21 Jul 2019 by DiponRoy

Select a default row for a query that returns no rows

SQL Server: Find Week Start And End DateTime

10 Jul 2019 by DiponRoy

Finding week start and end date time from a given date time

SQL

SQL-Server

Busy Production Database Update Without Timeout

9 Jun 2019 by Prasannakumaran Sarasijanayanan

Load data to temporary table, make any additional update if required, create necessary indices, finally DROP live table and RENAME temporary table to production table.

SQL Server: Find Table Order/Generation And Relation Details

29 May 2019 by DiponRoy

A utility query to find table generations in SQL Server relational database

Is MS SQL Server Service Broker Responding to Read Uncommitted Data?

21 May 2019 by Herman<T>.Instance

When using SqlDependency, is it possible that a detected change leads to 0 rows in the SqlDependency results?

SQL Database Access

18 Mar 2019 by Martin Vorbrodt

SQL database access

SQL Server: Doing String Split And Join

19 Feb 2019 by DiponRoy

How to do string split and join in SQL Server

SQL Server: Select Single Row From Each Group

18 Feb 2019 by DiponRoy

Selecting single row from a group of rows

SQL

pSQL

SqlServer: Parameterized Query With IN() Clause C#

14 Feb 2019 by DiponRoy

A utility class to send parameters for IN() operator in SQL using parameterized queries

Continuous Integration and Delivery for Beginners (DevOps)

3 Feb 2019 by Thinira

Continuous Integration and Delivery with VSTS (Visual Studio Team Services)

How to Transfer a MySQL Database between Two Servers using SCP

4 Dec 2018 by Renz Ladroma

A guide to transfer your MySQL databases between two servers using the SCP method

SQL

Linux

MySQL

Improving Backup Performance

1 Oct 2018 by Satnam Singh CapGemini

Improving backup performance

Applying Database Principal Throughout the Server (for all Databases) for a Particular User

10 Sep 2018 by Manjuke Fernando

How to give db_datareader access to a specific user across all the databases on a particular SQL Server

Create SQL Contained Database Users using EntityFramework Code First

19 Aug 2018 by Islam Refaei

How to create contained DB users to be used among your application

When Exporting Large Data from SSRS Report to Excel, Getting Error Message as Request Timeout in Sharepoint 2013

23 Jul 2018 by senthill

This tip will help you to resolve issue when exporting large data from SSRS report to Excel, getting error message "Request timeout" in SharePoint 2013.

SQL

SharePoint2013

DBA

Issues after Upgrade to SQL Server 2017 – Cannot Bulk Load Data Into the Table with Primary Key Constraint on it

11 Jul 2018 by Satnam Singh CapGemini

Cannot Bulk Load Data Into the Table with Primary Key Constraint on it

Auto Increment Column Value is Not Part of Transaction

25 Jun 2018 by connect ashish yadav

Auto increment column value is not part of transaction

SQL

Quartz.Net with Multiple Schedulers

7 May 2018 by Harshit Gindra

Understanding the use of multiple schedulers to work with one Quartz Scheduler application

SQL TVP Made Easy

26 Apr 2018 by Mason Kuck

I walk you through how to make use Table-valued parameters with one value

SQL

.NET

SQL Dependency using Entity Framework in WPF

6 Apr 2018 by CyberMakarov007

SQL table dependency with entity framework in WPF

How to Tell Which Way a One-to-Many Relationship Should Go

22 Feb 2018 by Database Star

This article explains how to tell if a relationship in a database should be many-to-one or one-to-many.

Select Statement to HTML Table

2 Feb 2018 by Luca Astolfi

User defined procedure for make an HTML table from T-SQL Select statment

Generate Insert Scripts of Existing Rows with "if Exists" Conditions

11 Dec 2017 by Chetan Naithani

Stored Procedure to Generate Insert Scripts

T-SQL

SQL

SQL Convert Simple Names to Proper Case

19 Nov 2017 by PIEBALDconsult

This is an alternative for "SQL Convert Sentence to Proper Case"

SQL

MySQL: DATETIME vs TIMESTAMP

16 Nov 2017 by Suvendu Shekhar Giri

Difference between MySQL DATETIME and TIMESTAMP datatypes

SQL

MySQL

DateTime

CASCADE in SQL Server with Example

29 Oct 2017 by vinothharshad

Use the ON DELETE CASCADE option if you want rows deleted in the child table when corresponding rows are deleted in the parent table.

SQL

SQL-Server

How to Use a Stored Procedure Inside an SQL Query

28 Oct 2017 by OriginalGriff

How do you call a Stored Procedure inside a query and use the SELECT results? Tricky...or is it?

Exploring Further - Date and Time Data Types (SQL Server)

27 Sep 2017 by Haroon Ashraf

Things worth considering when using SQL Date and Time data types

Computing First and Last Day of Current and Previous Month (SQL Server)

26 Sep 2017 by Haroon Ashraf

A quick way to calculate first and last day of curent month and previous month

SqlServer Clr Functions Utility

5 Sep 2017 by Member 10262330

I developed this DLL to have a more powerful utility and to simplify SP and query.

Dynamic Restore SQL Server

31 Aug 2017 by Member 10262330

Dynamic restore SQL Server

SQL

SQL-Server-2008R2

backup

Remove Duplicate Rows with CTE

14 Aug 2017 by Ehtesam Ahmed

This article gives you quick tip about how you can remove duplicate rows easily using common table expression in SQL

SQL

The Difference Between ROW_NUMBER(), RANK(), and DENSE_RANK()

17 Jul 2017 by Arif H Shigri

This tip will discuss the difference between ROW_NUMBER(), RANK() and DENSE_RANK().

SQL

SQL-Server

database

What’s the Difference between a Full Index Scan and a Fast Full Index Scan in Oracle?

13 Jul 2017 by Wendelius

This is an alternative for "What’s the Difference between a Full Index Scan and a Fast Full Index Scan in Oracle?"

SQL CASE WHEN condition THEN NumericColumn ELSE 0 END

7 Jun 2017 by Niemand25

Be careful with CASE WHEN when dealing with numeric columns and using zero literal

Understanding callbacks through Asynchronous Execution of SQL request.query in node js

31 May 2017 by Member 13040242

We are going to talk about the problem faced because of asynchronous nature of SQL query execution in node js and the solution for it.

R-script Migration to SQL Server 2016

13 May 2017 by Evgeniy Sukhikh

Issues and solutions taken while moving R from cmd to sp_execute_external_script

T-SQL

SQL

Calculate Geo Distance Using SQL Server

8 May 2017 by Nirav Prabtani

How to calculate distance between two geolocations or find out distance within a specific radius by SQL Server

Backdoor TFS User Image and Email Manipulation

31 Mar 2017 by ergohack

Do you need to update everyone's TFS picture? Or set the notification email address for that calcitrant employee?

Insert Multiples Records to SQL Server Database

15 Mar 2017 by Ricardo_Torres_Torres

Read text file and insert mutiples records in just one SQL Sentence

Random Number Generation using SQL

7 Mar 2017 by Shikur Yennus

Linear congruential is one of methods used to generate random numbers.

SQL

Build a Calendar Without Pre-Existing Tables

31 Jan 2017 by #realJSOP

Using common table expressions to build data from thin air.

US Federal Holidays (SQL)

31 Jan 2017 by #realJSOP

A scalar function to determine if a given DateTime is one of the ten US federal holidays, using SQL Server.

Create Query Shortcuts in SQL Server Management Studio

31 Jan 2017 by saddam_msp

Shortcuts to execute your query faster while working or debugging T-SQL statement

T-SQL

SQL

SSMS

Create CSV File in Microsoft SQL

27 Jan 2017 by Rajesh_K_Sharma

How to create CSV file in SQL

SQL

SQL-Server-2008

SQL-Server

What Are The NVL and NVL2 Functions And When Should I Use Them?

24 Jan 2017 by Database Star

This article explains the difference between the NVL and NVL2 functions in Oracle SQL.

SQL

Oracle

Convert column into rows without using pivot

24 Jan 2017 by VINEET MISHRA 086

Convert column into rows without using pivot function in SQL

SQL

SQL-Server

How To Use Oracle's TRIM, LTRIM and RTRIM Functions

27 Dec 2016 by Database Star

How to use these three functions and what the differences are between them

SQL

Oracle

database

The Best Table Finder (The BestCube Problem)

20 Dec 2016 by BharatRamV

Finds the Best Table for a given set of columns

Amount to Words

18 Dec 2016 by NightWizzard

Convert amounts to their spoken equivalents

Selecting Valid Records

7 Dec 2016 by Wendelius

This tip demonstrates how to select valid records from a table that contains validity date limits.

SQL

SQL-Server

Dev

Top 5 New Features in Oracle 12c for Developers

5 Dec 2016 by Database Star

Oracle 12c has many new features, and these are the five most useful (in my opinion).

SQL

Oracle

Generating Random Int SQL Values between Upper and Lower Limits

23 Nov 2016 by jamuro77

This SQL mini-article is about generating random int values between upper and lower limits, in particular, to load data into demo database.

SQL

How to Use COALESCE with Different Data Types

7 Nov 2016 by Database Star

Use the COALESCE function with different data types correctly

SQL

Oracle

How to Convert a text Value into a date in Oracle SQL

4 Nov 2016 by Database Star

Explanation and demonstration of some Oracle SQL functions to convert text to dates