Monday, December 16, 2013

Setting the context in an jQuery ajax call

When an jQuery ajax call is made, the .done method has a different value of $(this)

Friday, December 13, 2013

MVC with [HttpGet] and JsonResult throws exception


For security purposes, MVC prevents json results from being returned with a http get. However, there are instances when that behavior is desired and this is how it's done.

Thursday, December 12, 2013

Create a stored procedure in SQL Server 2008

The following is the default template created by SSMS when selecting new stored procedure.

I'm not exactly sure why I added this entry since I'm unlikely to forget how to select a context menu, but here it is anyway.

Wednesday, December 11, 2013

Setting up IIS, Error 500.19


When you first set up IIS on windows 7, you can get a 500 error. Things rarely work the first time for me.

Tuesday, December 10, 2013

What is SSIS? SQL Server Integration Services?


Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. You use Integration Services to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data.

The packages can work alone or in concert with other packages to address complex business needs. Integration Services can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations.

Source: http://technet.microsoft.com/en-us/library/ms141026.aspx