Tag Archives | Education

Beginning SQL Joes 2 Pros Giveaway

My Books

Laptop, stickers, and artsy fartsy photo filter from camera+ not included 🙁

If you haven’t heard about the excellent giveaway that Pinal Dave (Blog|Twitter) is putting on then you are missing out. I had a little more time in the beginning to participate so I was very fortunate to receive my prize yesterday. I remember reading Pinal’s review last year and wanting to check it out for myself. I’ve got a few of the series on the Kindle and I highly recommend it to those starting out with SQL Server. Pinal also did an interview with Rick A. Morelan (Blog|Twitter), who authored the books and I would encourage you to check that out as well.

Don’t forget to head on over to Pinal’s blog and get in on the contest as there is plenty of time left to learn more about SQL and possibly win something in the process.

I’m starting to be more vocal about getting my readership up on the blog, so I’m going to start asking more questions about how I can improve things. Please feel free to add comments in the meantime if you see something that I’m doing that isn’t working or a way that I can reach more people. Ideas for posts are always welcome as well.

Comments { 1 } Posted on August 18, 2011 in SQL, SQLServer, SQLServerPedia Syndication

WordPress Google XML Sitemaps Plugin Fix

One of the more popular blogging  platforms is WordPress, and you probably already know that there are plugins which can greatly enhance the functionality of your blog.  If you care anything about letting others know about the information you are sharing on your blog, then you probably already know about Sitemaps and how they help search engines index your site.  Google XML Sitemaps is a great plugin that will get your sitemap out there for the search engines to see. Don’t let the fact that Google is in the name fool you, as it’s also effective for Yahoo and Bing.  I’ve been using this plugin for sometime, but at some point it stopped updating the sitemap when a new post was made. The only way around it was to do a manual update. The latest stable release of the plugin is 3.2.4 at the time of this writing, but that doesn’t seem to play well with WordPress 3.0.4 and a few releases below that as well. I had been searching for a  fix for some time and I finally found one that worked. A little further down the page from the latest stable release, you’ll find the following comment:

“This release is not compatible with the new multisite feature of WordPress 3.0 yet. The plugin will remain inactive as long as this feature is enabled. If you are using this feature, try out the new Beta version which fully supports multisite mode as well as network activation!”

Credit to tylercruz for the fix.

If you currently have 3.2.4 installed, you can’t install the beta without deleting your current plugin. I made a screenshot of the settings beforehand, but it looks like all the settings stayed in there so that was nice.  Hopefully someone will find this bit of info useful.

Comments { 0 } Posted on January 27, 2011 in Blogging, Education, Tech, WordPress

Weekly Reading Roundup 01.18.11

I want to begin a new process of sharing items I am reading or find that might be useful to others. I’m trying to break it down into 3 levels based on how important it can be. Try not to get hung up on which level I put it into, since I’m just trying to give more weight to certain links from my opinion.

Gold Level
iPhone Photo Management 101
This one has truly revolutionized the way I handle my pictures on the iPhone. I take tons of pictures and it can be a bit of trouble to scroll through all of them and find something I want to show someone. You could always just keep them on your computer, but if you have kids you’ll probably agree that your phone can become your digital wallet.

Pining a .BAT/.CMD File to Taskbar
If you are doing any type of Systems Administration then you will obviously find a need for this.

Wait statistics, or please tell me where it hurts
Another good resource for anyone dealing with SQL performance issues related to waits and queues.

Silver Level
The difference between the Microsoft’s Hyper-V and the VMware’s ESX hypervisor

7 ways to organize your email
I need to do a whole series on this one. If you can get an email triage going combined with GTD integration you’ll be going a long way to keeping things running smoothly.

5 Tips for Getting the Most out of Google Reader
I’ve been cleaning out my Google Reader lately and this can be a pretty helpful article.

Bronze Level
Motivational Posters: Founding Fathers Edition

17 Free Inspirational iPhone Backgrounds

The P&G 1-page memo

Comments { 1 } Posted on January 18, 2011 in Education, General, Links for the Week, SQL Server 2005, SQL Server 2008

