Articles by DaveDbViewSharp (Articles: 3)

Database Development
SQL Server	Using SQL Server Metadata and Statistics to Build a Table Explorer Application 1 Oct 2012 Updated: 1 Oct 2012 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 22,451 Bookmarked: 7 Downloaded: 488 Please Sign up or sign in to vote. Develops an analogy between database table and file directory information and argues that it could be very useful if it were possible to have a similar application to Windows Explorer for database tables. Demonstrates how to obtain the information from Sql Server system tables and dynamic management
Programming Languages
SQL	Creating a REST Server for a CRUD Web Application from a very Light Stack 8 Nov 2013 Updated: 8 Nov 2013 Rating: 4.87/5 Votes: 13 Popularity: 5.42 Licence: CPOL Views: 58,626 Bookmarked: 33 Downloaded: 1,257 Please Sign up or sign in to vote. Using lightweight server and database components, the article builds a REST server that returns serialised JSON objects to a single-page web application written in JQuery or AngularJS.
	Two Handy Techniques for Creating Dynamic SQL in Stored Procedures 14 Feb 2012 Updated: 14 Feb 2012 Rating: 4.91/5 Votes: 6 Popularity: 3.82 Licence: CPOL Views: 32,601 Bookmarked: 16 Downloaded: 176 Please Sign up or sign in to vote. Describes two techniques to use when generating dynamic SQL in stored procedures and provides an example that demonstrates what happens when they are combined