Posted under: SQL


How to get started with Microsoft SQL Server on Linux using Docker

Sat Mar 02 2019DockerSQL

How to get started with Microsoft SQL Server on Linux using Docker

Read More ››

SQL Script to find all SQL Agent Jobs for SQL Reporting Services Subscriptions

Sat Dec 17 2016SQL

SQL Script to find all SQL Agent Jobs for SQL Reporting Services Subscriptions, SSRS

Read More ››

SQL Script to find all Indexes that need to be added

Wed Nov 13 2013SQL

This SQL script will show all Table Indexes that need to be added based on query history

Read More ››

SQL helper script to generate properties for an Entity Framework model

Wed Oct 16 2013C#SQLEntity Framework

This post shows a T-SQL script that can be used to generate the properties for a class that correspond to to a field in a database table. This can be used with Entity Framework.

Read More ››

C# Helper functions to map a DataTable or DataRow to a class object

Sat Mar 30 2013C#SQL

The following methods will allow you to map your DataTable, DataRow results to a class object.

Read More ››

How to join a table-valued function in T-SQL

Wed Jan 30 2013SQL

Example on how to join a table-valued function in a T-SQL query

Read More ››

How to get date only from datetime in T-SQL

Sat Nov 24 2012SQL

The following code snippets are examples of how to return the date only part from a datetime data type.

Read More ››

Counting records in associated tables in Entity Framework

Mon Aug 13 2012C#Entity FrameworkSQL

The following example shows how to query a table and count records associated in another

Read More ››

Using Inheritance in Entity Framework

Mon Aug 13 2012C#Entity FrameworkSQL

C# Examples on how to use inheritance in Entity Framework

Read More ››

BOM Where Used (Exploded) Stored Procedure for Dynamics AX

Thu Dec 29 2011Dynamics AXSQL

Stored procedure that produces an indented BOM for Dynamics AX

Read More ››