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.
Category: SQL Server
SQL Server Administration, Development and Maintenance
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
Find SQL scheduled jobs to run during a specific time range
There are times when we need to know which jobs are going to run in the upcoming half an hour or so. It is quite possible
Big Data & SQL 