Category Archives: Administration

Restoring objects in SQL Server

This is a code googled in panic after occasional deletion of a stored procedure. Does real magic saving hours of work that could be spent on re-writing:   Advertisements

Posted in Administration, programming, Uncategorized | Tagged , , | Leave a comment

Table compression test

A bit unexpected result during compression testing: ColumnStore indexes and PAGE compression might outperform depending on data. The only measure stable is load time: 2 hours to load into tables organised as ColumnStore indexes versus 1 hour to load into the … Continue reading

Posted in Administration | Tagged , , , | Leave a comment

Bug: hadoop map reduce jobs are pending too long.

It seems that one and the same problem presents in both Hortonworks SandPit virtual machine and HDInsight Emulator (most likely because of old versions of Hadoop): jobs are always in pending status and no explicit errors/exceptions appear in jobtracker/tasktracker logs. The solution for the Emulator is … Continue reading

Posted in Administration | Tagged | Leave a comment

VMWare RAM-usage optimisation

The problem: when you shut down a virtual machine, quit VMware Workstation and try to shut down the host (Windows 7 Enterprise) shutting down the host approx. lasts about 10-15 minutes. Solution that was found here is a bit incorrect: … Continue reading

Posted in Administration | Tagged , | Leave a comment