Thursday, May 28, 2015

Work Cultures & Technology Stack extensibility and their impacts on attaining Goals!


Single Door – You can walk through, see the other side and even when you find it’s not appealing as you planned there is no possibility to walk back the door and return to last known good state

Double Door – You can walk through, see the other side if it’s not appealing as you planned for there is every possibility to walk back the door and return to last known good state

Revolving Door – You can walk through, see the other side if it’s not appealing as you planned for, there is enough instrumentation to provide real time feedback on why the plan went sideways resulting in one of the following outcome

1.       Team consumes the feedback course corrects and walks in through the door. Keep repeating the process till the goal is attained

2.       Walk back the door and return to last known good state – When the results are disastrous compared to plan

I personally prefer the Revolving Door, but wont mind Double Door. Buck stops ( or should I say SHOULD stop there) there.

Monday, May 25, 2015

How to create SQL Registered Servers


1.       Open SSMS and select Registered Servers from View(Cntrl+Alt+G)


2.       Expand the Database Engine Node, right click on Local Server Groups and select “New Server Group”
 
3.       Choose the desired name and description for the server group and click “Ok”
 
 
4.       Right Click on the newly added Server group and select “New Server Registration”

 
 
5. Specify the server name in the “Server Name” text box and desired display name in “Registered Server Name” text box and navigate to “Connection Properties” tab.



6. Choose “Browse server” from the “Connect to database” dropdown list and click “Yes” when prompted for confirmation.

7.       Browse and select the relevant database, and click on Test to test if the connection is successful.





8. Click “Ok” and then “Save” to add this server to your local group.
9. Repeat the steps 1-8 to add more servers.
 
 
 
 
10. Right click on the server group and select New Query









  11. Execute your query in the query editor, notice that the an additional column is included in your query results that calls out the server name