Upcoming Free Webinars on Database Development and Operations
Fall is in swing, and it’s officially webinar season! Here’s a bunch of free events I’ve got on my calendar. Weekly Database DevOps Live Chats – a new experiment...
2019-11-19
1 reads
2019-11-16
4 reads
2019-11-16
8 reads
Links and Resources from “How to Architect Successful Database Changes”
Steve Jones and I had a great time today talking about source control for databases and release patterns for performance and availability in Seattle. We had a great group...
2019-11-06
19 reads
2019-11-06
2 reads
2019-11-06
5 reads
Project Management and Advocacy
I’ve observed few similarities between the Project Managers and Advocates. Being Project Manager, law bachelor and little practical experienced as an Advocate, I noticed few similarities. I think it’s...
2019-11-04
7 reads
Project Management and Advocacy
I’ve observed few similarities between the Project Managers and Advocates. Being Project Manager, law bachelor and little practical experienced as an Advocate, I noticed few similarities. I think it’s...
2019-11-04
17 reads
Does it matter ?
A series of articles that will talk about most important but least focused areas in Database Design and Development.
2019-10-31
4 reads
Does it matter ?
A series of articles that will talk about most important but least focused areas in Database Design and Development.
2019-10-31
4 reads
Blogs
2 Tips to a Working Schedule
By Brian Kelley
When I watched the following video from Justin Sung, I realized that I am...
Monitoring SQL Server Performance with the Pure Storage FlashArray OpenMetrics Exporter
I’m excited to share a new open-source project I’ve been working on that combines...
Teaching at the SC Statewide Audit Conference
By Brian Kelley
Instead of teaching the CISA exam prep course, I'm teaching in the IT track....
Forums
Why Clone Fails: Discovering the Hardware Beneath Azure SQL MI
Comments posted to this topic are about the item Why Clone Fails: Discovering the...
A Well Deserved Break
Comments posted to this topic are about the item A Well Deserved Break
Multiple Defaults
Comments posted to this topic are about the item Multiple Defaults
Question of the Day
Multiple Defaults
In my SQL Server 2022 database, I run this code:
ALTER TABLE dbo.OrderHeader ADD ModifiedStamp DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOI decide I need to add auditing to another table and run this:
ALTER TABLE dbo.Tracker ADD Created DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOWhat happens with these statements? See possible answers