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,658 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,658 reads
In the previous blogs we saw how to encrypt data using symmetric and asymmetric keys. We saw how to use...
2015-10-10
802 reads
In the previous blog we learnt about encryption and a brief about the SQL server option provided for data protection...
2015-10-10
793 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,738 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
528 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
279 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,884 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,308 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,839 reads
Each year around this time, companies enter the familiar ritual of budgeting. For many,...
By Steve Jones
I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting,...
By Brian Kelley
After I have understood the details for a certification test (part 1), including format...
Hello SSC, I hope everyone is having a happy and safe holiday season! I...
Hello, I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...
Hello, I am working with a company on their database administration. I am trying...
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers