Posts
Sort by recent activity
SQL prompt cannot be run or uninstalled after upgrade from windows 7 to 10
Yesterday I did an in-place upgrade from windows 7 to windows 10.When firing up SSMS I get an error that SQL prompt cannot start correctly.I cannot attempt an upgrade/reinstall from the SQL Prompt ...
Strange formatting behaviour when parentheses are involved
Consider the following screenshots, where I have underlined what I consider to be formatting errors. The first screenshot includes my query as originally written.In the first screenshot, I do not h...
Creating dedicated development databases - how do you do it?
I work in an enterprise environment where we have several databases. Some of them are quite large. Large enough, at least, that we could not restore them to a developer's PC. Some of them are datab...
shared model = always up to date - Not true
I know SQLSC doesn't "support" branching, but I'd like to demonstrate that it isn't actually even compatible with branching, which will also hopefully provide some clues into what it would need to ...
Forward and reverse integration?
I am trying to bring my dev team into modern times by setting up a revision control architecture across all of development, including database development.
We are not a software shop, we are a deve...
cluster: unreachable (cannot connect) openregistryhive
Environment:
2 node cluster, call it C1. Call the nodes N1 and N2
2 instances, SQL1 and SQL2.
SQL1 is active on N1 and passive on N2
SQL2 is active on N2 and passive on N1
SQL Monitor Status
I ...