Aspects of Strings in .NET
The string data type is one of the most significant data types in any programming language. You can...
Foreach or For – That is the Question
The discussion about the preference difference between FOREACH and FOR is not new. We all know that FOREACH is slower, but not all know...
Is string operator “+” so simple?
Introduction A string data type is one of the fundamental data types, along with numeric (int, long, double) and logical (Boolean) ones....
Creating and Accessing In-Memory OLTP Databases and Tables
This is the second article in a series of articles about SQL Server In-Memory OLTP. The...
Handling a GDI Resource Leak
GDI leak (or, simply the usage of too many GDI objects) is one of the most common problems. It eventually causes rendering problems,...
SQL Server In-Memory OLTP: The Basics
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...
Query Performance Insight: Discovering What Consumes Resources of Your Azure SQL Database?
In this post, I’d like to take a brief look at the Query Performance Insight — SQL Azure tool...
SQL Server Database Backup Encryption
To manage the data security that has been backed up by the file system as a database backup files, SQL Server provides the backup...
In-Memory OLTP: What’s new in SQL Server 2016
SQL Server development team has added new features to In-Memory OLTP. All these features allow you to build new applications as well as to...
SQL Server Transaction Log — Part 2
This is the second article in the series dedicated to SQL Server transaction log and its...
