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,591 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,388 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,856 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,647 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,277 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers