Azure Storage Replication Types
Storage Accounts are pretty much integrated into so many different designs in Azure, whether you are using Azure Synapse, 3rd party product like Snowflake, or Event Streaming designs –...
2022-06-15
59 reads
Arun Sirpal
Azure VM Scale Sets
I really like scale sets. It lets you create and manage up to 1000 load balanced VMs per availability zone using windows or Linux images. (We can have flexible...
2022-06-09
43 reads
Azure VM Types
There are many different family groups for Azure VMs each with its own purpose. Below is a summary of what can be selected. This is important because for example...
2022-06-06
15 reads
Azure High Availability
Lets write about Microsoft Azure, specially the area of high availability when it comes to virtual machines. No doubt you will know about Azure Virtual Machines. IaaS approach is...
2022-05-31
15 reads
Azure SQL Managed Instance – Maintenance Windows
A post close to my heart, Azure SQL Managed Instance, I have blogged about this many times but I feel I should be sharing more details about this. One...
2022-05-12
271 reads
Azure Redis Cache and Geo-replication
The concept of a geo-replicated partnership between a primary and secondary node is very similar to that of something you may have seen with Azure SQL DB, where the...
2022-05-06
67 reads
Azure Redis Cache – Persistent Data
I mentioned before that you could use the idea of data persistency to rebuild your data from total failure. There are two types. RDB and AOF. RDB – persists...
2022-04-28
36 reads
Azure Redis Cache – scaling
Let’s assume that you started off with the lower editions and capacity with Redis and your developers tell you to scale the Redis cluster. Well first to use a...
2022-04-25
27 reads
Tips for Azure Redis Cache
My learnings on Redis thus far which you may find useful: Location of Redis should be close to your app. Data structures within Redis, larger key value sizes lead...
2022-04-19
8 reads
Azure Redis Commands
Now that we have created our Redis Cache lets connect to it. You can use the most common tool redis cli.exe https://redis.io/download or as I am going to do,...
2022-04-14
121 reads
Blogs
My 2024 in Data: Speaking
By Steve Jones
This is my last week of the year working (I guess I come back...
Top 5 Advanced SQL Courses for 2025 (Must-Know)
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...
My 2024 in Data: Travels
By Steve Jones
This is my last week of the year working (I guess I come back...
Forums
Function Defaults
Comments posted to this topic are about the item Function Defaults
Big Data or Small Data
Comments posted to this topic are about the item Big Data or Small Data
Level 4 of the Stairway to Synapse Analytics: Create and Use a Delta Lake
Comments posted to this topic are about the item Level 4 of the Stairway...
Question of the Day
Function Defaults
I have created this function in SQL Server 2022:
CREATE FUNCTION dbo.AddInt (@one INT, @two INT = 1) RETURNS INT
AS
BEGIN
RETURN @one + @two
END
How can I call this and invoke the default value for @two? See possible answers