June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Enumerations in Relational Database – Best Practice

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Best Practices, Database, DBA, Software Development, SQL Documentation
Marko Parkkola This article has been submitted by Marko Parkkola, Data systems designer at Saarionen Oy, Finland. Marko is excellent developer and always thinking at next level. You can read his earlier comment which created very interesting discussion here: SQL SERVER- IF EXISTS(Select null from table) vs IF EXISTS(Select 1…
Read More

SQL SERVER – Fix : Error : 3117 : The log or differential backup cannot be restored because no files are ready to rollforward

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Backup and Restore, SQL Error Messages, SQL Scripts
I received the following email from one of my readers. Dear Pinal, I am new to SQL Server and our regular DBA is on vacation. Our production database had some problem and I have just restored full database backup to production server. When I try to apply log back I…
Read More

SQLAuthority News – Microsoft SQL Server Protocol Documentation Download

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Documentation, SQL Download
Download Microsoft SQL Server Protocol Documentation Authored by Microsoft The Microsoft SQL Server protocol documentation provides detailed technical specifications for Microsoft proprietary protocols (including extensions to industry-standard or other published protocols) that are implemented and used in Microsoft SQL Server to interoperate or communicate with Microsoft products. The documentation includes…
Read More

SQL SERVER – Mirroring Configured Without Domain – The server network address TCP://SQLServerName:5023 can not be reached or does not exist

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Certifications, SQL Error Messages, SQL Mirroring, SQL Scripts
Regular readers of my blog will be aware of my friend who called me few days ago with very a funny SQL Problem SQL SERVER – SSMS Query Command(s) completed successfully without ANY Results. This time, it did not take long before he called me up with another interesting problem,…
Read More