Please open this page in the Admin panel only

Categories: Blogging, News, Professional, SSC
Comments: No Comments
Published on: July 30, 2014

I am taking a slight deviation from the usual type of posts that I share.  This time, I just want to share a quick and easy fix that I ran across due to a broken blog site that lasted for about a day starting on July 28th.

I didn’t even know there was a problem for a majority of the outage (ouch!).  And that just reinforced an age old requirement in IT.  If deploying a change – make sure to validate and test after the deployment.  Yes that was a bit embarrassing.  Despite that, there is something else to learn from the outage.

The issue started when updating a plugin called Google Analytics Dashboard.  The update was to go to version 2.1.  Upon completion of the update, all pages on my blog started posting a message that said the following.

Please open this page in the Admin panel only

That said, the root of the problem was related to the gad-admin-options.php file.  The file contained the following code.

There are several different means to fixing the problem.

  1. Disable/Delete the plugin.
  2. Comment out the code
  3. Update to 2.1.1 which was released on 7/30.

Options 1 and 3 are very easy.  Option 2 can be done via several methods.  If you have access to your admin page in wordpress, then you can edit the plugin file from the plugins page.  All you need to do is add a comment like in the following code snip.

If you don’t have access to your admin page, that’s ok.  You can still get to the file by connecting to your ftp and performing the same routine.  The file should be located in the following path.

wp-content/plugins/google-analytics-dashboard/gad-admin-options.php

See, real easy.  A little bit of a nuisance but it can be fixed quickly and easily.  Just keep in mind, when deploying a change, take the time to test and verify.  If something is not quite right, be prepared to rollback or find a fix.

What is a Favicon?

Categories: Blogging, News, Professional, SSC
Comments: No Comments
Published on: March 8, 2012

If I were to show you the tabs in the following pic without a description, would you recognize the websites to which they belong?

I would dare say that you would likely recognize them.  Not due to the labels on the tabs, but quite possibly due to the icon on the tab.

Sometimes these icons are the logo for the respective site.  Sometimes, it is just something that might be fun.  In either case, it is something that helps brand the site in a fashion suitable to you.  These little icons are called “favicons” and they are pretty easy to put in place.

If you haven’t considered doing it, I think it would be worth the effort to create one.  It is a means to brand your site.  Here is a quick tutorial on how to do it.

Tutorial

I used a free website tool to create my favicon.  You can find it here.  The tool is appropriately called favicongenerator.

 Prior to being asked how to create one, I had no clue what those little pics were called.  Nor did I know how easy it was to create one.  It took me a few minutes searching the internet to figure out what it was called (I think I started by searching for “tab icon internet”).  Once I learned that it was called a favicon, it was easy to find instructions on how to create it.  Now it should be just a bit easier.

SQLServerPedia Blogger Awards

Comments: No Comments
Published on: February 16, 2011

Several moons ago I learned that I had won one of the categories for the 2010 SQLServerpedia Blogger Awards.  You can read about that here.  Of all of the promises made in that post, I have yet to fulfill two of them (one is being fulfilled now).  I can’t fulfill the other promise because I do not have a cubicle at work – just an open work area.  That said, I am prominently displaying my trophy in my work area.

As you can see in the image, I have displayed my trophy (though the photo does not prove that it is at work).

Again, I am thankful to have won and I will continue to blog and try to put out useful information to the blogosphere.

Thanks to all who voted for my entry (which was really just one part of a series).

P.S.  I have a really good reason for this post coming out so late too.  My award was delivered in the middle of me moving from Vegas back to Utah.

Blogger Awards

A few days ago I wrote about an election that was taking place (ok so it was a week ago at this point).  That election was the SQLServerpedia Awards.  My first post on that election can be found here.  I had wanted to write another post about the election and make a whole bunch of campaign promises – to help make it feel political.  One big difference is that I was going to run a positive campaign and just talk about what I would do if I were to win.

Well, I won in one of the categories and I never wrote that campaign promises post.  So, I will just tell you what I would have promised and then maybe do some of those things.

  1. I will display the trophy in my cubicle at work
  2. I will support my fellow bloggers as much as I can just as I have done in the past.  There are some exceptional bloggers out there.
  3. I will continue to work with SQL Server
  4. I will continue to blog!!!!
  5. I will also finish my series on the book review for which I won.  Then I will progress to the next book or two and write reviews for them as well.
  6. I will continue to provide posts to SQLServerPedia

Thanks to all who voted for me.  I appreciate the support.  I recommend checking out the other books in the Book Review category.  I also recommend that you read the Blogs of the other people that were nominated for the SQL Choice Awards/ SSP Awards.

In short, this award is great and I really appreciate it.  In the grand scheme of things I am happy to have received it and rest assured that it doesn’t change my blog or me – except that I will post a badge on my blog.  We also had many excellent DB professionals and bloggers who won in various other categories.

Thanks SQLServerpedia for the awards and putting on these awards for the community.

Sp_whoAmI

Comments: No Comments
Published on: August 24, 2010

I was doing a little catching up on some blog reading today and came across a new post from Adam Machanic (Blog | Twitter).  The post is titled Who Are You and is asking for input from the readers.  Quite frankly, I think it is a great idea.  Adam is asking for people to do a little stand up and tell everybody a thing or two about themselves.  He wanted that info left in the comments, but I thought it would be better to write a post on the topic and link back to it.

First things first.  Why is this a good idea?  Well, it helps to know the readers as Adam said.  There truly is a nice bit of satisfaction when somebody leaves a comment on your blog.  It is even better when you feel like you know that person.  Better yet is to know that there are people you know that are reading your blog – whether or not they comment.  There are plenty of people (judging from the comments) that Adam knows and that read his blog but may not leave a lot of comments.  It is also really helpful to know the interests of the readers and try to put out some stuff that may be of interest to them.  I see this being of particular help when there is a little writers block.

