SQL Server documentation specified the following security functions. CERTENCODED PWDCOMPARE CERTPRIVATEKEY PWDENCRYPT CURRENT_USER SCHEMA_ID DATABASE_PRINCIPAL_ID SCHEMA_NAME sys.fn_builtin_permissions SESSION_USER sys.fn_get_audit_file SUSER_ID sys.fn_my_permissions SUSER_SID HAS_PERMS_BY_NAME SUSER_SNAME IS_MEMBER
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Dynamic SQL
Dynamic SQL is a programming approach that allows you to create SQL statements at runtime. Because the whole wording of an SQL statement may be
Table Variables in SQL Server
Table variables, like temp tables, are used to temporarily store data. This functions as a variable and is only present for a specific batch of
Temporary Tables in SQL Server
Temporary tables, as the name implies, are used to temporarily store data. These tables can be used for CRUD (Create, Read, Update, and Delete), join,
Common Table Expressions (CTE) in SQL Server
A common table expression (CTE) is a named temporary result set that may be referenced within a SELECT, INSERT, UPDATE, or DELETE statement. A CTE
Temporary Objects in SQL Server
Many temporary objects are employed in the day-to-day transactions of medium or large OLTP databases. These objects can be temporary tables, temporary variables, session variables,
Big Data & SQL 