Skip to main content

Posts

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 query Enter the following: -- Set the database to manipulate Use YOURDB; go -- Truncate the log by changing

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 repositories Download the en.linuxx86.tar.gz file from Citrix website Extract the contents of the archive Open 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 Agreement Agree to remaining defaults (y) and press 3 to quit installer Running 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

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 Properties In the Properties dialog box choose the Source tab Click Set Data Source Browse to the location of the data layer, select and click Add OK 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 ArcCatalog Right-click and select Set Data Source(s)   Highlight one of the Data Layers