SQL Server 2022: Backup and Restore database to AWS S3 bucket - Part 1
In this article we look at how to configure AWS to allow backup and restore from a SQL Server 2022 database using AWS S3 storage.
2022-07-13
SQL Server
2022-06-27
38,159 reads
2022-05-28
221 reads
SQL Server Graph Tables – Cross Database Surprises
Louis Davidson explains how to get around an interesting issue when doing cross-database queries involving graph database tables.
2022-04-18
MSSQL Server AlwaysON: Get alerted for inconsistencies in logins, jobs and databases
This script will create the necessary login and linked servers on a given availability replica. Please ensure that the script is executed on all the replicas.
2022-02-22 (first published: 2022-01-25)
7,969 reads
Running SQL Server on Oracle and Google Cloud
In this article, we will analyze the various out-of-the-box deployment options Oracle Cloud Infrastructure and Google Cloud Platform offers to host a Microsoft SQL Server database. This information can prove to be handy while deciding on the best cloud provider to host a given application or database.
2022-02-18
7,359 reads
The Need for 256GB
Today Steve wonders how many of you really need 256GB of RAM in Standard Edition.
2022-01-21
358 reads
Unity state machine behaviours
Video games would not be much fun without animation. In this article, Lance Talbert demonstrates Unity state machine behaviours to define code running during specific animation states.
2021-12-22
Using Power Apps Patch Function with SQL Server
In this article we look at how to create a basic Power App that allows saving data to a database table.
2021-11-24
How to Find Unused Databases in SQL Server
In this article we look at how to identify if SQL Server databases are not being used and a process to take these unused databases offline.
2021-06-14
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers