Many times, we will require sample datasets with any random values but in large quantities, perhaps hundreds of thousands. Alternatively, during data analysis, we may
COMPUTING ROLLING & CUMULATIVE STATS – 3
This is a continuing series for “Computing Running and Cumulative Average“. A cumulative sum (or running total) refers to a data set’s partial sum. It
COMPUTING ROLLING & CUMULATIVE STATS – 2
This is a continuing series for “Computing Running and Cumulative Average“. A cumulative sum (or running total) refers to a data set’s partial sum. It
Tables Disk Consumption – SQL Server
Disk consumption is something that DBAs frequently investigate. It’s a process that checks the database’s growth and disk space use. It is often necessary to
Last Inserted Identity – MySQL & SQL Server
After inserting a row, the row identifier must be carried forward to be utilized for other related tables. When writing a batch process, such as
Frequently used Security Functions
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
Big Data and SQL 