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,650 reads
Kruti's SQL Blog
SQL server encryption – Symmetric Keys
In the previous blog we learnt about encryption and a brief about the SQL server option provided for data protection...
2015-10-10
786 reads
SQL Server Encryption
Encryption is a methodology used to hide confidential information from any illegitimate user is such a way that they do...
2015-10-10
1,592 reads
Fixing MSI errors during patching
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,410 reads
Table partitioning
What is partitioning.
To start with partition is the feature provided by SQL server in which very large tables are split...
2015-09-28
522 reads
MOVING SYSTEM DATABASES
Below document provides information that can be used for moving system database. However this is not recommended for database installation...
2015-09-12
26,861 reads
Data Needed to Recover SQL server from a Host Crash
Am sure every DBA has once in his/her career come across a situation of recovering a database or an instance...
2015-09-12
275 reads
What happens when you execute a query
When a query is submitted to SQL server it goes through several processing steps. A proper understanding of these steps...
2015-09-12
4,658 reads
SQL Join Algorithms
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,279 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...