Sign in

DevOps | Creator | Learner
Photo by Jon Tyson on Unsplash

Have you ever encountered a situation where you want to check if someone (or maybe you) modified a stored procedure or not?

Or maybe you want to see a list of all the most recently modified stored procedures. How do you do this?

Well, you can have this data without any instrumentation or any SQL Server tool. This information is stored in the SQL database itself.

Here are some SQL Queries that you might find useful

Stored Procedures Sorted By Last Modified

USE database_name
SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'
ORDER BY modify_date DESC

Top 10 Most Recently Modified Stored Procedures

USE database_name
SELECT TOP 10 name, create_date, modify_date
FROM…

Photo by Markus Winkler on Unsplash

If you actively monitor your security hub score, chances are that you know about how tricky things can get.

Recently a new check for encrypting SNS topics at rest was added to security hub. As a result, I faced some strange issues.

I followed these steps to resolve the broken notifications but this led to me failing another security check.

Chances are that you’ll fail KMS.1 or KMS.2 of AWS foundational best practices if you follow the approach above.

Why?

Because you are giving permissions to wildcard (*) for KMS actions!

The first approach that came to my mind was…


Photo by Caspar Camille Rubin on Unsplash

In this post, I’ll be referring to MS SQL Server as SQL Server

A lot of times the SQL Server uses a lot of resources causing strange CPU spikes.

Though these are meant to be there so that SQL server can provide more optimized performance, they can be a bottleneck if we see a long spike or continuous spikes.

We therefore need to figure out what query is responsible so that we can then optimize it.

To figure this out, you need to follow the following steps

  • Connect to the SQL Server via SSMS
  • Run the following SQL Query there

Photo by Florian Krumm on Unsplash

Many times we have a requirement where we want databases on two different servers to have same data, procs, etc.

For example, we want that the data in our stage environment should be same as our dev environment so that we can work on that data without much worry for the environment.

In such scenarios, either we can have a separate stored procedure to do so or we can do this manually using SSMS.

Here we will see how to do it manually using SSMS. …


ClamAV

Anyone who has ever had to work with an antivirus will agree to the fact that they eat up a lot of resources (read that as CPU)

Same is the case with ClamAV

But we can however increase the size of our boxes (EC2 instances in case of AWS) to compensate for the CPU utilization.

But what if the spikes in CPU causes the functionality of the main app to suffer?

This is a common issue that you will face while setting up a NextCloud installation with ClamAV integrated.

Though there is a feature for having external servers, there is…


Almost all of us use separate environments for separate needs like dev, UAT, production, etc.

And we most probably have separate regions for separate environments to isolate them completely.

But many a times we need to have production data on our lower environments to test some functionality or see the actual effects of our actions.

In this post, we’ll be going through the process of synchronizing two separate WordPress environments.

To begin with, there are three major components of any wordpress application

  1. Uploads directory
  2. Database
  3. Code base (files like wp-config.php)

Code base should be maintained via GitHub (so we won’t…


Recently I set up a cloudwatch alarm to receive notifications via mail and on a slack channel. But even after 3 days there were no alarms triggered.

This could mean one of the following things

  1. Either the application is performing exceptionally great — because the alarm was supposed to be triggered at least once daily
  2. Something was wrong with the alarm

To confirm which of the above are true, I went see the cloudwatch alarm. The alarm clearly showed that it had been triggered once daily, but I’ve not received any alerts for it.

It also gave a glimpse of…


Deploying on cloud is very very different as compared to traditional IT infrastructures. In cloud, your deployments no longer remain hardware devices, but rather become programmable services.

This provides you with a lot of flexibility and fault tolerance. But has it ever occurred to you what if you wanted to have an infrastructure copied?

Yes, the entire infrastructure!

Or, you want to maintain a version control on your infrastructure. Obviously it’s possible as it has now become nothing more than a collection of various services.

Well, the above advantages and many more requirements are satisfied when you think of your…


aws s3 bucket

S3 is among the most used AWS services and probably the best when it comes to data storage. But, do you know how much pain it can cause if you have a lot of files to upload to s3?

Yeah, you can upload them and download them directly from the console by just clicking a few times, what’s the big deal? Right?

But what if you need to upload hundreds of folders and thousands of files or download a complete bucket?

I know that you can select multiple files at once to upload, but what about folders? …


If you haven’t, then I would suggest that you go through Introduction to Docker to have a better understanding of the basics of docker and images in general.

Now, let’s get started with some of the most used and important commands that you would need to use when working with images.

build

docker container build

So if you want to build your own docker image, which at some point you would need to do, this is the command for you.

It is accompanied by many flags, as any important command would be. Let’s go through some them 1 by 1.

—…

Anirudh Duggal

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store