This post shows a SQL script that can be used to kill all processes that are connected to a database. This is useful when you need to take the database down for maintenance.
How to get started with Microsoft SQL Server on Linux using Docker
SQL Script to find all SQL Agent Jobs for SQL Reporting Services Subscriptions, SSRS
This SQL script will show all Table Indexes that need to be added based on query history
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.
The following methods will allow you to map your DataTable, DataRow results to a class object.
Example on how to join a table-valued function in a T-SQL query
The following code snippets are examples of how to return the date only part from a datetime data type.
The following example shows how to query a table and count records associated in another
C# Examples on how to use inheritance in Entity Framework