Archive | SQLServer RSS feed for this section

T-SQL Tuesday #028 – Jack of All Trades, Master of None?

This is my first time to participate in the T-SQL Tuesday so take it easy on me. I really do come in peace.

It’s funny to me that this is one of the key things that drove me into the SQL world. I blogged about this last year explaining how I “Cheated on SQL Server”. Things have kept going uphill from that point and there are no regrets, but I don’t guess I will ever go from Jack blogger to Master blogger. Sounds like I should be in a guild or something.

Seeing Argenis Fernandez (Blog | Twitter) post on Leaving DBA-Land it resonates with how I feel about the leaving the SysAdmin world. I’m not sure if you ever really leave it all behind. I find myself needing to know more than ever about storage (like SANs) and how it pertains to SQL. I find myself needing to learn more about networking and the bandwidth that matters when you are discussing how SQL talks to its friends (or enemies).

I hate code by the way, never will I specialize in writing code. I will leave that to other Jacks and Masters because I really don’t want anything to do with it. Some people’s minds just don’t work as well when it comes to that. I’ll just stick with beating you in the 40-yard dash (based off my high school time of course). I tend to gravitate towards the Database Administrator side of things with Performance and Standards. It’s kind of cool to be dogmatic about at least one thing in your career, so master the “art of saying NO” to those developers who want too much access, that way you can sleep at 2am.

What is wild is that while we are always talking about specialization, the DBA certifications are trending more towards the developer (at least they were in 2008). Crap…I don’t want to be a developer. Anyway, hope you have fun getting just a little bit closer to being a Master or Jack of some trade so that you can pay the bills.

Comments { 1 } Posted on March 13, 2012 in Blogging, Networking, SAN, SQL General, SQLServer, SQLServerPedia Syndication, Tech

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