Amazon Web Services (AWS) is the world’s most comprehensive and widely used cloud platform, with over 200 fully featured services available from data centres around
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.
INSERT 100,000 RANDOM ROWS IN SQL SERVER
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
Big Data & SQL 