Using Checksums to test for Unexpected Database Schema Changes

USE [DATABASE-NAME]
GO

SELECT CHECKSUM_AGG (CHECKSUM (
                TABLE_NAME,
                COLUMN_NAME,
                CHARACTER_MAXIMUM_LENGTH ))
FROM INFORMATION_SCHEMA.COLUMNS

Database Object Generator

Database Object Generator creates objects for tables in a database. Objects are generated as C# code. Here are two different DataObject Generators:

• DbObjectGenerator
  Plug-in for Visual Studio. no DLLs, no maintainability issues, and no startup performance cost... more 

• CodeTrigger
  Code Generation For C#, WPF, WCF, SQL SERVER/ORACLE/MYSQL and Visual Studio 2010-2015... more 

CoffeeScripts

CoffeeScript is a little language that compiles into JavaScript. Underneath that awkward Java-esque patina, JavaScript has always had a gorgeous heart. CoffeeScript is an attempt to expose the good parts of JavaScript in a simple way... more

Microsoft Remote Connectivity Analyzer

Tool... more

CodePen - Playground for the Front End Web

Show off your latest creation and get feedback. Build a test case for that pesky bug. Find example design patterns and inspiration for your projects... more

Emmet — the essential toolkit for web-developers

Emmet is a plugin for many popular text editors which greatly improves HTML & CSS workflow... more

SQL CDC Error

When trying to enable the CDC on SQL database, the following error message displays:

• Could not update the metadata that indicates database is enabled for Change Data Capture. The failure occurred when executing the command SetCDCTracked (Value = 1)

This error message comes when trying to enable CDC on a SQL Server 2008 database when the owner is not "sa".The fix for this is to change the database owner to "sa" by executing the below script:

• USE <database-name>
• GO
• EXEC sp_changedbowner 'sa'