Category Archives: Uncategorized

Recovering From SQL Server ‘recovery pending’ Status

Seeing a database in any state other than “online” makes me a little nervous. For one thing, it’s one of those things I don’t see often, so I have to rub a few brain cells together to remember what I … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Get the SQL Server database in the normal state

SQL Server Management Studio reports a database in “Recovery Pending” status. USE master ALTER DATABASE [dbname] SET OFFLINE WITH ROLLBACK IMMEDIATE ALTER DATABASE [dbname] SET ONLINE WITH ROLLBACK IMMEDIATE

Posted in Uncategorized | Tagged , | Leave a comment

C# Fundamentals

https://www.pluralsight.com/courses/csharp-fundamentals-csharp5

Posted in develop, Uncategorized | Tagged , , , | Leave a comment

SQL Server 2016 SP1

https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2016-service-pack-1-sp1-released/   Understanding Incremental Servicing Model for SQL Server A CLONED database always contains the schema and the default clone also contains the statistics and query store data. For more information refer KB 3177838. How to determine the version, edition and update level … Continue reading

Posted in develop, Uncategorized | Tagged , , | Leave a comment

IBM Nov & Dec 2016

https://www.ibm.com/blogs/policy/ibm-ceo-ginni-romettys-letter-u-s-president-elect/ https://aws.amazon.com/blogs/apn/case-study-industrial-strength-software-using-amazon-web-services-storage/

Posted in Uncategorized | Leave a comment

CIF single chip

Device Manager has an yellow exclamation sign for the CIF Single Chip. In fact it was the old rusted Trust web cam driver that was not installed. Download that driver from http://www.trust.com/en/product/14382-webcam-wb-1400t F:\Downloads\Drivers\Trust-WEBCAM WB-1400T\Trust_WEBCAM WB-1400T_14382-03_02.exe

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

Add the DVD drive to Windows 10

1) Go into device manager, under IDE ATA/ATAPI, uninstall both channels 0 and 1. Reboot immediately. When it reloads, your lost DVD player should now be there. 2) (not working) Type cmd in windows search. right click on Command Prompt. … Continue reading

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