A New Word: Alazia
alazia– n. the fear that you’re no longer able to change.. I don’t have alazia. I’m always thinking I change, sometimes even when I don’t want to. Certainly my...
2024-04-05
12 reads
Blog Posts
Apr 9 Webinar: Accelerating Success: De-risking and Streamlining Releases with Flyway Enterprise
UPDATE: This moved to Apr 9 Join me Tuesday, Apr 9 for a webinar, 10:00am CDT. You can register here and then come watch live with questions or get...
2024-04-05 (first published: 2024-03-26)
227 reads
Using SQL Elastic Pools
We use SQL elastic pools at work. I needed to learn more about their nuances and help you with some of their challenges. Setting Up Elastic Pools Here‘s some...
2024-04-05 (first published: 2024-03-29)
467 reads
Webinar Apr 9: Accelerating Success: De-risking and Streamlining Releases with Flyway Enterprise
On Tuesday I have a webinar with a Redgate sales engineer: Accelerating Success: De-risking and Streamlining Releases with Flyway Enterprise. This will cover You can register here. In this...
2024-04-05
7 reads
Spring 2024 Speaking Engagements
I will be presenting Answering the Auditor’s Call with Automation at two upcoming events, one virtual and one in-person.
DBA Fundamentals Virtual User Group Tuesday, April 9 2024 at Noon...
2024-04-03 (first published: 2024-03-26)
119 reads
SQL Compare Force Column Order in a Table
I had a client that was concerned about SQL Compare behavior when a developer adds a column to the middle of a table. I wanted to reassure them, so...
2024-04-03 (first published: 2024-03-20)
351 reads
Off to SQL Saturday Salt Lake City … on Friday
I’m off on Thursday for Salt Lake City and a SQL Saturday on Friday. SQL Saturday Salt Lake City 2024 is happening, and I’m glad I get to go....
2024-04-02
52 reads
How I use Terraform to deploy my AWS amplify react js project
As a Software Engineer, I would like to deploy my AWS Amplify react js project using Terraform so that I can automate my workflow and eliminate any manual intervention...
2024-04-01
9 reads
Interview around DevOps, Data, AI and Microsoft Fabric
A few weeks ago I did an interiview with Nagaraj Venkatesan – a good friend of mine who works for Microsoft Singapore. You can watch video below – I...
2024-04-01 (first published: 2024-03-20)
177 reads
The PASS Data Community Summit 2024 Call for Speakers
The PASS Data Community Summit call for speakers and volunteers is open. You have until April 10 to submit something, and you can do that here: Data Community Summit...
2024-04-01 (first published: 2024-03-22)
122 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