After surgery Fri am, I’ve been mostly taking it easy, but now it’s back to work. Got kids to school and at the standing desk. Overall I feel good and can walk fairly normal. Other than this big brace on my leg that slows me down and makes walking funny.
Doing well and looking forward to getting back to full strength, and also being able to travel to events again 
I’m hoping I’m only out for a day. As I write this, I’ll be recovering from my ACL surgery, though hopefully only slightly limited in work.
We’ll see. I’ve learned to hope for the best, but plan for the worst, and as a result, I decided to take Monday off from work as well, just in case. I never know how these things might go, and while it should be simple, I may want to take it easy for another day.
I’ve fallen down on my challenge over the last month. It’s been a content time, with me working more towards presentations and writing most of Mar and April to meet deadlines and commitments. I also let my calendar reminder die in Feb and didn’t renew it.
As a result, here I am, 6 months in and only done with 19 chapters. That’s a good way in, but it’s not complete. With some downtime coming, I’m looking to get back into this and using it a bit more.
Creating a directory in a Filetable share is easy. It looks like this:
It’s hard to see, but this was a right click, New, Folder in the share from Windows Explorer.
However what about creating a directory from T-SQL? That’s almost as easy.
I created that folder above by running this code:
-- create a folder INSERT INTO dbo.Explorer ( name, is_directory ) VALUES ( 'Books', 1 );
I provided a name for my folder and then a 1 for the is_directory property. Once I ran this, the folder above appeared in my share.
Note that this works for folders in the root, but not nested folders. I’ll tackle that in another post.
Voice of the DBA 