What about me?

My name is Jason Brimhall and I have been doing database stuff for a little over 10 years.  My current title at my employer is Database Architect.  I am more than a database architect – I get to wear many hats.  I get to do the Architect stuff, administrator stuff, warehouse stuff, and occasionally I get to write a stored proc or two.  I have been blogging now for just about 9 months.  I have administered 4500+ servers as well as 1TB+ databases.  I have worked on SQL 6.5 – SQL 2008 as well as a spattering of Oracle and MySQL (don’t quiz me on those).  I live in Las Vegas and am the Vice President of the local Users Group (Web | Twitter ) (which reminds me that I need to get that UG twitter account notice out).  Outside of work, I like to spend time with my children as well as play basketball and run.

Edit:  I forgot to tell you what my twitter handle is…@sqlrnnr

Blog Script Nuances

Categories: Blogging
Tags:
Comments: No Comments
Published on: April 30, 2010

I recently ran across an issue that is really annoying. I use a plugin to display my TSQL scripts in the original formatting. Unfortunately it does not maintain that original formatting in all areas.

The specific case I ran into deals with the word “TEXT.” When using that word as a part of a FOR XML Path statement, it gets upper cased. Upper case version of text is not a valid command for the FOR XML Path statement. It will cause an error. The code still showed it as lower case when I went to edit it, but the display of the code was what was changed.

The only workaround is to leave a note stating that it should be LCASE instead of UCASE.

Blog Changes

Categories: Blogging
Tags:
Comments: 1 Comment
Published on: April 12, 2010

I have made some small but hopefully effective updates to my blog.  The changes are in an effort to make the Blog a little more visible.

I added an SEO plugin.  This should have make the blog more visible in web searches (Google, Bing).

In coordination with that, I changed the naming strategy for my pages.  The pages are now more search friendly rather than the WP default numbering system.  This should be a good thing too.

I also added a MobilePress plugin.  This should help make my Blog more visible to the portable devices.

I have also added the Social Links plugin.  This provides little icons to various social type sites.  This just so happens to be one of the types of plugins that I had installed that was deleted upon theme change.

I hope this makes the site better for the readers.

I have one more Plugin in mind but cannot find a good plugin for it yet.  The plugin would place a FeedBurner Icon so the user can subscribe to my feedburner feeds.  I have seen a redirect plugin.  The problem with that is that I do not want all of my feeds to be redirected to the same feedburner feed.  If anybody knows a good plugin, let me know.

WP and Themes

Categories: Blogging
Tags:
Comments: 1 Comment
Published on: April 12, 2010

I have been meaning to write another article on Blogging for some time now.  The intent has been that I wanted to write about my discoveries concerning WordPress and blogging as time elapsed.  For this time around though, I will only discuss one topic (and some correlating subtopics) about my Blog.

I recently changed the theme to my blog because I have never been 100% satisfied with the theme I have picked.  So far, I am getting closer – but have not been completely satisfied with any theme that I have chosen.  How hard could it be?  I remember reading a note from Brent Ozar about making sure you liked your theme  (it is part 4 amongst the Blogging articles he wrote).

When I first read that, I interpreted it as – find a theme and stick with it.  After going back and reading the statement again, it seemed more along the lines of finding a theme you liked for certain so you would not have to deal with editing it.  I think both interpretations work well.  Find a theme and stick with it.

After changing my theme this last weekend, I found a lot of annoyances – and none of them should have been theme related.  I had several plugins that were installed and configured (not theme related plugins) that just disappeared.  Now I have to find the plugin again and reinstall it.  Then there are the problems with widgets not being properly lined up and so you have to tweak with all of them for a bit to get it looking good again.  Add to that, those settings are supposed to be saved but seldom are.

Despite these annoyances, I will deal with it.  Doing the blog is much more rewarding than the pains that come with it.

SSC Syndication

Categories: News, Professional
Comments: No Comments
Published on: January 7, 2010

Steve Jones at SqlServerCentral.com has created a Blog for me over there at SqlServerCentral.com.  I will be syndicated there and hopefully increase the Blog exposure a little bit.  This being a new adventure (the whole Blog idea), this is a good move for me at this time.  Through Blogging, I hope to push myself a little more and learn more about SQL server.

Pages and Posts

Categories: Blogging
Tags: , ,
Comments: No Comments
Published on: January 6, 2010

For the past couple of days I have been stumped on a very trivial thing with my blog site.  I really want to be able to be able to add posts to different pages in my menu bar.  I know I could add those posts to categories.  I can even use categories in my menu bar.  However, that option does not cut the mustard for me.

To achieve this, I tried several plugins.  None of them worked as advertised.  That was frustrating and annoying and the plugins will be removed.  I continued my google search and finally came up with something that seems to work.  I went so far as to try several themes to see if any of them could accomplish this very feat.  All I accomplished with that was a short test drive of several themes.  On the positive though, I did find some that I like very much and may use them at some future time.  This fix is more of a band-aid/ workaround – but at least it works.  Many thanks to the other wordpress blog that discovered this little trick.

Here is the original blog on how to get this working.

http://agileom.com/index.php/blog/word-press-posting-on-different-pages-finally-i-did-it/

Again, many thanks.  Now I have in essence a combination of categories and pages on my menu bar – but they appear as pages.

page 1 of 1








Calendar
March 2017
M T W T F S S
« Jan    
 12345
6789101112
13141516171819
20212223242526
2728293031  
Content
SQLHelp

SQLHelp


Welcome , today is Saturday, March 25, 2017