AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Product vs logical keys8/23/2023 ![]() But, how am I going to go about implementing these major changes to the database across ten (or more) production sites while ensuring data integrity and not breaking the applications? Before I do this, however, I really think I should be focusing on these seemingly glaring issues.Īlso, we'll eventually be looking into replication to a central site, so I really think these things should be addressed before we even think of that.įiguring out a redesign scheme and maintenance plan will be time-consuming but not problematic - I've done it before at single sites. ![]() Part of what I was brought in to do was write stored procedures for everything and have our applications move to that. The majority of them are written in C with inline SQL. I have dozens of different applications that are already accessing the database. Upon inspecting the system, a couple of things jumped out at me: there are no maintenance plans or keys defined. We have a decentralized system operating on about ten sites, with each site being pounded all day by between sixty and one hundred clients. ![]() I just inherited a relatively small SQL Server database.
0 Comments
Read More
Leave a Reply. |