Visual studio feeds

All Visual Studio blogs in one place

Subscribe

Enter your email address:

Delivered by FeedBurner

Increase your website traffic with Attracta.com

Google+

Contact

Email:
Subject:
Message:
Anti-spam: How many eyes has a typical person?

Follow us on FB

Search

Next Available Node with HierarchyId Data Type - SQL Server 2008

AddThis Social Bookmark Button
I have posted for the some of the function with examples and demonstrate them in earlier posts. I have wrote articles of HierarchyId data type overview, some basic functions, even demonstrate for the up-line & down-line of hierarchy nodes which you can read from below links. Breath First and Depth First Strategy - HierarchyId Data Type in SQL Server 2008 Get Downline and Upline of hierarchical data and Performance review - SQL Server 2008 Up-Line and Down-Line with HierarchyId Data type - SQL Server
2008 Here I will present how can we get next available node to be planed with HierarchyID data type function. Let's first create hierarchy data structure with script. -- Create a database and table CREATE DATABASE HierarchyDB GO USE HierarchyDB GO IF ( Object_id('HierarchyTab') > 0 ) DROP TABLE HierarchyTab GO CREATE TABLE HierarchyTab ( NodeId INT IDENTITY(1, 1) ,NodeDepth VARCHAR(100) NOT NULL ,NodePath HIERARCHYID NOT NULL ,NodeDesc VARCHAR(100) ) GO -- Creating constraint on hierarchy data type. ALTER TABLE HierarchyTab ADD CONSTRAINT U_NodePath UNIQUE CLUSTERED (NodePath) GO -- Inserting data in above creatd table. INSERT INTO HierarchyTab(NodeDepth,NodePath,NodeDesc) VALUES ('1',HIERARCHYID::Parse('/'),'Node-1'), ('1.1',HIERARCHYID::Parse('/1/'),'Node-2'), ('1.1.1',HIERARCHYID::Parse('/1/1/'),'Node-3'), ('1.1.2',HIERARCHYID::Parse('/1/2/'),'Node-4'), ('1.2',HIERARCHYID::Parse('/2/'),'Node-5'), ('1.2.1',HIERARCHYID::Parse('/2/1/'),'Node-6'), ('1.2.2',HIERARCHYID::Parse('/2/2/'),'Node-7'), ('1.2.2.1',HIERARCHYID::Parse('/2/2/1/'),'Node-8'), ('1.2.2.1.1',HIERARCHYID::Parse('/2/2/1/1/'),'Node-9'), ('1.2.2.1.2',HIERARCHYID::Parse('/2/2/1/2/'),'Node-10'), ('1.3',HIERARCHYID::Parse('/3/'),'Node-11'), ('1.3.1',HIERARCHYID::Parse('/3/1/'),'Node-12'), ('1.3.2',HIERARCHYID::Parse('/3/2/'),'Node-13'), ('1.4',HIERARCHYID::Parse('/4/'),'Node-14') GO   Hierarchy data structure as imaged as below. (Click on image to...(Read whole news on source site)

I'm Speaking at Modern Apps LIVE! (LIVE! 360) Orlando

AddThis Social Bookmark Button
I'm excited to be speaking at the upcoming Modern Apps LIVE! conference co-located at the Visual Studio LIVE!, LIVE! 360 Orlando conference November 17-21. There are still a few days left to save $600 using my speaker registration code: LSPK17 Click on the banner below to go straight to the registration page.



Here are the Modern Apps LIVE! session I'll be speaking at during the conference:
MAH05: Building a Responsive Single Page App
MAF01 Workshop: Modern App Development In-Depth: iOS, Android, Windows, and Web

I hope to
see you there and don't miss out on the registration savings that end 10/24!
...(Read whole news on source site)

DDDNorth 2014 Review

AddThis Social Bookmark Button
I had no excuse for not attending DDDNorth this year, as it was held at Leeds University, a relatively short drive from home. Not that I'd be looking for an excuse - these free events are always superbly organised and provide a valuable opportunity to see sessions from a wide range of speakers without having to take time off work. It's no wonder the tickets are always snapped up so quickly. As a contractor, I also appreciate the opportunity that DDDNorth affords me to catch up with so many friends and colleagues that I've worked with over the years, and
it was great to see so many familiar faces. With five slots during the day each offering five concurrent sessions there were plenty of difficult choices to be made. In general, I tried to attend sessions offering information I didn't think I would be able to get from books, blogs or PluralSight - stories from the trenches and architectural concepts rather than deep dives on specific technologies. The first session I attended was "So You Want To Be A Tech Lead - 10 Things You Need To Do To Succeed" by Joel Hammond-Turner (@rammesses). I was delighted to find that...(Read whole news on source site)

Office Web Apps Server will only be available for Volume License customers shortly

AddThis Social Bookmark Button
Today the Office Updates blog added a new blog post titled “Web Apps Server Removal from Download Center”. The contents of that blog post is short: As of 11-24-2014 Office Web Apps Server will be removed from the Microsoft Download Center.  At that time it will only be available for download under Volume Licensing agreements.  For more information please visit the site Volume Licensing Service Center. Office Web Apps Server, used by SharePoint, Exchange and Lync to view, preview and edit Office documents is and has been one of the key features/add-ons of these products and
allows for browser based editing and collaboration. It has up until now been available as a free download, free from licensing for reading but requiring Office client licensing for editing. So from the 24th of November you will not be able to download Office Web Apps Server (WAC) from the Microsoft Download center. To download it you will be required to have a Volume License agreement with Microsoft and you will only be able to download it from the Volume Licensing Service Center. Why this move? I don’t know. I will try to find out though… This...(Read whole news on source site)

Upcomming Scrum at Scale Workshop from Scrum.org

AddThis Social Bookmark Button
If you are scaling agility in the enterprise through scrum then you will understand when I say that this can be a very difficult problem. And it's mostly about people and about culture and the Scrum at Scale Workshop can help you. The post Upcomming Scrum at Scale Workshop from Scrum.org appeared first on naked ALM - Experts in ALM, TFS & lean-agile with Scrum.

Think a Series of Sprints, Not Marathons

AddThis Social Bookmark Button
When you drive business change and digital initiatives with Cloud, Mobile, Social, and Big Data (and Internet of Things), successful businesses think a series of sprints, not marathons. Successful businesses go digital by transforming their customer experiences, their employee experiences, and their back-office experiences through rapid prototyping, building proofs-of-concept, testing pilots, and going to production.  It’s a fast cycle of prototype –> pilot –> POC –> production. These short cycles create rapid learning loops, build momentum, and help adapt for change. In the book, Leading Digital: Turning Technology into Business Transformation, George Westerman, Didier
Bonnet, and Andrew McAfee, share some of their lessons learned in driving digital initiatives and agile transformation. The Digital World Moves Quickly Avoid Big Up Front Design.  Whenever there is a big lag time between designing it, developing it, and using it, you’re introducing more risk.  You’re breaking feedback loops.  You’re falling into the pit of analysis paralysis.   Focus on “just enough design” so that you can test what works and what doesn’t, and respond accordingly. Via Leading Digital: “The digital world moves quickly.  The rapid pace of technology innovation today does not...(Read whole news on source site)

Home