Viewing 15 posts - 3,556 through 3,570 (of 39,819 total)
We do have a site search, which does limit to this domain for google. You can also limit by content type.
Is there something you were looking for?
August 22, 2019 at 2:34 pm
The main point of the article is that we should expect data to change and allow for this. Not just with database design, but with the ETL, NULL/defaults, and more....
August 22, 2019 at 12:38 am
Congrats, Steve! How'd you like Potsdam?
I have a lot of friends who went to Potsdam.
Just as long as she doesn't root for Clarkson hockey...! 😀
It's a neat town. We...
August 22, 2019 at 12:35 am
As I see it, there is nothing wrong with "immutable" natural keys. LastName + FirstName + MiddleName as a natural key? NEVER!!!!!
The one thing I'll say in defense of...
August 21, 2019 at 3:27 pm
This is one reason I dislike many natural keys as PKs.
I don't understand how this follows from the discussion.. First, there's not a whole lot of cases where there...
August 21, 2019 at 3:26 pm
If you are doing updates, then SSIS works great. If this is a full migration each time, there is the SQL Server Migration Assistant that works well. A number of...
August 21, 2019 at 3:21 pm
A lesson from The Phoenix Project. No one should be above others. You might know more, but you don't get to break rules.
August 21, 2019 at 3:18 pm
Glad you enjoyed it. I missed it when retrying it today as well.
August 21, 2019 at 3:16 pm
You alter the key to use the new server certificate.
August 20, 2019 at 7:53 pm
The data could be structured differently, different amounts on pages, so reclaiming space might end up looking different later. Check fillfactor and any other config differences as well. Might be...
August 20, 2019 at 2:49 pm
It should still work. Was the data the same? The cleantable should rebuild the table and recover space.
August 20, 2019 at 2:48 pm
Which Microsoft page? There are differences in editions, so you need to know that. If you use developer, free, you can't disable telemetry. That's the price of the edition. For...
August 20, 2019 at 2:45 pm
I'll ping Mike for updated images.
August 20, 2019 at 2:22 pm
Viewing 15 posts - 3,556 through 3,570 (of 39,819 total)