SQL server encryption – Asymmetric Keys
In the previous blog we learnt about symmetric key encryption. We also learnt through an example how data is stored...
2015-10-10
3,657 reads
In the previous blog we learnt about symmetric key encryption. We also learnt through an example how data is stored...
2015-10-10
3,657 reads
In the previous blog we learnt about encryption and a brief about the SQL server option provided for data protection...
2015-10-10
791 reads
Encryption is a methodology used to hide confidential information from any illegitimate user is such a way that they do...
2015-10-10
1,596 reads
Patching is an activity that is frequently performed by DBA’s. It is the responsibility of a DBA to keep the...
2015-09-29
22,636 reads
What is partitioning.
To start with partition is the feature provided by SQL server in which very large tables are split...
2015-09-28
526 reads
Below document provides information that can be used for moving system database. However this is not recommended for database installation...
2015-09-12
26,877 reads
Am sure every DBA has once in his/her career come across a situation of recovering a database or an instance...
2015-09-12
277 reads
When a query is submitted to SQL server it goes through several processing steps. A proper understanding of these steps...
2015-09-12
4,809 reads
SQL queries implement various joins when datasets are to be retrieved from one/multiple tables and merged on a certain criteria...
2015-09-12
4,300 reads
By Arun Sirpal
The Business Critical tier of Azure SQL Managed Instance offers the read-scale out feature...
By Rohit Garg
Cloud computing is essential for modern development, data storage, and scalable applications. Setting up...
I recently had to copy an Azure SQL database (SQL db) from one subscription...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item SQL Server Columnstore Index Fragmentation
Hi i was surprised to see the approach my coworkers used to sunset talend...
The columnstore index is absolutely different than the traditional rowstore b-tree index. Because of this, it doesn't suffer from the same kind of fragmentation across pages as the b-tree index. Yet, it does suffer from a type of fragmentation brought about by an excess of deleted rows in a rowgroup and a lack of compression of storage because more things are in the delta store. While b-tree indexes use dm_db_index_physical_stats to show fragmentation, which system tables or DMVs can be used in SQL Server (prior to SQL Server 2025) to determine columnstore fragmentation?
See possible answers