Blog Update – Mobile version of ssistalk.com now active!

For those of you that wished this site was accessible on mobile clients, this request is now complete. The site will detect that you are browing with a mobile client and present you automatically with a format suited for your device. Please let me know if you run into issues. Also, when viewing the mobile […]

Read more
SSIS 2008 – Cannot Show Visual Studio 2008 Tools for Applications error

Should you come across this error message, “cannot show visual studio 2008 tools for applications”, you may have to clean up your VSTA environment. You may also have the following additional error message: The System Cannot Find The File Specified Here’s how to fix it, thanks to Silviu Guea, Microsoft. Create a batch file with […]

Read more
Be careful with sp_configure

For those of you that work extensively with sys.dm_exec_query_stats and associated plan cache DMVs, be aware that altering the server’s ‘max degree of parallelism’ setting will flush the query plan cache. You may see this message in your server’s SQL Log file: “SQL Server has encountered 1 occurrence(s) of cachestore flush for the ‘SQL Plans’ […]

Read more
SQL Server 2005 – How to introduce data corruption without trying

It is quite easy in SQL Server 2005 to accidentally (or intentionally, I suppose) create data corruption. It’s best to just show via a demo, so here you go: (Ref: http://www.sqlservercentral.com/Forums/Topic915058-2669-1.aspx. Thanks, Paul White, for doing all of the work for this post. 😉 ) — In SQL Server 2005 only — fails select round(0.5,0) […]

Read more