Find Duplicate Attributes in an ESRI Geodatabase

I snapped this idea from ideas.arcgis.com,

I have been looking for a GP tool that can be used to find and list duplicate attribute values in an attribute table since ArcGIS 9.3.  I was able to find a SQL script for this purpose in the GDB Management Island at the 2012 UC, but I would have to Remote Desktop into another machine to run this process.  
If the duplicate ID values can be found and listed using a GP tool, that would be helpful in my organization's workflow process. 

Until ESRI implements this, here is a quick script (download here) I wrote for you guys to do just that.

• Open ArcMap
• Go to customize
• Go to Commands 
• Scroll until UI Controls
• Click NeW UIControl and select button
• Drag the new button anywhere in the toolbars
• Right click on the new button and click view source (make sure you are still in customize mode)
• Paste the code and run,
• you must first select the layer you want to find the duplicates in and then click the button, there you will be prompted to type-in the field name..

Batch Compact ESRI Map Document (MXD)

Do you have lots of Map Documents with huge sizes?

Compact them all with one click with this tool to more than 60% of their actual size.

Download Compact MXD Tool.

1) Just open an empty ArcMap session
2) Run CompactMXD.exe
3) Select the path where your Map Documents are located.
4) Click Compact.

I have implemented this guy's idea .

ESRI Geodatabase Downgrade Tool

Most of you must have at least few 9.x (9.2, 9.3, 9.3.1 hopefully no 9.1) while your main production ESRI geodatabase is in 10.x you must face it frustrating that your 10 data won't work on 9.x machines.

Here is a simple tool to use to "Downgrade" any geodatabase to a 9.x version.


Open ArcCatalog

Navigate to the tool.

Double click on Downgrade GDB tool.

Select your 10 gdb

Enter the information

The output will be in the same folder

The result will be the same as your selected gdb plus a 9x suffix.


Enjoy.

Microsoft BizTalk will be rendered moot, here is why

Back in 2000, long before the cloud fuss start, Microsoft saw a market for integrating different systems together, it had to come with a solution to properly mash systems together in a controlled enviroment. Bang!, BizTalk was born and it was a success indeed. Over 8500 users are using this software since.

BizTalk wasn't easy to develop at all, If you have integrated systems before you will know how dirty it is. Why? Because you are not maintaining only your product, you are interfacing with others', so if one those systems went kinky for some reason your entire product will collapse. Plus, with each hot fix in these systems you have to patch your system as well to preserve the compatibility. So you can imagine how dirty it is for Microsoft to keep maintaining BizTalk. So if you are frustrated why BizTalk is not supporting Oracle 11g maybe now you have an idea why.

Ten years later, lots of other products were born including Azure AppFabric (Microsoft Cloud product) Microsoft found out that the features are being replicated between Azure and BizTalk. No wonder, because technically, and if I can phrase it right, BizTalk is nothing but a "private" cloud in an organization while AppFabric are a set of apps interconnected in a public cloud. Make AppFabric private and you get a BizTalk.

ESRI saw it before Microsoft did, they launched ArcGIS Online (cloud based mapping), they quickly scrapped their existing old ArcGIS portal and created Portal for ArcGIS fully based on ArcGIS Online.

So yes it might not be dead, yet, but I'll give it 5 years tops.

ZdNET guys agree as well.


EDIT:
Richard states a good point why BizTalk can be good for the short run. Read here.

Bring Your Own Device

You might get frustrated with the PCs at your Organization. You dont like  microsoft word, you hate Outlook and you can't stand working with power point for your daily tasks?

BYOD helps you beat that. For instance my boss brings his macbook to work, hooks it via a vga adapter to the work monitor, uses mail mac to access his work mail, writes his documents in pages and when in need to access Windows he uses a virtual machine in his airbus ssd flash drive macbook

BYOD is taking over although there is  still the question of security and data breaches