Blog

JOINS in SQL Server

A JOIN clause is used to combine rows from two or more tables, based on a related column between these tables. The purpose of JOINS in SQL is to access data from various tables based on logical relationships. We can use joins to fetch matched or mismatched records from more than one table. Types of

Continue reading

MySQL JSON_EXTRACT Examples

JSON_EXTRACT returns data from a JSON document, selected from the parts of the document matched by the path arguments. Returns NULL if any argument is NULL or no paths locate a value in the document. An error occurs if the json_doc argument is not a valid JSON document or any path argument is not a

Continue reading

AWS RDS – Delete Option Group

Once an option group has been allocated to an instance, it cannot be deleted. The option group must be removed from all instances. When attempting to delete an options group with dependents, the following error is returned. The option group ‘audit-options’ cannot be deleted because it is in use. To identify to which instance the

Continue reading

AWS RDS – Audit logs in Cloudwatch

When I first started utilizing AWS RDS, I ran into a slew of issues. Most of them are due to a lack of knowledge, and a few are because they are not straightforward. Audit logs are one of them. I couldn’t find anything even after selecting the option to publish the audit logs to cloud

Continue reading

Amazon RDS – Engine Types, Editions and Versions

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 the world. Millions of clients, including the fastest-growing startups, largest corporations, and top government agencies, rely on AWS to reduce costs, improve agility, and accelerate innovation. The Amazon Relational Database

Continue reading

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 need to insert a large number of rows. The example below shows a loop statement that inserts 100,000 rows into a table to help achieve both of the above aims.

Continue reading

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 is a sum of a number sequence that is refreshed whenever a new number is added to the sequence. The cumulative sum (or running total) is quite common in finance

Continue reading

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 is a sum of a number sequence that is refreshed whenever a new number is added to the sequence. The cumulative sum (or running total) is quite common in finance

Continue reading

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 filter it down to see which table is eating the most disk space. There are numerous ways to determine the number of rows, data space, and index space used, including

Continue reading

Loading…

Something went wrong. Please refresh the page and/or try again.


Follow My Blog

Get new content delivered directly to your inbox.