Searching For SSIS Packages

SSIS packages are handy. They can do all sorts of things and the developers here use them a lot. One very useful feature is that you can set up connection objects in your package so it can connect to any of your servers to do what it needs to do. This is also one of […]

SQL 2008 R2 SSMS Doesn’t Show Database Compatibility Levels on SQL 2012 Servers

I installed my first SQL 2012 server recently and came across an interesting issue I thought I’d share. When you connect to a SQL 2012 server using SSMS from SQL 2008 R2 and view the database options page, you do not see options for the database compatibility level. Here is a look at the compatibility […]