In a previous article, we showed how to expose an Amazon RDS instance to the public internet securely for direct access to the database. In this article we shall configure an Amazon EC2 instance for network access to an existing Amazon RDS instance. The purpose of this would be to make sure that if we deploy an application to this EC2 instance, communication from the client to the RDS instance would be smooth.
For the final release of SQL Server 2022, Microsoft popped a surprise that wasn’t in the release candidates
There are many things to consider when deciding whether to invest in a database monitoring tool or whether to use a homegrown solution. However, the business frequently wants to know one thing and one thing only: what’s the return on this investment (ROI)? In this webinar, Microsoft Data Platform MVP, Grant Fritchey, is joined by our expert panel to share the pros and cons to building a monitoring system versus purchasing one.
Steve reminds us about being charitable if we are fortunate enough to do so.
Learn the basics of the ROUND() function in this article.
This series of articles describes a path you can take to transforming an existing, manual and error-prone database development and release process into an automated and reliable Database DevOps 'pipeline', starting here with an overview of what we set out to achieve, and the people, processes and tools involved.
Learn how and why to use RAISERROR in your SQL Server code to be able to better handle errors that may occur during code execution.
When you first become responsible for a new RDS instance, what do you do? Kenneth Igiri gives you a few queries to get you started.
By Kamil
Problem The first issue that developers in my team noticed was when they tried...
On the face of it, this is a very obvious question with a very...
By Steve Jones
Today’s coping tip is to look for new reasons to be hopeful, even in...
To understand the concept of transaction log shipping, in below case, will it work:...
I have a table with 5 million records and each record requires a "Value"...
Hi Team, Can you please help me to get data pivot data. my...
Ask SSC