Monthly Archives: October 2012

migrate corrupted data

In my copy/paste post I have discussed bulk insert tool. That approach is fast but sensitive to corrupted data. Here is TSQL script which allows to reload table data between  broken and new databases. It looks not elegant to load data row … Continue reading

Posted in SQL | Leave a comment

oops, I did it again

Microsoft Virtual Academy is official MS learning resource which provides huge number of free courses. Huuuuge, but not enough. Even with ALL passed courses it is not enough to get platinum certification. There is hypothetical way to boost you points like free vouchers redeeming or … Continue reading

Posted in Uncategorized | Leave a comment

Patching trends

Last weekend I had a fun with installing service pack 2 on SQL Server 2008R2 (upgrade from version 10.50.2500 to 10.50.4000). After upgrade, I was experienced with the following issue: Login failed for user user_name. Reason: Server is in script upgrade … Continue reading

Posted in Uncategorized | Leave a comment