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
Category: RDBMS
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.
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
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
XML in SQL Server
This is my second post on XML after 10 years. I was contented with the earlier post however I experienced more over these years and
Json in SQL Server – Load and convert Json data
Data is the backbone of the business, and it can be in any sort of format. It can be lying in your relational databases or
Big Data & SQL 