belle’s sql musings

new blog at sqlbelle.com

Posted in Uncategorized by belle on February 11, 2015

My new blog is at

http://sqlbelle.com

where I blog about SQL Server, PowerShell, Power BI and Visual Analytics with Tableau

Advertisements

This Is Why I Teach

Posted in musings, Teaching, Uncategorized by belle on December 3, 2008

I have been teaching IT courses since 2002; I started as a TA for relational databases and Delphi. Right now I teach part time courses in web development/design, and database development and administration. Wow, it’s already been a while and yet I can still remember my first teaching gig as if it were just yesterday.

Some people ask me why I teach. This is why:

ty   ty2 ty3

 

I take pains when developing and delivering my courses. I treat teaching very seriously. When students take my class, I want them to really learn something from it. I want them to get their money’s worth (or more!). I want them to walk away with a new skill, or new knowledge, or new discovery, after each class. When they ask me questions I don’t know the answer to, I try to look for the answer – sometimes even spend sleepless nights trying out a few test cases – and present the answer in the next class.

 

Why?
Because I love doing this.

And because I want to make a difference. However small or trivial it may be.

 

My teaching style does not work for all of my students. I do not have all the answers to student questions, and no – not all the demos are flawless in front of the students.

But if I can help someone understand a concept, or look for a solution, or just be someone to bounce ideas with, then it’s all worth it. Or just encourage them to keep on going and not get discouraged …

And sometimes, some students take the time to let me know they appreciate this. And I can’t tell them how much gestures like this mean to instructors like me.

Currently Reading Grant Fritchey’s New Book

Posted in Uncategorized by belle on May 19, 2008

Wow it’s been a while since I blogged. My other blog (http://www.sharepointmusings.com) has been stagnant because I haven’t done much on SharePoint stuff the past month. I have a few ones still on draft. I’ll try to find time to edit and publish them.

I am working on documenting strategies for optimizing queries. I’ve read a few books that have been helpful, but there hasn’t really been any one book or documentation that explains in depth how to read execution plans … until I came across this link: http://www.simple-talk.com/sql/performance/execution-plan-basics/

Whoa! How timely is that. Grant Fritchey has just published a book (May 2008!) : Dissecting SQL Server Execution Plans – The Art of High Performance SQL Code. I bought the ebook right away and started reading. Im just on p. 58 right now, and so far, pretty good. Some of the concepts I am familiar with, but Grant Fritchey has made it more clear what the icons are, when they are good, and when they are warning bells.

Ok, I’m going back to my reading …

Free Database Schemas

Posted in Uncategorized by belle on May 19, 2008

Just came across a number of good free schemas for SQL Server Express:
http://www.microsoft.com/sql/editions/express/starterschemas.mspx

This is the list, which I am sure some of you will find useful:

  • Database Schema 1: Assets Maintenance
  • Database Schema 2: Contact Management
  • Database Schema 3: Customers and Orders
  • Database Schema 4: Document Management
  • Database Schema 5: e-Commerce
  • Database Schema 6: Help Desk
  • Database Schema 7: Issue Tracking Software
  • Database Schema 8: Retail Inventory Control
  • Database Schema 9: Not for Profits
  • Database Schema 10: Product Catalogs

These are all provided by Barry Williams, who has hundreds more in his site (www.DatabaseAnswers.org)! Will definitely check those out.

 

Tagged with:

SQL Server here I come!

Posted in Uncategorized by belle on April 6, 2008

I am starting a new adventure; both nervous and excited. Ah, and guess the first thing I do. Yup, set up this blog! I need to start blogging for my sake. I enjoyed blogging about SharePoint (see my past musings at http://www.sharepointmusings.com). So why not start something for SQL Server?

SQL Server, ready or not, here I come!

The Case of the Missing Create GUID Tool (guidgen.exe) from Visual Studio 2005

Posted in Uncategorized by belle on January 13, 2008

clip_image002

The Create GUID tool is often found under the Tools menu.

image

The actual binary – guidgen.exe – is supposed to be in

C:\Program Files\Microsoft Visual Studio 8\Common7\Tools

Apparently if you did not install Visual C++ when you were installing Visual Studio 2005, you are not going to get guidgen.exe.

I didn’t install Visual C++ in any of my VMs (trying to conserve space, plus I don’t use it anyway), which explains why my Create GUID tool is missing.

There might be a better way to do (perhaps browse through the Visual Studio 2005 install files?) but my workaround is to copy guidgen.exe from one of my other Visual Studio 2005 installs.

Tagged with:

How to Register ASP.NET 2.0 in IIS

Posted in Uncategorized by belle on January 9, 2008

I was recently building a WSS 3.0 box, and got stumped when I can’t see ASP.NET 2.0 listed in IIS. I forgot I needed to register it:

C:WINDOWSMicrosoft.NETFrameworkv2.0.50727aspnet_regiis.exe -i

That’s all, just thought I’d blog this so I don’t forget next time 🙂

Canucks beat Flames 5-3 (Dec. 27)

Posted in Uncategorized by belle on December 28, 2007

Had the opportunity to watch the Canucks vs Flames, Dec. 27 2007, at the Garage (GM Place). And Im blogging because the Canucks won 😉 What an awesome awesome game (in my opinion anyway)!!!

Canucks tickets? PRICELESS

This has got to be one of the bestEST perks in my job 🙂

one of the BEST perks of my job!

Three star selections:
1st: DANIEL SEDIN (you should see the crazy the spin-o-rama! Watch it here)
2nd: MASON RAYMOND
3rd: TAYLOR PYATT

Plus, stars in my list will always include #1 Roberto Luongo, Captain Markus Naslund, Trevor Linden, Willie Mitchell and Matt Cooke 🙂

How to Disable GAC View

Posted in Uncategorized by belle on November 17, 2007

You can change the Windows\Assembly\GAC folder from the custom GAC view to the normal WIndows Explorer view by editing the Registry:

1. Start > Run
2. Type regedit
3. Go to HKEY_LOCAL_MACHINE\Software\Microsoft\Fusion\
4. Add a DWORD value called DisableCacheViewer and set the value to 1