Skip to main content


Showing posts from October, 2009

Clearing SQL Server Log Files (ldf)

Often I'm asked by collaborating agencies and organizations for a copy of our databases.  True, I could do an export and give them just the tables, but I'm just making work for them.  The easiest solution would be to export the SQL Server database with all the data types, rules, triggers, views and stored procedures.

What's the problem?  Log files on my databases are at least several hundred megabytes if not gigabytes.  One option is it simply send them the mdf and ask them to attach the mdf and in SQL Server 2008 if you delete the ldf reference in the attach dialog it will auto-create one.  If you want to include the ldf to avoid the conversation or have other reasons to reduce the log file it gets a little more complicated because if transaction logging is enabled the simple dropdowns won't do squat.

Compacting a log file for database YOURDB:

Start a new queryEnter the following:
-- Set the database to manipulate Use YOURDB; go -- Truncate the log by changing the -- d…

Installing the Citrix 11 ICA Client XenApp on Ubuntu 9.04 Jaunty Jackalope

If you have root access:
Install required libmotif3 package from the Ubuntu repositoriesDownload the en.linuxx86.tar.gz file from Citrix websiteExtract the contents of the archiveOpen Applications > Accessories > Terminal
Type "sudo bash setupwfc" and enter the root password
Choose "1" to Install Citrix Receiver for Linux 11.0
Accept default install location (/usr/lib/ICAClient)"y" to Proceed with installation"1" to Accept License AgreementAgree to remaining defaults (y) and press 3 to quit installerRunning Citrix now you may get the following error:
You have not chosen to trust "Name of SSL Certificate", the issuer of the server's security certificate (SSL error 61)

To fix this copy all the .crt files from /usr/share/ca-certificates/mozilla to /usr/lib/ICAClient/keystore/cacerts the easiest way to do this is to open a terminal window, browse to /user/lib/ICAClient/keystore/cacerts and enter the following:
sudo cp /usr/share/ca…

Repairing Broken Data Sources

What do you do when you open your map and you have a layer that looks like this? What does it mean?

The red exclamation point is a visual indicator that something is incorrect in the layer's data source.  To fix it you'll need to know where the data lives and tell the layer in the map this information.  You're giving direction to poor lost layer so it can find itself, you're a metaphysical geographer!

 Repairing a data source:

Right-click on the layer, from the contextual menu choose PropertiesIn the Properties dialog box choose the Source tabClick Set Data SourceBrowse to the location of the data layer, select and click AddOK out of the Properties dialog
If all went well your data is now displayed.

But what if it isn't one layer?  What if you have an entire map of mis-pathed layers?

Here's where ArcCatalog comes to the rescue:
Locate the map in ArcCatalogRight-click and select Set Data Source(s)Highlight one of the Data Layers that is in error and click Replace.…