Tag Archives | SQL Server

QuickHitter 04 : SQLCat.com whitepapers all in one place

Who knows how long the resource will be out there, but sure makes it easy to go find a whitepaper on a topic when they are all in one place.

Hit up the consolidated index of whitepapers for more info.

It was one of the only places I could find a working link to one of the whitepapers.

Comments { 0 } Posted on October 16, 2013 in SQLServer, SQLServerPedia Syndication

QuickHitter 03 : Put some Windows updates in my basket

Maybe this is just news to me, but I didn’t know this resource was out there. In comparing the updates between two nodes on a cluster, I found out about the “Microsoft Update Catalog” where you can add updates to your basket and download them all at once. I also found the cluster validation wizard lists the same updates as missing.

Not sure if this will be beneficial in all cases, but when trying to match up servers with updates it might help someone. Don’t forget that updates can be superseded and try to trust your WSUS server.

Comments { 0 } Posted on May 9, 2013 in SQLServer, SQLServerPedia Syndication

QuickHitter 01 : SSMS 2012 Templates in a new place

In an effort to post more often, I’m going to try and a new series of posts that take less than 15 minutes to bang out and may help someone else (or me, when I forget in a few days). No images included, usually less than 2 paragraphs, and other little things that can help me procrastinate posting. This introductory paragraph won’t count against that limit of 2 paragraphs for this first one and I may refine this as I go.

I was reading through “The Red Gate Guide to SQL Server Team-based Development” an excellent book  and saw the whole templates thing that I have briefly toyed with from time to time. Props to Red Gate Software for providing great resources like this for the community.

Anyway, the path to the templates appears to have changed from the reference in the book for 2012:
C:\Users\<UserName>\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\Templates\Sql\

For 2012:
C:\Users\<UserName>\AppData\Roaming\Microsoft\SQL Server Management Studio\11.0\Templates\Sql\

Comments { 3 } Posted on December 24, 2012 in SQLServer, SQLServerPedia Syndication

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

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