My last post addressed generating Guid values which were sequential across system boundaries. The problem with other algorithms is two-fold. First, they are only sequential for a single system. Second, they are based off the MAC address of the system »
Today Ayende released his sequential guid answer, which is something I had been working on as well. I’ll be honest and say the current implementation takes from his recent posts (previous to today’s). If it weren’t for him, I would not have known about »
Sometimes you think you know and then when you go and open your big mouth and make a fool of yourself. I generally script all my database changes by hand. Not 100%, if it’s a big change I’ll right-click the object and use the script menu command to »
I’ve had many spirited discussions over time with my colleagues on this issue. And I will most likely invite a flame war from the developer community for this post, but after reading this post As a disclaimer I don’t take issue with the decision to use »
In my last post I mentioned I would be addressing tables next, but as I read through the documentation I realized something. Because Oracle doesn’t have the same concept of databases as SQL Server I need to use schemas to segregate my data. In order to »
In Episode 1 I addressed database instances but I’d like to correct a technicality. I compared SQL Server instances with Oracle Database instances. While this is pretty much correct, I’d like to add that technically this isn’t correct. At least not according »