If you’ve ever experienced the dreaded Saving changes is not permitted dialog in SQL Management Studio, this tip is for you.
To disable the message, open the Tools -> Options menu and navigate to Designers -> Table and Database Designers:
From there uncheck the Prevent saving changes that require table re-creation checkbox. Hit the OK button and you’ll be all set.
While this change might not be recommended if you’re in a production environment, it’s great to get rid of this block when you’re developing and designing your databases.
Yesterday, I had the privilege of being the first guest on the MS Dev Show. Thank you to Jason and Carl for having me on! Continue reading…
A very quick Lightroom tip: you can assign the + and - keys to any of the Lightroom develop settings. To do so, just click on the name of the setting:
You can then use the + or - keys to adjust that setting. Useful if you’ve applied a preset to a batch of photos and you just need to adjust something simple like exposure.
After generating a set of scripts to import production data to a local development database, I ran into an issue with constraints blocking the inserts (this is on a fresh database structure). To get around the issue, execute this T-SQL command on your database:
EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"
You can now insert data without constraints blocking the action. Once you’ve finished the import, you can re-enable all constraints using this command:
EXEC sp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"
And please, don’t use this on a production database! Development or testing only!
One more tip: if you see the following error, you’ve most likely inserted data that violates one of your constraints. Check to make sure all of your inserts have succeeded.
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_YOUR_FOREIGN_KEY_CONSTRAINT".
If you had the opportunity to attend my presentation at the 2014 GRDevDay, thank you for coming out to see me. You’ll find the abstract, presentation, and additional resources in this post.
A few years ago Facebook launched its anti-email campaign, saying that the future of messaging is no longer email. As of today (for me at least), they are no longer pushing emails sent to @facebook.com addresses into their messaging system.
Either they’ve achieved their goal of their messaging system being ubiquitous, or they finally decided to give up on the integration.
Today I received the X-Rite M50103 ColorChecker (Grayscale). Even though I’ve had it for just one day, I wanted to mention how much of a top-notch product this is. Continue reading…