This past week I installed Microsoft SQL Server 2014 Developer Edition on my dev box, and immediately ran into a problem I had never seen before. I’ve installed various versions of SQL Server countless times, and it is usually a painless procedure. Install the server, run the Management Console, it’s that simple. However, after completing … Read more
Happy Independence Day! Here I will describe an alternative to an earlier post that described using a SQL stored procedure to convert a SQL table into a JavaScript object. One of the comments left on that post made me wonder why someone would not want to use the stored procedure method. After querying a large … Read more
In order to use the information from the SQL stored proc I implemented that would create a JSON Object from a SQL table, I needed to build an RESTful API web service that would retrieve the JSON for use elsewhere. Finding information on building an ASP.NET-based API that used a stored proc to pull the … Read more