sql server

AWS Security Group Secures RDS by Default

Turns out, AWS security groups secure your stuff, even if you don't know it. At my employer, we finally got access to Amazon Web Services (AWS) and Vinyl Deals runs on Microsoft's Azure cloud. Despite the fact that I've written articles about AWS before, my familiarity with modern AWS is…

The Azure Tech Behind MomCharts

Last week, my company published the public preview of MomCharts.com, our baby tracking software in the cloud. One of the design goals for the software was make sure it was cross-platform, cross-device, and as maintenance free as possible. My company (Heavy Code) is a member of the BizSpark program…

Authentication and Membership Updates for MVC 4 RTM

I've spent the last couple days moving a project from MVC 4 RC to MVC 4 RTM. It's gone well, but I encountered a couple trouble spots related to MVC 4 authentication and membership that I want to share. Starting Point I'm using a MVC 4 application that was created…

5 Time Saving Features Of SQL Server 2012 Querying

Why would you want to upgrade to SQL Server 2012? Sure, if you're using an older version of SQL Server, there's many big deal reasons to justify pulling out the checkbook. Sometimes, though, it's the little niceties that get me excited. These five features promise to eliminate hours of work…

How To Use SQL CLR in Amazon AWS RDS

Recently, I went over how to setup SQL Server on Amazon RDS from within Visual Studio. In that article, I noted that there are differences between SQL Azure and SQL Server on Amazon RDS and that we needed more work to thoroughly investigate any limitations of SQL Server on RDS.…

Get Started With Amazon AWS RDS SQL Server

In the past, if you were a SQL Server shop and wanted to use the Amazon AWS cloud, your only option was to bring up Windows Virtual Machine instances and run those machines just like your on premises machines. With the new Amazon RDS SQL Server options, developers and IT…