Archives

December 2024

• SQL Server as key-value store versus Redis

May 2023

• DBMS market share 2011-2021

April 2023

• List of user sessions in SQL

November 2022

• Should database only store data?
• Why use interface instead of pimpl

April 2022

• Using RapidFort on Windows WSL

February 2022

• Get all subsets from a set

September 2021

• All expressions of 123456789 and signs +/- which value is 100
• C++ coding styles
• When you still need use the singleton pattern?

June 2021

• static_cast vs dynamic_cast: undefined behavior

March 2021

• Old-school vs Modern C++

May 2020

• Qt Test limitations and workarounds

February 2020

• Deleaker for C++ Builder

October 2019

• SQL Server: kill all database connections

May 2019

• The brilliance and poverty of microservices

March 2019

• C programming: frequent questions and test-approved answers

February 2019

• C++11 constructors

January 2019

• Windows registry performance in multithreading

December 2018

• Agile or not agile

November 2018

• C++11 containers: move semantic vs pointers
• SQL Server: how to simulate and catch deadlock
• SQL Server: temporary tables and constraint names
• C/C++: how to clear a linked circular list
• SQL Server: key-value store table and hash index

October 2018

• SQL Server: fractional part of number
• SQL: generate random character string
• SQL Server: sync two tables with MERGE statement

June 2018

• Read/write performance: single thread vs multithread
• Count LOC with Notepad++

February 2018

• Classic backgroud color in Windows 10

January 2018

• New book "Programming with databases"

October 2017

• C++Builder: using variant type variable to store Delphi interface

July 2017

• C++Builder: classic compiler vs clang

March 2017

• Create live USB stick on Debian

December 2016

• How Model Driven kicks off Agile

October 2016

• Types of joins in SQL (cheatsheet for beginners)

September 2016

• Using Delphi library with C++ Builder
• SQL: generate list (sequence) of integer values

February 2016

• Happy tickets benchmark

January 2016

• Installing Delphi 7 on Windows 7/8/10/Server 2012

December 2015

• Bit-packed structure (record) in Free Pascal and Delphi

November 2015

• Optimisation of Transact SQL queries

July 2015

• Sorted map vs hashed map
• Watching heap memory usage in Free Pascal/Delphi
• Why need to specify unit names?

May 2015

• Interface implementations and multiple inheritance in C++
• GenieLamp
• Free Pascal: call stack and procedures names at runtime
• Delphi and Free Pascal bencmark: array vs TList vs dynamic array
• Install HP LaserJet Pro CP1025 on Ubuntu

April 2015

• Crack C# namespaces in 30 seconds

August 2013

• Home headless server on Cubieboard and Ubuntu
• Firebird: bulk insert and bulk export

July 2013

• Delphi/Free Pascal: very simple "old school" mutex

December 2012

• Fast inserting a file into a table

April 2012

• SQL: generate date/time series

March 2012

• SQL: delete duplicated rows

February 2012

• Transact SQL: exporting table or view in CSV

December 2010

• DateTime in C++
• GUI: evolution of descriptions

November 2010

• Indexing columns of bit type
• Dynamic filtering with SQL

October 2010

• SQL quine (self-reproducing SQL)

May 2010

• Dynamic result ordering in SQL

July 2009

• Random sequence in Transact SQL query

June 2009

• SQL Server: show size of tables

February 2007

• Primary keys in transactional processing: int vs GUID