Archive | SQL RSS feed for this section

Watch that live webcast alone

Photo Courtesy of http://www.flickr.com/photos/asurroca/3005149428/sizes/m/in/photostream/

So Awkward…

Sometimes I like to plan things out with lots of detail but more often than not I bounce around somewhere between “forgoing good for perfect” and finding a place to lose my latest to-do list. On this occasion I decided that I would invite a few colleagues to a live webcast from what I considered to be good source. I scrambled to invite a group and reserve a room so I thought things were looking good where around 10 people showed up. That was around 50% of the folks I had invited so considering that I gave them less than 2 hours notice I considered the exercise better than a failure and nowhere to go but up.

Well, it turns out that the webcast didn’t fully deliver in my opinion and from the feelings I got from my colleagues I hope I didn’t ding the little “street cred” that I may or may not have. I try to push knowledge and learning onto others, and sometimes I may not always connect the person with the right learning tool but that’s something I am trying to improve.

I think there are 3 key points I hope to keep in mind from this experience:

  1. Start small and invite a couple of people, or send the info out for them to watch it.
  2. Start planning and sending out invites well before the event as it will appear way more professional.
  3. Never let little bumps in the road slow you down and try to learn from even the mediocre attempts to help others learn.

 

Comments { 0 } Posted on July 4, 2012 in SQL, SQLServer, SQLServerPedia Syndication

Change Connection on Same Query

Ever so often you have one of those moments where you know that you should have known something and been using it daily, because it would have shaved seconds off of your time to perform a certain task. I believe this one even constitutes creating a new category just for this sort of thing.

Change Connections in SSMS

I found myself playing with a Solution someone had put together in SSMS that had Connections and Queries but I needed to change the connection. That lead me to this wonderful technet article that should have already been something I’ve used. This means that this whole time that I’ve had a query open in a window, I could have just right-clicked and hit the Connection –> Change Connection option.

I did find one negative aspect to this pretty quickly because the new connection will not show up in your object explorer window and I’m used to looking at that so that I know where I have been touching things. If you are careful you could end up forgetting which server you are connected to when you run that query.

 

Comments { 2 } Posted on December 5, 2011 in SQL, SQLServer, SQLServerPedia Syndication, SSMS

SSMS Tools Pack 2.0 is out!

337938459_52c83dce73

What's in your toolbox?

I know I’m a little late on mentioning that this great resource has been updated. Hopefully I can do a series on “tools in your SQL Toolbox” someday, but for now I’m just letting you know that there’s an update and it’s pretty cool. Two of the biggest new features are Tab Sessions and Execution Plan Analyzer. If you are not already using it for all of the other cool features that it has, now would be as good a time as any to go and check it out.

SSMS Tools Pack Download

Comments { 0 } Posted on September 27, 2011 in SQL, SQLServer, SQLServerPedia Syndication

24 Hours of SQLPass means free SQL training

Catch a man a fish, and you can sell it to him. Teach a man to fish, and you ruin a wonderful business opportunity.
Karl Marx

I guess if you are only in it for the money you wouldn’t want to tell your friends about an excellent opportunity to improve, but I bet you aren’t that selfish. Why don’t you go ahead and pass on the word about a great chance to learn how to do things in SQL Server you’ve only heard others blog about.

So start off on the preview page to register or get a little more info.

Here’s a download of the calendar in your time zone without registering, but if you register then you’ll have your own shiny reminders and you’ll need that info to view the sessions anyway.

my calendar

Click the image for the CST quick glance.

 

Comments { 0 } Posted on September 6, 2011 in Education, Networking, SQL, SQL General, SQLPass, SQLServer, SQLServerPedia Syndication

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