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.
I’m heading back to SQL Bits for the third time and I’m excited to be going again. I think that this is my favorite conference, hands down. The large mix of people, the incredibly welcoming hosts and the casual atmosphere make this one of the events I look forward to every year. It also means I get to swing by the Red Gate office without making a special trip.
This year the event is in Telford, near some racetrack that’s supposed to be famous. I’m not sure if they is any tie in with the event, but who cares. Chances are you won’t want to leave SQL Bits because you’ll be alternately excited by the content and charmed by the hosts and other attendees.
I’ll be delivering two talks at the event:
I’ve done both of these a few times and they are very popular and thought provoking. I’m hoping that the crowd enjoys them as much as I do.
If you can make it to the UK, register today and I’d love to see you there. This is a great event, and I’m sure you’ll learn a ton and enjoy yourself while doing so.
