AdventureworksCI Step 5 Adding tSQLt to the solution
This is part of a series on how to take the Adventureworks database and bring it in line with modern standards. How do we put a legacy SQL Server...
2015-07-22
Ed Elliott's Sql Developer Blog
AdventureworksCI Step 4 Pushing to GitHub
This is part of a series on how to take the Adventureworks database and bring it in line with modern...
2015-07-29 (first published: 2015-07-22)
1,776 reads
AdventureworksCI Step 4 Pushing to GitHub
This is part of a series on how to take the Adventureworks database and bring it in line with modern...
2015-07-22
29 reads
AdventureworksCI Step 4 Pushing to GitHub
This is part of a series on how to take the Adventureworks database and bring it in line with modern...
2015-07-22
36 reads
AdventureworksCI Step 4 Pushing to GitHub
This is part of a series on how to take the Adventureworks database and bring it in line with modern standards. How do we put a legacy SQL Server...
2015-07-22
3 reads
Keep your environments in-sync and your upgrade scripts fresh
Whether we use a tool to generate upgrade scripts or we write manual test scripts for database changes there are...
2015-07-21
423 reads
Keep your environments in-sync and your upgrade scripts fresh
Whether we use a tool to generate upgrade scripts or we write manual test scripts for database changes there are...
2015-07-21
35 reads
Keep your environments in-sync and your upgrade scripts fresh
Whether we use a tool to generate upgrade scripts or we write manual test scripts for database changes there are...
2015-07-21
34 reads
Keep your environments in-sync and your upgrade scripts fresh
Whether we use a tool to generate upgrade scripts or we write manual test scripts for database changes there are a few things that we should bear in mind...
2015-07-21
Pre-Compare & Pre-Deployment Scripts to SSDT
When you use SSDT to deploy database changes you can include a pre/post deploy script which is run after the...
2015-07-20
1,281 reads
Blogs
My 2024 in Data: Health and Workouts
By Steve Jones
This is my last week of the year working (I guess I come back...
My 2024 in Data: Reading
By Steve Jones
This is my last week of the year working (I guess I come back...
Book Review – Agile Data Warehouse Design
I recently read the book Agile Data Warehouse Design – Collaborative Dimensional Modeling, from...
Forums
Windows could not start the SQl server (SQLEXPRESS) service on Local Computer (M
I have a common problem that I just cannot figure out after scrolling through...
Adventureworks data does not load
Hello, I am a new member here so forgive me if I am not...
Restore Procedure not working
I created a small procedure that reads the backup file and restores the DB...
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