.NET Lance Talbert in .NET Extending the Unity Editor with C# The next step in learning how to create games in C# using Unity is to add extensions to get custom... 18 April 2018 16 min read
Darko Martinović Programming SQL Server with SQL Server Management Objects Framework SQL Server Management Objects (SMO) is a great tool for managing SQL Server. Darko Martinovic demonstrates how to use SMO... 09 April 2018 26 min read
.NET Edward Elliott in .NET Writing VS Code Extensions with TypeScript VS Code is a cross platform lightweight development environment from Microsoft. TypeScript is a superset of JavaScript. Ed Elliott shows... 06 April 2018 21 min read
.NET Dino Esposito in .NET A First Look at Bootstrap 4: Navigation Bars Bootstrap is a popular open source tool for developing HTML and CSS. Version 4 has recently been released. Dino Esposito... 29 March 2018 12 min read
.NET Darko Martinović in .NET Transposing SQL Server Query Results with SQLCLR: Dynamic Row-to-Column Rotation Transpose SQL Server query results dynamically using a SQLCLR stored procedure - no need to know column names in advance.... 13 March 2018 18 min read
JavaScript Jakub Kaczmarek in JavaScript Azure AD Authentication in Angular Chrome Extensions via ASP.NET Core Proxy Note: Uses ADAL.js (deprecated 2023 - see MSAL.js for current implementations). Covers securing an Angular Chrome extension with Azure AD... 09 March 2018 15 min read
Database DevOps Phil Factor in Database DevOps Script SQL Server Extended Properties for Table Documentation Learn to script SQL Server extended properties for table and column documentation using a JSON-based approach. Includes T-SQL functions, automation... 03 March 2018 31 min read
.NET Dino Esposito in .NET Action Control in ASP.NET Core With the release of .NET Core, developers must learn what has changed over classic ASP.NET programming. In this article, Dino... 28 February 2018 11 min read
BI Robert Sheldon in BI Merge SQL Server Data with CSV Files in Python Using pandas (MLS Part 6) Merge a SQL Server data frame with a CSV file data frame in Python using pandas merge() inside SQL Server... 28 February 2018 22 min read
.NET Camilo Reyes in .NET URL Matching in C# Comparing URLs in C# code is a common task and seems simple. Camilo Reyes shows us that there are many... 12 February 2018 12 min read
.NET Mircea Oprea in .NET JWT Authentication for .NET Microservices: Token Issuing & Validation How to implement JWT authentication for microservices in .NET. Covers token structure, issuing tokens via an API gateway, signature validation,... 09 February 2018 14 min read
.NET Dino Esposito in .NET HTTP Response Headers in ASP.NET Core ASP.NET Core has the flexibility to add HTTP response headers anywhere in the middleware pipeline. Dino Esposito explains what you... 12 January 2018 11 min read
.NET Dino Esposito in .NET ASP.NET Core Tag Helpers for Bootstrap The ASP.NET Core tag helpers improve on the HTML templated helpers in ASP.NET MVC 5. ASP.NET Core comes with some... 17 November 2017 13 min read
.NET Dino Esposito in .NET Abstracting System Time in ASP.NET Applications When designing web applications, it is a good idea to be cautious about the way you handle the time of... 19 September 2017 11 min read
.NET Mircea Oprea in .NET C++/CLI Wrapper: Bridge Unmanaged C++ and .NET Learn how to create a C++/CLI wrapper that bridges unmanaged C++ code and .NET managed applications. Covers ManagedObject base class,... 06 September 2017 14 min read
T-SQL Programming Darko Martinović in T-SQL Programming SQLCLR Email in SQL Server: Build a Custom sp_send_dbmail Alternative Build a SQLCLR stored procedure for sending email from SQL Server without sp_send_dbmail. Covers .NET SMTP integration, custom email profiles,... 17 July 2017 36 min read
Jon Smith Using Entity Framework With an Existing Database: Data Access Pre-existing SQL databases, particularly if complex, can often pose problems for software developers who are creating a new application. The... 01 December 2014 18 min read
Robert Sheldon Questions about SQL Server Primary and Foreign Keys You Were Too Shy to Ask It is strange that one can ask simple questions about extended events or Hekaton at professional events and conferences without... 06 October 2014 37 min read
Robert Sheldon Subqueries in SQL Server Subqueries and derived tables can add great versatility to SQL statements, cut down complexity, but can occasionally be a curse... 26 May 2011 16 min read
Jacob Sebastian An Introduction to SQL Server FileStream Filestream allows us to store and manage unstructured datain SQL Server more easily. Initially, the accounts of FILESTREAM assumed prodigious... 03 August 2009 19 min read
