Having Database and Web Server on single EC2 Instance

Having Database and Web Server on single EC2 Instance

Having Database and Web Server on single EC2 Instance:

On this post we’ll see advantages and disadvantages of Having Database and Web Server on single EC2 Instance. Recently when I was working with one of the client, they were planning for migrating their systems to AWS EC2 and they asked me a simple question “Can we have Database and Web server on single EC2 instance? What are all the advantages and disadvantages of having Database and Web Server on single EC2 instance?”   There are several things needs to be considered to answer this question. We thought of document it which can be helpful for the future reference.

Advantages of having Database and Web Server on single EC2 Instance:

Continue reading

Posted in Database Design, SQL Server DBA | Tagged , , , , , , , , , , , , , , , , , | Leave a comment

Download Microsoft SQL Server Developer For Free

Download Microsoft SQL Server Developer For Free

Download Microsoft SQL Server Developer For Free. Yes Microsoft announced SQL Server Developer Edition is free. It’s April 1st but still we can believe as it is officially announced on Microsoft Information Platform. Microsoft SQL Server Developer Edition is free starting from 2014 and we should know few things:

Download SQL Server 2014 Developer for Free

Download SQL Server 2016 Developer for Free

Q. What are the limitations with SQL Server 2014 Developer Edition?

Ans:

SQL Server 2014 Developer Edition supports all Enterprise Edition features including Data Encryption and AlwaysOn Availability Groups. The only limitation is SQL Server 2014 /2016 Developer Edition can’t be used with Production data and it can be used in Development and Testing environment.

Q. Does this edition can be used  in organizations officially?

Ans:

Yes! SQL Server Team confirmed that SQL Server 2014 / 2016 Developer editions can be used for business usage in Development and Testing environments.

Continue reading

Posted in Miscellaneous, SQL Development, SQL Server DBA | Tagged , , , , | Leave a comment

SQL Script to Monitor CPU Utilization

SQL Script to Monitor CPU Utilization

This post helps you in understanding and using SQL Script to Monitor CPU utilization. There are certain scenarios where we can quickly use this script to get SQL Server CPU utilization.

  • When there is a performance issue, and you need to quickly check the CPU usage
  • When doing Root Cause Analysis
  • When we only have access to SQL Server not to Windows

SQL Server CPU Utilization history report for last N minutes:

Continue reading

Posted in Performance Tuning, SQL Scripts, SQL Server DBA | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 10 Comments