Some systems store several small status values through a single packed integer. For example, a device integration may require tracking operating mode, alert level, and zone information as one status code rather than separate values in different columns. That creates a practical reporting problem. The packed value may be convenient for an integration format, but […]
2026-11-06
784 reads
Learn how to use CHOOSE() and IIF() to validate priorities and return easy to read messages to the user.
2026-10-21
2,513 reads
Learn how the bitwise functions SET_BIT() and GET_BIT() can be used to manage data stored inside a single column.
2026-09-11
2,450 reads
Learn how the BIT_COUNT() function works and how it enabled operations where data is stored in bits.
2026-08-07
4,500 reads
This article shows how the TRY_PARSE() and TRY_CONVERT() functions can be used to handle data quality issues and ensure that your software continues to function without throwing errors.
2026-07-13
3,858 reads
A short introduction to how deadlocks work and how you can affect their behavior inside your system.
2026-07-13 (first published: 2026-05-01)
3,249 reads
Generating temporary passwords is a common requirement in many applications. Users may need to reset a forgotten password, new accounts may require an initial password, or developers may generate test credentials. While password generation is often implemented in application code, doing it directly in SQL Server provides clear advantages. It centralizes the logic, ensures consistency […]
2026-04-10
2,465 reads
Palantir is an American software platform that brings together business data from different sources...
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
By James Serra
(This is the second post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Packing and Decoding Device Status...
Comments posted to this topic are about the item SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers