You Tube Channel: https://www.youtube.com/@brrknowledgecenter

 Azure SQL Managed Instance is the intelligent, scalable cloud database service that combines the broadest SQL Server database engine compatibility with all the benefits of a fully managed and evergreen platform as a service. Azure SQL database and Azure SQL Managed Instance are PaaS SQL Managed Instance provides support for instance-scoped features enabling easy migration of existing applications, as well as sharing resources among databases With SQL Managed Instance, confidently modernize your existing apps at scale by combining your experience with familiar tools, skills and resources and do more with what you already have. Azure SQL Managed Instance Connection String Server=test-azuresqlmanagedinstance-demo.public.43eb3ae38165.database.windows.net,3342;Persist Security Info=False; User ID=demouser;Password=demouser#1234;MultipleActiveResultSets=False; Encrypt=True;TrustServerCertificate=False;Connection Timeout=30; If you enable Public end point then we can access SQL Managed Insta

SQL Server 2012 Onwards we have a new solution termed as contained database. Contained database is defined as a database which has the database user without logins. It includes all settings related to databases along with its metadata, thus system will be having no dependency with SQL server login. Users can easily connect to a contained database without having to go through the log in at DB engine. Contained database feature provides two containment modes: None – By default each database has its mode set as NONE. This means there is no contained database feature being used. Partial – With partially contained databases, we can define boundaries between databases and the server, so the metadata will exist inside the databases. It makes SQL Server databases more portable and less dependent on underlying hosts.  A contained database is a database that is isolated from other databases and from the instance of SQL Server that hosts the database Isolated from other databases Isolated from SQ

  What is JWT? JSON Web Token (JWT) is the approach of securely transmitting data across communication channel. For authentication and authorization, it uses the technique of passing digitally signed tokens. JWT comprises of three parts: Header, Payloads and Signature. Header is used to identity the signing algorithm used and it appears like: { “ alg ”: “ HS256 ”, “ typ ”: “ JWT ”} Payload looks like: { “ Name ”: “ Ramana Reddy ,” Admin ”: “ true ”,” iat ”: “ 146565644 ”} The signature is created by Base64 encoding Header and Payload as: data = encoded ( Header ) + “.” + encoded ( Payload ) signature = HMACSHA256 ( data , secret key ); More details about JWT can be referred from  https://jwt.io/ JWT in Theory JWT authentication process can be broken into following 4 steps- 1) User is validated against database and claims are generated based on user’s role. 2) Payload containing claims or other user related data is signed with key to generate token and passed back to