2024-03-29
6,891 reads
azure sql database
Creating a Hyperscale Database in Azure Using the Azure Portal
One of the most effective ways to fully utilize your data is to create an Azure Hyperscale database. The principles of Azure Hyperscale databases have been discussed in this article, including their cost-effectiveness, worldwide accessibility, automatic scaling, and reliable performance.
2023-12-22
1,465 reads
Creating an Azure SQL Database Using Azure Cloud Shell
This article will show how to use the Azure Cloud Shell and PowerShell to set up a new Azure SQL Database.
2023-07-07
1,255 reads
Data Lineage Scripts for Microsoft SQL Server and Azure SQL
Learn how you can easily analyze the data lineage in your SQL Server database.
2022-10-19
9,245 reads
SQL Ledger: Protecting Data in Azure SQL
Learn how you can set up and use Ledger tables in an Azure SQL Database to verify the integrity of your database changes.
2022-09-07
7,350 reads
Eight Azure SQL configurations you may have missed
Azure SQL Database has been around for over ten years and is constantly evolving with new capabilities and options. Dennes Torres explains 8 features and best practices of Azure SQL Database.
2022-03-02
Schedule Azure SQL DB Processes using Azure Functions
Learn how to schedule processes in Azure SQL Database using an Azure Function in this easy to follow step by step tutorial.
2021-08-30
2021-05-26 (first published: 2021-04-30)
8,743 reads
Blogs
Speaking at the 2025 PASS Data Community Summit
By Brian Kelley
I will be back in Seattle this year attending the 2025 PASS Data Community...
The Book of Redgate: Motivation
By Steve Jones
Another of our values is this: Motivation isn’t about carrots and sticks. Constant oversight...
A Six Week Break
By Steve Jones
Today is my last day of work for six weeks. I start my sabbatical...
Forums
Three Times a Day
Comments posted to this topic are about the item Three Times a Day
SUM([value]) and highest record type
Given a record mapping table: Id Initial Updated 1 1 2 2 3 4...
should i expect data types in task->export data from ssms?
Hi i recently exported a number of "to be purged resultsets " to .tsv's. ...
Question of the Day
Multiple Defaults
In my SQL Server 2022 database, I run this code:
ALTER TABLE dbo.OrderHeader ADD ModifiedStamp DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOI decide I need to add auditing to another table and run this:
ALTER TABLE dbo.Tracker ADD Created DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOWhat happens with these statements? See possible answers