Read a story about how one company saved substantially on their cloud costs with a few simple changes and no interruptions to service.
2026-08-21
2,021 reads
Learn how to efficiently run SQL Server using Amazon Elastic Container Service for a hassle-free Docker container experience.
2026-05-25
This article shows how you can deploy SQL Server Developer Edition in an AWS Kubernetes configuration.
2026-02-02
1,393 reads
This article explores how to securely clone the master user permissions in Amazon RDS for SQL Server using a custom stored procedure, usp_rds_clone_login. It outlines a step-by-step process to generate, review, and apply a script that replicates server- and database-level access from the master user to a new login without directly exposing elevated credentials. The guide emphasizes the principle of least privilege, supports named account management, and enables transparent, auditable permission handling for DBAs and applications. Designed for secure and scalable environments, this solution enhances operational security while maintaining administrative flexibility in Amazon RDS.
2025-07-09
1,113 reads
Linked servers in Amazon RDS for SQL Server allow seamless connectivity to remote databases for distributed queries and data integration. In this article, I guide you through the step-by-step process of creating a linked server using SQL commands, from setting up authentication to testing the connection. Learn best practices, advanced configurations, and essential considerations, including why you can't use SSMS for linked server setup in RDS. This professional guide is tailored for experienced database administrators looking to optimize cross-server operations.
2025-01-29
1,890 reads
AWS offers a robust suite of tools designed to manage big data effectively. This article explores focusses on how SQL is leveraged within Amazon Redshift and Amazon Athena. We will delve into the technical features, practical applications, and step-by-step examples for using these services, highlighting how they can transform raw data into actionable insights for your business.
2024-10-16
385 reads
Learn how to create a backup of an AWS RDS for SQL Server database and download the backup file to use on another SQL Server instance.
2024-09-16
Mistral 7B is the first foundation model from Mistral AI, supporting English text generation tasks with natural coding capabilities.
2024-04-03 (first published: 2024-03-21)
438 reads
Any user who has a backend in AWS can leverage python to query the database and generate insights on the data by leveraging bedrock and langchain library
2024-03-21
1,056 reads
In this script we will leverage the capabilities of Amazon Bedrock's Generative AI service to author SQL statements.
2024-02-03
644 reads
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
Comments posted to this topic are about the item The New World Of AI...
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
What does this return on SQL Server 2025?
select bit_count(null)See possible answers