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
SQL server encryption – Certificates
In the previous blogs we saw how to encrypt data using symmetric and asymmetric keys. We saw how to use...
2015-10-10
795 reads
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
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,397 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
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
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,860 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,278 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,652 reads
Blogs
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user...
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Forums
Active and Active Cluster
Hi Team, I am planning to apply security updates for SQL Server 2016 on...
SSIS package works in VS but failed in SSMS
Please help and thanks. Package:Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has...
Need a list of stored procedures that execute multiple stored procedures
Hello SSC! I hope you all had a happy and safe holiday! Apologies if...
Question of the Day
The Funny SELECTs
What is returned from this query?
SELECT
( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate > '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2000
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate > '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2001
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate > '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2002; See possible answers