SQL Server: Indexes and fill factorAlmost everyone who has worked with DBs have heard about indexing. We often do indexing to improve the performance of our applications.Aug 23, 2021Aug 23, 2021
Published inCodeXDNS Resolution: Resolving a domain name to an IP addressWhat happens when you type a domain name in your browser?Aug 22, 2021Aug 22, 2021
How To Find When A Stored Procedure Was Last ModifiedHave you ever encountered a situation where you want to check if someone (or maybe you) modified a stored procedure or not?Apr 6, 2021Apr 6, 2021
The Best Way To Provide KMS Permissions In AWSIf you actively monitor your security hub score, chances are that you know about how tricky things can get.Apr 5, 2021Apr 5, 2021
How To Get A List Of Top CPU Consuming T-SQL QueriesIn this post, I’ll be referring to MS SQL Server as SQL ServerApr 3, 2021Apr 3, 2021
How to manually sync MS SQL databases on two different serversMany times we have a requirement where we want databases on two different servers to have same data, procs, etc.Apr 2, 2021Apr 2, 2021
Running ClamAV from a standalone separate server for NextCloudHow to configure a standalone clamAV server for all your needsMar 8, 2021Mar 8, 2021
How to synchronize wordpress environments in AWS (Part I)Almost all of us use separate environments for separate needs like dev, UAT, production, etc.Dec 29, 2020Dec 29, 2020
Why CloudWatch Alarms Are Not Triggering Your SNS Topics?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…Dec 28, 2020Dec 28, 2020
[Beginner’s guide] Amazon AWS CloudFormationDeploying on cloud is very very different as compared to traditional IT infrastructures. In cloud, your deployments no longer remain…Jun 22, 2020Jun 22, 2020