Fort Worth SQL Server Users Group

 

Posts From January, 2012

-July 2025+
SMTWTFS
293012345
6789101112
13141516171819
20212223242526
272829303112
3456789
  • RSS
  • Add To My MSN
  • Add To Windows Live
  • Add To My Yahoo
  • Add To Google

Statistics

  • Entries (106)
  • Comments (0)

Archives

Jan 18, 2012 Mike Hotek Using the HierarchyID and DBA 101 

Wednesday, January 11, 2012 10:45:00 PM Categories: Meeting

 

We have a topic for each end of the experience spectrum. For those that have done quite a bit with SQL Server:

 

1.      Using the HIERARCHYID data type

What a tree is and the basic rules around trees, what is a hierarchyid, inserting data, retrieving data, changing the tree structure (reparenting and adding new branches)

 

For those of you getting into it and for those who are about to move companies again here's a great reminder topic:

 

2.      DBA 101 – Figuring out what is THE most important deficiency

You walk into/are handed a completely dysfunctional SQL Server environment, where do you start and how do you fix it without going insane or working 200 hours a week.

 

It's Mike Hotek so you know there will likely be something relevant no matter what your experience level.

 

http://www.fwssug.com/Blog/ViewArchive.aspx?month=1&year=2012&pageid=2&mid=2