Here’s a simple example which helps setup the new FileTable feature in a new database. EXEC sp_configure filestream_access_level, 2 RECONFIGURE GO — Create Database CREATE DATABASE FileTableDB ON PRIMARY (Name = FileTableDB, FILENAME = ‘D:\FileTable\FTDB.mdf’), FILEGROUP FTFG CONTAINS FILESTREAM (NAME = FileTableFS, FILENAME=’D:\FileTable\FS’) LOG ON (Name = FileTableDBLog, FILENAME = ‘D:\FileTable\FTDBLog.ldf’) WITH FILESTREAM (NON_TRANSACTED_ACCESS = […]
In order to use FileTables, the following four steps must be completed, in order: 1. Enable FileStream at the instance Level 2. Provide a FileStream Filegroup 3. Enable Non-Transactional access and specify FileTable directory at the Database Level 4. Create a FileTable ALTER DATABASE ADD FILEGROUP CONTAINS FILESTREAM GO — D:FileTableContainedTestDb must exist ALTER DATABASE […]
I was looking for a easy to understand example of EL 5.0 database logging and couldn’t find one, so here’s a simple example of Enterprise Library 5.0 .NET logging. It logs to the database. Just download from github. Have fun. code: https://github.com/damienbod/ELDBLogging Database Scripts \EntLib50Src\Blocks\Logging\Src\DatabaseTraceListener\Scripts The config tool is here: C:\Program Files (x86)\Microsoft Enterprise Library 5.0\Bin\EntLibConfig.exe to […]
Clone an existing repo, cd …to your working directory… git clone gerrit:NameOfProject Create remote repo ssh gerrit gerrit create-project –name NameOfProject git remote add gerrit gerrit:NameOfProject Clean up local repo, cd to local repo git remote prune origin git fetch –tags Search for a project ssh gerrit gerrit ls-projects | grep filterExpression Delete Remote Tag […]
A cool feature in MS SQL 2012 http://blogs.msdn.com/b/mvpawardprogram/archive/2012/07/16/contained-databases-in-sql-server-2012.aspx http://msdn.microsoft.com/en-us/library/ff929055.aspx http://msdn.microsoft.com/en-us/library/ff929071.aspx Configure your SQL in Mgmt studio: The primary purpose of contained databases is to make it easier to port your database to a new server without a lot of scaffolding around it. With that in mind, I’ll treat a few potential issues that will make […]
Software Engineering 