Archive | SQLServerPedia Syndication 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 02 : Indexing Powershell Scripts

It was until I recently had a pc failure that I remembered what it felt like not to be able to have windows search inside powershell files. By default, the indexing options are set to only index the “File Properties” but not the “File Contents”. There may be other cases where this is beneficial to you, but this one was the biggest for me. For me, it was a simple fix:

Start -> type index in white box, select Indexing Options.
Select Advanced, File Types tab.
Find ps1 and change it to “Index Properties and File Contents”, click OK and move along.

Caution: You will see the notice that you are about to be grab a cup (few pots on my system) while the index rebuilds so do this when you have some time.

You could also follow the instructions on the bottom of this technet wiki for a more granular approach.

Have you found any other files that would benefit from this? It’s been so long since I explored this and I’d love to hear other thoughts.

Comments { 1 } Posted on January 30, 2013 in PowerShell, 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