The concept behind frameworks and libraries is to provide reusable code that you can use to perform everyday tasks so that developers don’t have to write all of the code from scratch for every project. However, there are some differences that you need to understand as you start writing code, which I will cover in this article.
2023-07-05
Motivation At some point in the carrer, we have come across the problem of hard-coded values in SELECT or WHERE clauses. And we all agree that these hardcoded values must be parametrised. This bad habit usually backfires when we need to troubleshoot a query. These hardcoded values are usually a business role baked in the […]
2022-10-18 (first published: 2022-09-02)
11,395 reads
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Security on your SQL Server is important. That doesn’t need any explaining. But where...
It’s that time of year again! EightKB is back on August 20th at 13:00...
Comments posted to this topic are about the item Backing Up a DMK
Comments posted to this topic are about the item The Quiet Part
Comments posted to this topic are about the item BIT_COUNT in SQL Server
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers