Skip to content

The Dev Mill

Finding Solutions to My Problems and Yours

Toggle menu
  • Home
  • CV
  • Log In

Year: 2019

11 November 201915 June 2021Troubleshooting

Identifying which tables are updated by a transaction

One of the applications I work with has more than 900 tables, so as you can imagine trying to determine where the data lives can sometimes be difficult. This script shows me which tables were updated by the last transaction. Add the database name in the USE and […]

23 May 201915 June 2021Helpful, Troubleshooting

Changing the AM and PM designator dynamically

I received the error ‘The string was not recognized as a valid DateTime. There is an unknown word starting at index 17’ on a server when trying to convert a Date and Time string to a DateTime, but I had no such error in development or testing. The […]

Recent Posts

  • Because You Are Agile, It Doesn’t Mean You Are Doing Scrum 
  • Debugging an MVC call
  • I Generated a Site Icon with AI
  • Null result returned when getting section or connection string from Configuration
  • Dependency Injection in a Console App

Tags

Azure AD C# CSS Dates Design Errors Java MVC PowerApps Power Automate RegEx Scrum SQL SSMS SSRS Tips VBA Word

Categories

  • Best Practice
  • Helpful
  • Playing Around
  • Troubleshooting
  • Tutorial

Archives

  • 2025 (1)
  • 2024 (1)
  • 2023 (5)
  • 2022 (8)
  • 2021 (13)
  • 2019 (2)
  • 2018 (2)
  • 2017 (1)
  • 2016 (4)

Recent Comments

  • Gerald NMN McCulla on Converting an Array of JSON Objects to Key Value Pairs in Power Automate
  • John Riggle on Stop SSRS From Sending Empty Reports
  • Derek on SSRS Error: Maximum request length exceeded.
  • stabile on Working with SharePoint List Multi Value Fields in Power Automate
  • Hairstyles on Nested transactions Part 1 – Save Points
Proudly powered by WordPress