Steve’s tweets
- I'm speaking at VSLive. Register with ANSPK14 to save $400 and learn about cloud, VS, .NET, SQL and more bit.ly/ANSPK14reg 53 minutes ago
- RT @jenstirrup: Diversity Charter for technical communities and events? diversitycharterblog.wordpress.com cc @dynamiccrmcat @ClaireS_MS 1 hour ago
- RT @AllDayDevOps: At last year's #AllDayDevOps conference, @SeanDMackNYC spoke about how his team implemented #DevOps @pearson https://t.co… 1 hour ago
The Redgate Livestream
Speaking at VSLive
Tags
administration auditing Azure backup Backup/Recovery blogging bloopers business Business Intelligence career career cell phone Cloud Computing computers conferences continuous delivery continuous integration data analysis database design databases Database Weekly dbatools deployment Dev Connections DevOps disaster recovery DLM encryption Filetable Friday Poll Git hardware high availability Humor life Linux mcm Microsoft misc monitoring networking NoSQL PASS patching Performance powershell presentations Redgate sabbatical security software development software development speaking SQL Bits SQL Connections SQL in the City SQLNewBlogger SQL Prompt SQL Saturday SQLServer sql server SQLServerCentral syndicated T-SQL T-SQL Tuesday testing TopTenSkills training travel tsqlt vacation version control virtualization windows work
Tag Archives: Filetable
Two in Two Days
It’s a busy week for me. I’ve got quite a few articles to review, feedback to write for Stairway Series authors, review and changes of some PowerPoint decks for later this month, and two User Group presentations. This is on … Continue reading
Posted in Blog
Tagged Filestream, Filetable, presentations, speaking, tsqlt
FileTable– Using GetParent for Inserts
In a previous post, I looked at the ways in which I could insert files into a Filetable folder programmatically. I used a NEWID() generation process, which mimics the constraint that is coded in the Filetable schema. However there was … Continue reading
Posted in Blog
Tagged Filetable, syndicated, T-SQL
Filetable–Nesting folders and files
In previous posts I showed how to create a folder in a Filetable and also how to the create (and move) files into the subfolder. However I didn’t repeat that and wanted to test the ability to actually nest things … Continue reading
Posted in Blog
Tagged Filetable, sql server, syndicated, T-SQL
Filetable–Moving files programmatically
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 Filetable, sql server, syndicated, T-SQL
FileTables–Inserting Directories from T-SQL
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 Filetable, sql server, syndicated, T-SQL
FileTable–Adding a file to a folder
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
Managing Data in a FileTable with T-SQL
I wrote a post about creating a Filetable, which just covered the basics of how to build one. How do you work with the data in this table? In this post I’ll look at a few things you can do … Continue reading
Posted in Blog
Tagged administration, Filestream, Filetable, syndicated, T-SQL
Filestream and Filetable in SQL Server
This talk is an update of my Unstructured Data in SQL Server talk that looks at the Filestream and Filetable features of SQL Server. This session begins by presenting a case why we will manage more binary (unstructured data) in … Continue reading
Posted in Presentations
Tagged Filestream, Filetable, presentations, sql server
SQL Saturday #132 Files
Uploaded here if you need them. These are the PPT deck and the code. UnstructuredData.zip EncryptionPrimer.zip
Posted in Blog
Tagged encryption, Filestream, Filetable, speaking, sql server
Creating a Filetable
How do you create a filetable? I assume you’ve enabled Filestream and created a filegroup for your filestream and filetable data. Then you just do this: — Create a filetable CREATE TABLE AuthorDrafts AS FileTable GO The only optional part … Continue reading
Posted in Blog
Tagged Filetable, sql server, syndicated, T-SQL
