Tag Archives: sql server

Filetable–Moving files programmatically

Posted on May 6, 2014 by way0utwest

I’ve been playing with Filetable and I was asked an interesting question. Can I move files to a folder programmatically? It’s trivial to do this in Explorer. Just drag and drop, and I’d expect that most people using Filetable from … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Filetable–Moving files programmatically

The Cardinality Estimator in SQL Server 2014 – Going Forward and Backward

Posted on April 30, 2014 by way0utwest

I saw a talk from Joe Sack (b | t) on the cardinality estimator (CE) in SQL Server 2014 and found it very interesting. To be fair, some of the "how it works" isn’t something I care about much, but … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on The Cardinality Estimator in SQL Server 2014 – Going Forward and Backward

Consolidation Matters

Posted on April 21, 2014 by way0utwest

Throughout my career I’ve been looking to consolidate SQL Servers when I find them. The typical employer I’ve had usually grows their IT infrastructure over time and many projects look like this: Build or buy a software package Buy a … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Consolidation Matters

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