Creating the cert for Windows 8 Apps The following howto was taken from the following website: https://bytescout.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=296 Changes must be made to the makecert args, otherwise the Metro app won’t accept the pfx file! INFO: http://msdn.microsoft.com/en-us/library/windows/desktop/aa386968(v=vs.85).aspx .PFX file (Personal Information Exchange format) is the file containing both a public (.cer file) and a private (.pvk […]
I find it very exciting that TFS is starting to support git at last… Here’s some links. http://arstechnica.com/information-technology/2013/01/microsoft-embraces-git-with-new-tfs-support-visual-studio-integration/ http://blogs.msdn.com/b/bharry/archive/2013/01/30/git-init-vs.aspx http://blogs.msdn.com/b/visualstudioalm/archive/2013/01/30/getting-started-with-git-in-visual-studio-and-team-foundation-service.aspx
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 