Execute Powershell in SSIS Using C#
Introduction PowerShell is a Shell included in Windows to automate tasks in the operative system...
Transparent Data Encryption and Always Encrypted
If you need to store confidential data in your database, you can use data encryption. SQL Server supports encryption with symmetric keys,...
Single IoC Container in the HTTP-request: Web API vs. OWIN Middleware
In this article, I am going to provide you with a working solution that allows you to have a single dependency container (IoC container)...
ASP.NET Core MVC: Feature Folders
The first version of ASP.NET MVC appeared back in 2009, and the platform (ASP.NET Core) was first...
Type Conversion in .NET
Introduction Such a simple topic as type conversion would seem to be unworthy of the whole article. In C#, there is a suitable operator...
SSAS: Attention, Accuracy, and All the Benefits
This article is about working with Microsoft Analysis Services and a little bit about the repository on Microsoft SQL...
Introduction to Temporary Tables in SQL Server
A temporary table in SQL Server, as the name suggests, is a database table that exists temporarily...
Using npm, Webpack, and TypeScript to create simple ASP.NET Core web app
Introduction I write this tutorial primarily to demonstrate how to quickly create a simple application with support for npm, Webpack, and...
.NET Managed + C Unmanaged: What’s the Cost?
When I was programming in C#, I used to send all recursive tasks to an unmanaged C code, since the .NET performance was problematic. And...
Why Multiple JOINs are bad for Query or Do Not Get in the Way of Optimizer
Recently, I came across an application that generated DB queries. I understand that there is...