Tag Archives: microsoft

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 Advertisements

Posted in Uncategorized | Tagged , | Leave a comment

SQL Connectivity Behavior

Connecting over the Network By default, the default protocol for SQL Server clients is TCP/IP. If the connection cannot be made using TCP/IP, the other enabled protocols are attempted. A shared memory connection cannot be made over a network. Use … Continue reading

Posted in develop | Tagged , | Leave a comment

Remove SQL Server components

From https://www.mssqltips.com/sqlservertip/4050/cleanly-uninstalling-stubborn-sql-server-components/ Prerequisite MSI Inventory tool, which you can download msiinv_new.zip You can get the GUID associated with each installed product by searching around the registry, but I would rather use the MSI Inventory tool, which you can download (msiinv_new.zip) … Continue reading

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

Windows 7 on SSD

https://www.maketecheasier.com/12-things-you-must-do-when-running-a-solid-state-drive-in-windows-7/ https://www.cnet.com/uk/how-to/how-to-start-windows-7-faster/

Posted in tools | 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

Uninstall Visual Studio 2015

https://msdn.microsoft.com/en-us/library/mt720585.aspx?f=255&MSPPError=-2147217396 First run: vs_enterprise.exe /uninstall /force 2. Alternatively, you can use the “Total Uninstaller” tool to remove everything that Visual Studio or updates to Visual Studio might have installed. That is, any version of Visual Studio 2013 or later. To … Continue reading

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