.NET Daily

Recommended Resources


Popular Content


Navigation
Tagsql server
Featured

SQL

How To Solve: SQL Server detected a logical consistency-based I/O error: invalid protection option.

Posted on March 19th, 2018.

If you happen to receive the logical consistency-based I/O error, then your database probably ended up in an unusable state. SQL Server provide some options to repair it but it does that with the risk of potentially losing data. The syntax that I used to repair it is the following: ALTER DATABASE MyBrokenDB SET SINGLE_USER WITH ROLLBACK...

Featured

Tutorials

How to easily get a database connection string with Visual Studio

Posted on January 5th, 2014.

Because I’m working on several projects at a time, it’s very hard for me to remember any connectivity data for any of the projects. Same thing for connection strings. However, with the help of Visual Studio I can generate a connection string pretty fast if I know the server address and the credentials. Here are the steps I...