.NET Tom Fischer in .NET The Care and Feeding of Tuples in C# Tuples have many uses in languages like F# and Python; they underlie relational theory. The .NET support for tuples seems... 23 August 2017 10 min read
T-SQL Programming Hitendra Patel in T-SQL Programming The Power of Python and SQL Server 2017 Python is new to SQL Server 2017. It is intended primarily to allow the use of Python-based machine-learning within SQL... 04 August 2017 14 min read
.NET Dennes Torres in .NET SQL Server Query Hints in Entity Framework: DbCommandInterceptor Guide Add SQL Server query hints to Entity Framework using a DbCommandInterceptor. Covers OPTION RECOMPILE, table hints (UPDLOCK, HOLDLOCK), and why... 01 August 2017 29 min read
.NET Dennes Torres in .NET Encrypting connection strings in web.config Encrypting web.config elements is a good security feature. Web.Config elements can include passwords and important keys that we need to... 01 August 2017 2 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
.NET Dino Esposito in .NET Anti-Forgery Validation in ASP.NET Core Hackers use the cross-site request forgery technique to grab the identity and privileges of legitimate authenticated users of a site... 17 July 2017 12 min read
.NET Dino Esposito in .NET Revisiting Script Injection in ASP.NET The danger of Cross-Site Scripting (XSS) has to be dealt with in any web application. You do this by validating... 05 July 2017 12 min read
.NET Dennes Torres in .NET Visual Studio 2017 and Swagger: Building and Documenting Web APIs The OpenAPI ‘Swagger’ Specification defines a protocol that allows applications to discover, and generate documentation of methods, parameters and models... 20 June 2017 16 min read
.NET Dino Esposito in .NET Control the Controller in ASP.NET MVC Because of its obvious importance in coordinating the MVC application, we tend to be wary of being too adventurous with... 08 June 2017 12 min read
.NET Michael Sorens in .NET PowerShell LINQ Guide: Operators & Performance Complete reference for using LINQ operators in PowerShell. Covers syntax, delegates, performance gains over native loops, and working examples for... 19 May 2017 47 min read
.NET Michael Sorens in .NET A Visual Lexicon of LINQ LINQ is best learned from examples, but few LINQ resources supply, along with the code, pictures that illustrate what each... 25 April 2017 18 min read
.NET Michael Sorens in .NET A Visual Lexicon of LINQ: The Wallchart Here is a handy wallchart that condenses the information contained in our article 'The Visual LINQ Lexicon' even further, but... 25 April 2017 0 min read
.NET Dino Esposito in .NET Improvements to Model Binding in ASP.NET Core Model Binding has been a popular feature of ASP.NET MVC, but has, before now, had some minor restrictions. ASP.NET Core... 25 April 2017 11 min read
.NET Michael Sorens in .NET Ten Unsung Visual Studio Time-Savers We all have our favourite third-party extensions to Visual Studio, and although we all like Resharper, there are many others... 06 April 2017 18 min read
BI Krzysztof Stanaszek in BI Scala and Apache Spark in Tandem as a Next-Generation ETL Framework Scala and Apache Spark might seem an unlikely medium for implementing an ETL process, but there are reasons for considering... 06 April 2017 14 min read
.NET Jon Smith in .NET Building Better Entity Framework Applications Entity Framework (EF) is Microsoft’s Object/Relational (ORM) database access library, with a new generation, EF Core, released in 2016. In... 27 March 2017 22 min read
.NET Dino Esposito in .NET Model Binding in ASP.NET Core Model binders work under the covers in ASP.Net MVC to provide the data for the action methods on a controller... 27 March 2017 13 min read
.NET Edward Elliott in .NET What is the Go Language, and Why is it Useful? When Google announced the 'Go' language in 2009 we were all underexcited. After all, a compiled, statically typed language in... 24 February 2017 24 min read
.NET Dino Esposito in .NET The Common Problems of Data Grids Data grids are easy to do in HTML, and if we want anything complicated in terms of scrolling, locking and... 14 February 2017 12 min read
.NET Sophia Segal in .NET User Acceptance Testing and the Application Lifecycle User Acceptance Testing (UAT) is an important part of the development process. If carried out as early as possible and... 03 February 2017 24 min read
