Archive | Education RSS feed for this section

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
ScriptCenter
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.

Add-ons
Idera Active Directory Scripts pack

SQL Server PowerShell Extensions
What’s New in SQLPSX 2.3

Active Directory cmdlets from Quest

Other Resources
http://technet.microsoft.com/en-us/scriptcenter/powershell.aspx
http://gallery.technet.microsoft.com/ScriptCenter/en-us/site/search?f[0].Type=ScriptLanguage&f[0].Value=Powershell&f[0].Text=Windows%20PowerShell
http://powershell.com/cs/
http://poshcode.org/
http://powershellcommunity.org/Forums.aspx
http://www.powershellpro.com/powershell-tutorial-introduction/powershell-tutorial-active-directory/
http://blogs.microsoft.co.il/blogs/ScriptFanatic/
http://technet.microsoft.com/en-us/scriptcenter/ee861518.aspx
http://www.networkworld.com/community/node/42218?source=nww_rss
http://dmitrysotnikov.wordpress.com/2007/06/28/get-a-list-of-all-user-properties/

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

SQL University

Jorge Segarra is onto something pretty cool. Head on over to SQL University and check it out. I’m going to run through it myself in the coming weeks because everyone should be trying to polish up on the SQL.

Comments { 0 } Posted on October 16, 2009 in Education, SQLServerPedia Syndication

SQL Server Tacklebox

I know I’m a little late posting this as I’m sure you’ve already downloaded the free Ebook and read through it, but if you haven’t be sure to go grab a copy.

It’s got some good stuff in it.

Comments { 0 } Posted on August 24, 2009 in Education, SQL General