Archive | SQLServer RSS feed for this section

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

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

POLL: Which SAN vendor have you had the best “SQL” experience with?

First and foremost, I want to see a totally anonymous poll that shows which vendor is the most loved by the SQL community. At the same time, if you would be kind enough to carry on a dialogue through the comments then I believe everyone would benefit. Choosing or replacing a SAN vendor requires getting past all the marketing fluff and down to the stuff that really matters. I hope that I can start a little momentum in that direction with this poll. Benchmarks and reviews are great if you have links to share. I want to know your bad experiences as well as the days when you were glad you chose a certain vendor.

 

Here are a few links to add to the discussion. If you have additional links feel free to add them.

http://www.brentozar.com/sql/sql-server-san-best-practices/
http://www.windowsitpro.com/article/hard-disk/hybrid-ssd-solutions-142189
http://www.storageperformance.org/home/
http://www.ideasinternational.com/Home

 

Comments { 0 } Posted on June 7, 2012 in SAN, SQLServer, SQLServerPedia Syndication