um anyone have tips on how to cook with salt?
Super general question here but I'll do my best.
Do you mean to ask, what do I test now that we switched to MSSQL or, we have MSSQL, what do we test?
If this app previously existing in another flavor of RDBMS, then I would look for the differences between the two.
-Are the supported data types the same? If not, do you have any new datatypes?
-Was the logic stored in the DB (Stored Procs?) If this is the case, MSSQL and Sybase use T-SQL but other platforms use completely different languages. If this is the case, then the UDFs, the Stored Procedures etc become high risk.