The certificate-based logins that start and end with double hash marks are stated below – ##MS_SQLResourceSigningCertificate## ##MS_SQLReplicationSigningCertificate## ##MS_SQLAuthenticatorCertificate## ##MS_PolicySigningCertificate## ##MS_SmoExtendedSigningCertificate## ##MS_AgentSigningCertificate## By default, they are
Certificate Based Server Logins – SQL Server
The SQL and Windows logins information will be available in sys.server_principals along with the logins that were created from certificates when SQL Server is installed.
Difference between Local File System vs HDFS
In an operating system, file system is the strategy that is used to keep track of files on a disk. It has its own method
Hijri Date in SQL Server – with Islamic Month Name
This article focuses on converting the Gregorian date into an Islamic date along with Islamic month name in textual format. In SQL Server there are
Moving a table from one Hive database to another
This article is to let you know how to move a table from one database to another in Hive. CREATE TABLE TestDB.emp AS SELECT *
XML in SQL Server – Part-2
In the previous part, we learned how to use the default modes and how we can change the shapes of the XML model using the
Big Data and SQL 