FireDac and ADO are your friends! — The previous article of this series of posts dedicated to the SQL Server Encryption features, describes how Always Encrypted works. This article describes how to manage encrypted columns from a Delphi application. Always Encrypted is a client-side encryption technology that ensures sensitive data (and related encryption keys) are never revealed…

The strongest encryption methods currently available in SQL Server and Azure SQL! — In the previous article, Database encryption becomes transparent with SQL Server TDE the second one in this series of articles dedicated to SQL Server Encryption features, we described how to protect data by encrypting it at the I/O level when data is at rest. This article introduces another encryption feature…

A story of a massive reseed! — I recently needed to reseed to 1 the values of all the identity columns of the empty tables in a database. Breaking down the request into smaller tasks, the following two were identified: Identify tables with no records in the database Reseed the IDENTITY column using a T-SQL script that…

Encrypting your data at rest with SQL Server Transparent Data Encryption! — In the previous article Encryption in your SQL Server backup strategy, the first one in this series of articles dedicated to SQL Server Encryption features, we described how to implement encryption in your backup strategy. …

Security best practices must be implemented also in your SQL Server backup strategy! — Databases in a company are the place where information is stored to drive the company’s production processes. …

Possible values of the logical evaluation of an expression — One of my favorite books is T-SQL Querying by Itzik Ben-Gan, Dejan Sarka and Grega Jerkich; it is rich in content and inspired me, so I decided to write this article about a particular aspect of T-SQL language: the possible values that we can expect, in T-SQL, as a result…

Practice assessments on Microsoft Learn, free with unrestricted access! — Microsoft recently launched the Microsoft Learn Career Paths portal to help people unlock the path to their dream career through free resources including training modules, certifications, and job postings. The paths related to the Data Platform could not be missing: Data Analyst Data Engineer Data Scientist Here you will find…

Anonymize text columns longer than two characters! — In the previous article Data masking with sqlcmdcli we talked about the complex activity of data anonymization when you have to take a production database to carry out tests in the development environment even outside the customer’s company perimeter. …

SQL Server 2022 is finally available in RTM version! The announcement was done this week during PASS Data Community Summit 2022 in Seattle. The new features of this amazing version of SQL Server certainly cannot be condensed into a single blog post. …