Posts From January, 2012

-October 2017+
SMTWTFS
24252627282930
1234567
891011121314
15161718192021
22232425262728
2930311234
  • RSS
  • Add To My MSN
  • Add To Windows Live
  • Add To My Yahoo
  • Add To Google

Statistics

  • Entries (95)
  • Comments (0)

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.

 

Site Map | Printable View | © 2008 - 2017 Fort Worth SQL Server Users Group | Powered by mojoPortal | HTML 5 | CSS | Original design by Andreas Viklund