The Importance of Protecting Your Data: Introduction and Focus on the Rebase Server Solution
Many organizations are now facing with a lot of compliance regulations, from SOCII to PCI, GDPR to KYC compliance and many audits are done to understand how they protect their data from external hacking but also internal employees. The biggest threat might not be the…
Clustered Columstore and Nonclustered filtered indexes
Hello DBA friends, I had the most bizarre experience on a SQL server 2016 (sp2). On the cumulative hotfixes after, the closest one from the error is this one : https://support.microsoft.com/en-us/help/4316858 It is still not quite the error that I got though. With a client,…
Should you shard or centralize your database ?
Preamble: Nowadays, business tends to get very big database very quickly and they usually need to find ways to manage functionally and physically data in a more efficient matter, both for security and performance reasons. In many ways, centralizing the operating database can make your…
Phase 2: AE and search patterns
Hello again, This time, I implemented the same code but with encryption and hashing, encryption with a symetric key for the email addresses and hashing for the dictionary. This would be similar as implementing random encryption for the email address field and deterministic encryption for…
Data vs Database management
I wrote this article a few years ago noting a change in paradigm where data was more important than database…. meaning the ACID paradigm enforced by the database engine was somewhat an old fashioned way of thinking of data storage…. Is this true? Any point…
Categories
- Inspiration (1)
- Security (2)
- SQL Architecture (21)
- SQL Monitoring (1)
- SQL Performance (16)
- Tips & tricks (1)
- Uncategorized (5)
- Utilities (1)