Remember Me?

Well I am back. I’ve been out of this and many other personal projects for what, to me, seems way to long. I took on a large project that consumed most of my time and energy. Now that it has smoothed out I feel my feet coming back under me. The project has been a whirlwind of pain, frustration, accomplishment, and learning.

As with most projects of any consequence it is large and/or complex. Complexity is a curious thing when we talk about SharePoint. Does a sheer size a farm make it complex? Adding in Project? OWA make it complex? Deploying SharePoint Application farms? In SharePoint the answer can be: yes and no. In my latest project it was all of those pieces that have to be juggled to keep SharePoint alive and happy. From the complicating factors I believe that the size posed the greatest problem to this particular project.

As time goes on, and I get a chance to process what I’ve done, I’ll write it up to hopefully help you.

So in the end this all translates to… I’m back and lets talk some SharePoint.

SharePoint PowerShell: Backup and Restore a List or Document Library

Sometimes some of the most simplest things are the easy to forget. I had a situation where I was asked, ‘Hey how can I export a list for safekeeping and restore it later from a script?’ My natural answer is sure that’s easy, but after a few minutes I realized…’duh’. I figured I’d put it out there just in case.

So for our example we have the following list. Continue reading

1st tech posting of the year – My iPhones apps

Well since I spend most of my ‘work’ time on SharePoint I wanted to deviate a bit at least for this post. As it turns out I’m a bit of an Apple fanboy. I’m convinced you should use the best tools for what ever that task.

For my personal phone I use the iPhone. Here are some of apps I use and would recommend. I’ll skip the standard apps that come with the phone. They are like most Apple applications and best in class.

My favorite 3rd party iPhone apps:

  • TweetDeck (free, Twitter app)
  • Facebook (free, Facebook app)
  • OrbMedia (Pay, media stream app)
  • AppBox Pro (pay, swiss army app)
  • Evernote (free, note keeping app)
  • ScoreCenter (free, sports tracking app)
  • GPS Drive (free/pay, GPS app)
  • Demotivation (free, funny pics app)
  • Epic Fail (free, funny pics app)

While this is not a complete listing of all my iPhone apps these are the ones I use on a fairly regular basis. Take a look at them in iTunes.

Posted via email from Tech Growing Pains

The Meaning of a Window Administrator

Many times working in the computer industry it can seem like a vast mystery to those outside of the field. You or I may easily point to programmer and say how different that field is from what an administrator might do. This is to say that you or I haven’t dealt with coding issues but it’s usually a pretty big stretch. To most of the outside world they hear computer and they assume that you know everything about everything that involves computer. This leads to the false perception whether fostered or misguided that we do know everything. At times this can be very beneficial but in the end I think more harm comes to us because we can’t always answer all of those questions. It was often that I was approached at a small company I worked for and asked about some excel scenarios that I couldn’t answer. After all my knowledge of Excel could be encapsulated with ‘autosum’. While I look as excel as a basic container for data and nothing more others see it as a powerful tool to accomplish their daily tasks. When they asked that crazy question they come away with is a diminished view of my technical abilities. Which in the end is the truth; after all I am a Windows administrator not an Excel guru. I don’t claim to be and my resume certainly doesn’t state this but when people see a computer people don’t realize that there is a difference.

            I crudely equate this to being a doctor as the field began to gain legitimacy. While doctors where all viewed as quacks during that field infancy there was a twinge of legitimacy. It doesn’t mean that there were some misguided people who set this belief back and hurt the medical field, but in the end the field matured and people came to recognize medicine as a legitimate science. Even to the point that people will now recognize the difference between a cardiologist and pediatrician.

            In some ways we are generalist much like the afore mentioned pediatrician and cardiologist. After all they have to know the human body and understand how to work in that particular field, but once you start asking specific questions about their particular fields you begin to see just how different they are. In this same way this is what I believe it is to be a Windows Administrator. Different that Linux administrator, Network Engineer, or programmer, but rooted in a common field. As we develop and mature in this field more of the general public will come to understand that difference between each of us.

SQL truncate logs

Some time when we get into a bind because of neglect or ignorance we have to rely on alternative methods to the normal GUI methods. One of these situation included when I had a computer with SQL server melt down on me because of the size of it’s transaction logs. As you may or may not know a grossly large transaction log compared to it’s data files can signal a problem. Normally you want to have some type of mantenance plan to keep these in check and everything running healthy. In other cases your client may not seek to do this and you are called in after the fact. In this particular case I could even get into the GUI to shring the log file so I had to resort to this little trick.

Problem: Use an alternative method to truncate SQL logs
Solution: In command line interface you want to start SQL with a trusted connection using the following  command: ‘sqlcmd -S<SERVERNAME> -E’. The ‘S’ switch indicates which server and the ‘E’ switch establish a trusted connection. Next you should see a ‘>’ prompt. From there you can type the following:

>backup log <DATABASE> with truncate_only
>go
>dbcc shrinkdatabase(‘<DATABASE>’)
>go
>quit

This will work with a single database which can be a bit painful if you have alot of transaction logs but it should get you started in the right direction.

Firefox parameter lookups

Hi all. I’m a great fan of Firefox. While I know that Microsoft has tried to replicate many of the features I believe that Firefox has managed to keep one step ahead of them. Among one of the great features is the ability to use parametrized shortcuts. As an simple example let say you perform whois lookups from Network Solutions. Create a bookmark in Firefox with these parmeters:

  • Name:Network Solution Whois lookup
  • Location: http://www.networksolutions.com/whois/results.jsp?domain=%s
  • Keyword: whois

Now when you need to run your next whois on the mozilla.com domain type the following into your toolbar: “whois mozilla.com“. Go ahead try it out if you find yourself repeated returing to a specific website for information and would like to speed up your work flow. The key is the “%s” in your location string. Later on I’ll write about more exotic example but this has helped me a great deal already. There as some example of this on the Internet, try the Mozilla/Firefox Custom Keywords Directory. I hope that this helps you out.

What’s this all about

Truth be told I have never considered myself much of a writer or even much of an extrovert to publish a blog. I started this because as the title has hinted I wanted someway that I can share my knowledge (technical that is) that I acquire as I administrate, design, and generally tinker. Feel free to comment, use, and share.