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 Will Assaf
Thanks all for joining me for two sessions at SQLSaturday Minnesota 2023, and for...
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
Very excited to take part in my third #PGSQLPhriday blogging event, even more so...
I have SSDT 2017 version 15.9.50 and the Script component only shows C# 2012,...
Hi everyone, I have a sql query: SELECT NULLIF('1900-01-01','1900-01-01') The result of above query...
Hi All, I have come across one issue today and I am looking for...
Ask SSC