Another way to Compare Database Tools

In a previous post title Comparison of Database Tools, I told you about a resource that Brent Ozar (Blog|Twitter) let me know about.

Today, I was introduced to a new site that will let you compare certain items based on predefined criteria that appears to be user submitted.

While the usability of the results could be debated, it still seems interesting to me.

Currently, they are somewhat limited on the “SQL Server” front since they only include CE and a Generic SQL Server reference. I’m not sure of the business model or staying power of the site, but I may decide to finish my initial ADD thought of inserting all of the SQL Versions back to 2000.

Since they are comparing items based on preset criteria, something you may want to know about won’t be included in the results.

Nonetheless, it’s pretty cool to play around with:

RDBMS Comparison

Energy Drink Comparison

And if you are a bacon fan like Thomas LaRock (Blog | Twitter) then you can check your breakfast options.

I know I’m violating Ozar’s advice about posting close to the weekend, but I just couldn’t resist the urge of posting lust that I’m going through. I have a list that I’m working and I’m trying to get towards that goal of having at least one post a week.

Update : As Ralph Wilson(LinkedIn) points out here, there are some inaccuracies(more than 1) in their data. One example is how they list Identity only for the Compact Edition. I thought I had alluded to the value that could be placed in the results, and hinted that someone should update it. Anyway, that got me to digging to see how they got their info. If you follow the “Comparison of relational database management systems” link off of the wikipedia page you’ll find similar patterns, but there are still data differences.

Update #2 : I was contacted by Matt Kopjak of FindTheBest.com who offered more info on how the data is populated.

“The results/listings are submitted by researchers at FTB. We compiled 90% of the fields and hope that one day experts will come in and edit/update the rest.”
Matt Kopjak (FindTheBest.com)

Comments { 1 } Posted on December 3, 2010 in Education, SQL General, SQLServerPedia Syndication

Get Going on Powershell

By now, I hope you have heard of a wonderful tool called Powershell which can make your life easier in some respects. Whether you are needing to interact with SQL Server, Exchange, or Active Directory there are resources available to guide you along the way. I’m not going to try and reinvent the wheel when it comes to great blog posts, so there may be a good deal of linking and summarizing.

Powershell is a command-line shell that will allow you to perform administrative tasks that would have been much more tedious if attempted in a different manner. It’s built upon the .NET so it can interact with .Net Framework objects.  Microsoft came out with Version 2.0 and released it with Windows 7 and Windows 2008 R2 (although you have to enable it).

If you already have PowerShell 1.0 installed then you may want to remove it first, unless you want to look into running both versions. You can also see how to check for a PowerShell installation. To correctly uninstall PowerShell 1.0 you can follow the instructions on MSDN.

If you haven’t already got Powershell 2.0, you’ll want to get that by downloading the Windows Management Framework Core. That core package comes with Windows PowerShell 2.0 and Windows Remote Management 2.0 (also known WinRM).

In regards to Powershell, you will now have two ways to test-drive your shiny new toy. It’s probably a good idea to try and hold off using the PowerShell ISE (Integrated Scripting Environment) in favor of using the basic PowerShell interface while you are starting out.

Getting Started
Windows PowerShell on MSDN
Why This SQL Server DBA is Learning Powershell
I’m a SQL Server DBA, and I’m in Love with PowerShell
Mastering PowerShell eBook with Dr. Tobias Weltner
Effective Windows PowerShell: The Free eBook
PowerShell in Practice (not free, but well worth it.)

Little Deeper
Administrator’s Guide to Windows PowerShell Remoting

Third Party PowerShell Editors
Once you begin to get a basic understanding of how things work I’d start looking at your other choices for editors. I use PowerGUI, but there’s also PowerShell Plus and Sapien’s PrimalScript. You can get more info about the comparison between the three from Don Jones and Michael Otey.

Idera Active Directory Scripts pack

SQL Server PowerShell Extensions
What’s New in SQLPSX 2.3

Active Directory cmdlets from Quest

Other Resources

Comments { 1 } Posted on November 29, 2010 in Education, PowerShell, SQL General, SQLServerPedia Syndication