Dealing with foreign keys when deleting rows.
Deleting rows from a table is a pretty simple task right? Not always. Foreign keys, while providing a ton of ... Continue reading
2021-10-07
78 reads
SQLStudies
SQL Homework – October 2021 – What can you tell me about the server your SQL Server instance is on?
Here are some really common questions I get: How many CPUs does ServerA have? How much memory does ServerA have? ... Continue reading
2021-10-05
51 reads
A DBA horror story in database file extensions.
CREATE DATABASE [Story]
ON PRIMARY
( NAME = N'Story', FILENAME = N'C:DataStory.mdf',SIZE = 101MB),
FILEGROUP [Line1]
( NAME = N'File1', FILENAME = N'C:Data_.It',SIZE = 102MB),
( NAME =...
2021-10-18 (first published: 2021-09-30)
502 reads
Audit Columns
One of the easiest ways to collect information about table activity is to add a series of audit columns to ... Continue reading
2021-10-11 (first published: 2021-09-28)
494 reads
#PowershellBasics: Bulk insert.
In my last post I talked about invoke-sqlcmd. It’s a nice easy way to run a query or a .sql ... Continue reading
2021-10-04 (first published: 2021-09-21)
615 reads
#PowershellBasics: Running a .sql script file.
As with all programming tasks there are a number of ways to do something, this is just one that I ... Continue reading
2021-09-27 (first published: 2021-09-16)
541 reads
Database Sizes
Quick query today. I needed a list of database sizes so came up with this: Nothing exciting, but I figure ... Continue reading
2021-09-22 (first published: 2021-09-14)
431 reads
Remote Desktop: Force the resolution to match the screen size.
One of the things I hate most about using remote desktop is when the resolution for the remote server is ... Continue reading
2021-09-09
43 reads
Auditing with “C2 Auditing” and “Common Criteria Compliance”
I’m going to be fairly high level on these because to be honest, if you are going to use them ... Continue reading
2021-09-07
65 reads
SQL Homework – September 2021 – How good is your recovery plan?
Last month I had you create a security standards document. This month we are going to document our recovery plan. ... Continue reading
2021-09-15 (first published: 2021-09-02)
245 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