Handling a GDI Resource Leak

Total: 4 Average: 4.3

GDI leak (or, simply the usage of too many GDI objects) is one of the most common problems. It eventually causes rendering problems, errors, and/or performance problems. The article describes how we debug this problem.

In 2016, when most programs are executed in sandboxes wherefrom even the most incompetent developer cannot harm the system, I am amazed to face the problem I will speak about in this article. Frankly speaking, I hoped that this problem had gone forever together with Win32Api. Nevertheless, I faced it. Before that, I just heard horror stories about it from old more experienced developers. Read More

Effective Use of Classes in .NET

Total: 6 Average: 3.5

When you need to learn a programming language, you buy a book. From books, we learn basics of the language and how to program, but this is only the beginning – there is also a development environment, and the work with it is another complicated story. Let’s take a look at some secrets of Visual Studio and some secrets of classes. Read More

ASP.NET Core 1.0. Platform. Part 2. ASP.NET Today or what to choose?

Total: 6 Average: 3.3

Many of us (including myself) have been waiting for the final version of .NET Core and ASP.NET Core. Now the wait is over – a couple of months ago the RTM version of the web app development technology named ASP.NET Core 1.0, has been released. Just a reminder: in early 2016 it was branded as ASP.NET 5. All new features of the new version of the Microsoft.NET platform have been described in general terms. In this article and subsequent articles, you will learn what else can be done with the latest .Net platform. I will also provide a broad description of the web development technologies that Microsoft offers today. To see what is available at the moment, we can just open Visual Studio 2015 Update 3 with the latest version of ASP.NET and Web Tools (VS2015Tools.Preview2.0.1).

Read More

ASP.NET Core 1.0. Part 1: Introduction, general description and the future of .NET Framework

Total: 5 Average: 3.8

The question is: “Microsoft ASP.NET vNext: evolution or revolution?“, the absolute answer is revolution. In this series of articles, I will try to describe in detail the latest technology for creating web applications, namely – ASP.NET vNext, which initially had the official name ASP.NET 5 and later was renamed to ASP.NET Core 1.0. There will be another series devoted to the development of a real application with examples describing the practical use of this technology.

Read More

Azure SSAS. Cubes in Clouds

Total: 3 Average: 2.7

Autumn of 2016 was full of events from Microsoft dedicated to analytics. In practice, the company began aggressive promotion of its predictive analytics and BI platform in the cloud. Finally, it has happened – Microsoft has released the preview of Azure SSAS Tabular. In fact, the company has transferred SSAS Tabular to the cloud. Therefore, SQL Server Analysis Enterprise Edition in cloud  supports DirectQuery, partitions, row-level security, bi-directional relationships, and has compatibility level 1200.

Read More

SQL Server Security Ponderings – Part 1 | DMI – Bobby Returns

Total: 6 Average: 4.3

Nowadays security and data privacy are in special focus. When I deliver a training, I always refer to a DBA as the “guardian of the data.” There are two aspects of being a guardian.

The first one is integrity. It includes tasks like checking database consistency, creating backups and in case of problems being prepared to fix the database by having well designed, comprehensive DR plan.

Read More

SQL Server In-Memory OLTP: The Basics

Total: 0 Average: 0

This is the first article in a series of articles about In-Memory OLTP. It helps you to understand how the new Hekaton engine works internally. We will focus on details of in-memory optimized tables and indexes. This is the entry-level article, which means you do not need to be an SQL Server expert, however, you do need to have some basic knowledge about the traditional SQL Server engine. Read More

Deploying Database from Source Control

Total: 2 Average: 4.5

These days, development teams start new projects from choosing a version control system. There are many benefits of source control systems in coordinating the efforts of the development team. It ensures a complete audit trail of all changes to the code and allows the team to reproduce any specific revision or build. Along with the programming code, databases can and should be placed under source control. In this article, we will have a look at how to deploy a database that is in the remote repository. Read More

Query Performance Insight: Discovering What Consumes Resources of Your Azure SQL Database?

Total: 2 Average: 3

In this post, I’d like to take a brief look at the Query Performance Insight — SQL Azure tool which will help you to identify the most expensive queries in your database.

Query Performance Insights was announced in early October 2015. To understand what it is, let’s think about how do you usually learn that the database performance got down? Probably, you are receiving emails from your clients or it takes an hour to create a weekly report instead of a several minutes, or maybe, your application starts throwing exceptions. Read More