Category: Technology

Stored Procedure Error Logging

Stored Procedure Error Logging Create table to capture Errors Create Stored Procedure to Log Error Invoke Stored Procedure in TRY/CATCH Block

 

Install and Run SQL Server Docker Container on Mac

Install and Run SQL Server Docker Container on Mac Like most people, I use Mac , Windows as well Linux OS for development and testing purposes. Primarily I use Mac for Development purpose. I have few projects which uses SQL Server as

Bulk Load Data Files in S3 Bucket into Aurora RDS

Bulk Load Data Files in S3 Bucket into Aurora RDS  We typically get data feeds from our clients ( usually about  ~ 5 – 20 GB) worth of data. We download these data files to our lab environment and use shell

MYSQL / AURORA Database Troubleshooting

Number of Connections by Host 

Aurora Max Connections

Memory-Optimized Tables

Monitor Memory Optimized Table Space Usage :

All Memory Used by Memory Optimized Table across Database Engine

Enable Natively Compiled Stored Procedure Stats Collection

DBCC FREEPROCCACHE does not remove natively compiled stored procedures from Plan Cache

Brute force attack on SQL Server

Brute force attack on SQL Server  If your business needs the SQL Server to be accessible on public network, you may be very vulnerable for brute force attacks. Following query will help you identify the failed login attempts and you

When Does SQL Server Trial Edition Expire?

When Does SQL Server Trial Edition Expire? I installed SQL Server Docker Container on Linux Machine running on EC2. I took the AMI Image and launched the existing container and wanted to know when will the SQL Server licence expires

SQL Injection attack on Website hosted on EC2 Machine

SQL Injection attack on Website hosted on EC2 Machine: I setup a website http://h1bsalary.online with publicly available dataset. As soon as I launched website, numerous trolls and automated bots sending traffic to identify the vulnerabilities. Safe-Guards I have taken so far :

Install SQL Server Docker Container on Linux

Install SQL Server Docker Container on Linux and Connect through Client Tools I was surprised by ability to run setup and run SQL Server Docker container. It only takes about 2 commands and 2 Minutes.

Version Info:

 

AWS Data Pipeline & Load S3 File Into MySQL

Getting started with AWS Data Pipeline AWS Data Pipeline is a web service that you can use to automate the movement and transformation of data. With AWS Data Pipeline, you can define data-driven workflows, so that tasks can be dependent on

AWS Regions and Availability Zones

AWS  Regions and Availability Zones

EC2 Regions and US-WEST-2 Availability Zones References: http://docs.aws.amazon.com/general/latest/gr/rande.html http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/using-regions-availability-zones.html#using-regions-availability-zones-describe

Tagged with:

SQL Server Optimizations for High Concurrency

SQL Server Optimizations for High Concurrency Our business needs very robust, low latency, highly available and durable online transactional system which supports high concurrency for about four weeks in a year. It’s almost like Thanksgiving sale where you mark down very popular item

Looking Back at 2016 !!

Gratitude Reflecting on year 2016, I feel so fortunate and lucky for my experiences. In professional side, there are gazillion things where we don’t have direct or complete control but that directly impacts our company performance as well as employees individual lives

Restrict S3 bucket Access to VPC

Allow access to S3 bucket only from VPC Currently I am evaluating options to lockdown permissions to my S3 Buckets as part of Security Enhancements. These are the steps I followed to lock down S3 Bucket access only to my

ScriptOut Change Tracking Tables

ScriptOut Change Tracking Tables

 

How to become DBA favorite Developer

Application Name : When a connection is made to SQL Server there are by default no way for SQL Server to know what software is making the connection. If several apps are using a shared SQL Server and there are

Database Development Standards

Database Development Standards The purpose of Database Design and Development Standards is to provide as much consistency to development work as possible. Create an environment where sharing team resources is easier based on code consistency. Reduce design, development, support and

AWS SLA Summary

AWS SLA Summary SLA Percentages Useful Links Cloud Provider Service Availability https://cloudharmony.com/status  

AWS RDS First Touch Penalty

AWS RDS First Touch Penalty According to AWS Documentation The first time a DB instance is started and accesses an area of disk for the first time, the process can take longer than all subsequent accesses to the same disk

Useful Free Tools and Books

Useful Free Tools Download Links Wonderful Microsoft utilities PerfMon , Profiler ,  Dynamic Management Views and System Tables should provide lot of insights and help in diagnosing and troubleshooting issues. These free tools are nice add-ons and improves the productivity.  

Top