Azure SQL DB VS SQL Server For the DBA
Being the start of the new year and with new projects most likely starting again I would like to share...
2019-01-07
299 reads
Arun Sirpal
SQL Server Backup To Azure Storage
Once again I would like to share with you an article I wrote about backing up (and restoring) a SQL...
2019-01-01 (first published: 2018-12-19)
2,732 reads
Azure SQL Database DTU Versus vCore
I wrote a guest article for an IT consultancy on Azure SQL Database, more specifically DTUs and vCore options. At...
2018-12-17
870 reads
SQL Server I/O
Sometimes I like to see and know what SQL server is doing under certain operations and recently I wrote an...
2018-12-11
219 reads
Azure SQL Database “Step By Step” Tutorials
I would like to share a link to my Azure SQL Database Stairway series hosted over at SQLServerCentral. As stated...
2018-12-06
449 reads
Azure SQL Database – Firewall Rules
If you decide to use IP addresses to control what services have access to your Azure SQL Database, then understanding...
2018-12-04
224 reads
Microsoft Professional Program vs Microsoft Certification
When learning new technologies many people will go towards training courses (in person or online) but many also go for...
2018-11-15
255 reads
Azure SQL Database – Fixing My Scaling Failure
This is kind of a follow up from my last blog post about a scale down request issue. (https://blobeater.blog/2018/11/07/azure-sql-database-aborting-scale-request/) I...
2018-11-14
220 reads
Azure SQL Database – Aborting Scale Request
Scaling up or down an Azure SQL Database is a very common task. Whilst common it is also very easy...
2018-11-07
281 reads
Azure SQL Database – Who Changed My Auto Tuning Settings?
One of the features Microsoft wants us to use for Azure SQL Database is Automatic Tuning. Automatic Tuning is a...
2018-11-01
287 reads
Blogs
My 2024 in Data: Reading
By Steve Jones
This is my last week of the year working (I guess I come back...
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...
Forums
Need ADF pipeline suggestion to copy 1 million files
I have an ADF pipeline that copies Files from source to destination. Both Source...
Function Defaults
Comments posted to this topic are about the item Function Defaults
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