Context

Previously, comparing C++Builder classic and Clang compilers I regreted than CodeGuard tool doesn't work with Clang. Fortunately, there are other tools which can help you to profile program code and detect memory leaks. The Dataleaker is the one of these tools.

Installation

The installation requires local administrator rights …

How to kill all database connections before dropping it?

USE master;
GO
DECLARE @sql nvarchar(max);
WHILE 1=1 BEGIN
    SELECT TOP 1 @sql = N'KILL ' + convert(nvarchar(10), spid)
    FROM sysprocesses WHERE dbid = DB_ID('my_database');
    IF @@rowcount = 0  BREAK;
    EXEC sp_executesql @sql;
END;
DROP DATABASE IF EXISTS my_database;

This is the revised translation of my article published in "ITWeek" magazine January 24, 2019.

An expert tries to know more and more about less and less until he knows absolutely everything about nothing. And a philosopher tries to know less and less about more and more until he knows …

Q1. Difference between ++*p, *p++ and *++p

Priority to keep in mind:

1. postfix ++
2. prefix ++
3. *

#include <stdio.h>
int main()
{
    int arr[] = {10, 20};
    int *p1 = arr;
    int *p2 = arr;
    int *p3 = arr;
    printf("arr[0] = %d, arr[1] = %d\n", arr[0], arr[1]);
    printf("arr[0] = %d, arr[1 …

According to specification, "...constructor is a special non-static member function of a class that is used to initialize objects of its class type". In addition to basic concepts, C++11 introduces move constructors, initializer list type and brace-enclosed lists of comma-separated initializers.

However the impact of introducing new constructors combining …

The Windows registry (WR) is a NoSQL DBMS based on a semi-structured hierarchical data model. Unlike configuration files approach, WR:

• can manage millions of keys and values
• is thread-safe
• is an in-memory database
• supports some data types
• supports a secure access to keys and values
• has GUI (regedit) and command …

Bertrand Meyer's article "Making sense of agile methods" (PDF, November 2017 on author site, copy on this site)

Russian translation published in "Open systems" magazine N°2-2018 "Об Agile по гамбургскому счету"

Some citations (I completely agree according to my experience).

Everything will look fine until you suddenly discover that …

Motivation

C++11 has introduced the move semantic which can also be used in containers instead of "old-school" pointers. The specific containers owning objects has been proposed earlier by third-party libraries like Boost (for example, ptr_map or ptr_vector).

The goal of the test is to compare the speed of manipulations …

SQL Server Profiler has the template "locks" that is intended especially to trace deadlock. Let's try to simulate and catch a deadlock situation.

Suppose the test database is named test. Create two tables and feed them some data.

USE test;

CREATE TABLE dbo.invoices (
   id int NOT NULL,
   num nvarchar …

Update. Since the version 2016 SQL Server supports anonymous constraint declaration:

CREATE TABLE #temp_table (
   id1 int NOT NULL,
   id2 int NOT NULL,
   name1 nvarchar(100),
   name2 nvarchar(100),
   PRIMARY KEY (id1, id2),
   UNIQUE (name1, name2)
);

For earlier versions the solution is below.

Local temporary tables are isolated in the scope …