Archive for

AutoRecover SQL BI Projects

Just in case you forgot where this setting is… It has saved my bacon more then once Or everything you ever wanted to know or not know about auto revocery in Visual Studio. AutoRecover is perhaps a developers best friend. It can be a real life saver if the dev environment crashes or there is … Continue reading

sp_executesql Vs EXECUTE Command

  A dynamically build Transact-SQL statements can be executed using EXECUTE Command or sp_executesql statement. Here, in this article in my examples, I’ll be using sp_executesql which is more efficient, faster in execution and also supports parameter substitution. If we are using EXECUTE command to execute the SQL String, then all the parameters should be … Continue reading