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…
Author: Raju V
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. $docker pull microsoft/mssql-server-linux $docker run -e…
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 C:\Users\Raju>AWS ec2 describe-regions C:\Users\Raju> aws ec2 describe-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: AWS
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 SELECT sys.schemas.name AS Schema_name , sys.tables.name AS Table_name , ‘ALTER TABLE ‘ + QUOTENAME(sys.schemas.name) + ‘.’ + QUOTENAME(sys.tables.name) + ‘ ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON) ‘ + CHAR(13) AS SQLScript FROM sys.change_tracking_tables JOIN sys.tables ON…
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 StandardsThe 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 maintenance…
Petition to Support H.R.213
Petition to Support H.R.213 – Fairness for High-Skilled Immigrants Act of 2015From : Raju Venkataraman 22202 Estate Hill Drive San Antonio TX- 78258To : Congressman San Antonio, TX 78258My Experiences as H1B Visa Worker from IndiaI am Raju Venkataraman, 38 years…
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. Download…
AWS RDS API Reference
AWS RDS API Reference Some of the RDS API command usuage . Editable parameters list for SQL Server. AWS RDS Options Group aws rds describe-option-group-options –engine-name sqlserver-se AWS RDS SQLServer SE 12.0 Parameter Groups aws rds describe-db-parameters –db-parameter-group-name default.sqlserver-se-12.0 AWS RDS…
Remote Host Identification SSH Error
Remote Host Identification SSH Error Rajus-MBP:.ssh Raju$ ssh -i Key.pem [email protected] @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @ WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! @ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY! Someone could be eavesdropping on you right now (man-in-the-middle attack)!…
AWS SQL Server RDS Native Backup Restore
Steps to Restore .bak SQL Server backup file to Amazon SQL Server RDS
Step by Step Guide to backup and restore SQL Server backups on AWS RDS through S3 Buckets.
Dynamic SQL Search Stored Procedure
Dynamic SQL Search Stored Procedure
This also includes how to safeguard against SQL Injection by escaping single quotes through SQL function.
Caching SQL Server Tables After Restart
SQL Server Cached Pages and ways to bring data pages to memory
We noticed considerable latency in stored procedure execution after restarting SQL Server Instance which was triggered by accessing data from disks instead of memory. So we ended up writing a simple script to bring data pages to memory. This helped us to avoid first touch penalty after restart in production environment.
(No Ratings Yet)
Loading...
Top