Tag Archives | QuickHitter

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