Tag Archives: sql server

FileTables–Inserting Directories from T-SQL

Posted on April 21, 2014 by way0utwest

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 … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on FileTables–Inserting Directories from T-SQL

One Database to Rule Them All

Posted on April 17, 2014 by way0utwest

This is what you build to juggle 6,000 tweets a second. That’s the headline that caught my eye and it’s about the challenges of Twitter and the data that they handle. Twitter definitely has a tough problem, one that few … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on One Database to Rule Them All

FileTable–Adding a file to a folder

Posted on April 16, 2014 by way0utwest

At my Filestream/Filetable talk yesterday at SQL Intersection, someone asked me about programmatically adding a file to a Filetable. Easy enough, I thought, since I’d seen someone do this in .NET and was thinking this has to be simple. Turns … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments

How Long Before You Upgrade?

Posted on April 11, 2014 by way0utwest

It’s 2014. SQL Server 2000 is 14 years old, but there are still quite of you managing instances. SQL Server 2005 is 9 years old, and I’m sure more of you still deal with that version. I know because I … Continue reading →

Posted in Editorial | Tagged | Comments Off on How Long Before You Upgrade?