Database Administration / SQL Error Messages / SQL Server / SQL Troubleshooting
by Manzoor Siddiqui · Published July 28, 2015 · Last modified September 24, 2015
1.1kviewsThis is very common issue and faced by many database users while connecting to database. When you try to connect to SQL Server, you may get error as: “A network-related or instance-specific error occurred...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published July 27, 2015 · Last modified September 24, 2015
796viewsIf you want to find out which port is used by SQL Server then you can do the same by T-SQL or from SQL Server Configuration Manager (SSCM). Default port for SQL Server is...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / SQL Troubleshooting / Tutorials
by Manzoor Siddiqui · Published July 25, 2015 · Last modified September 24, 2015
930viewsIf you select Windows authentication mode during SQL Server installation then ‘sa’ login is not enabled and you have to enable it manually if you want to use it. Due to security reasons it...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published July 24, 2015 · Last modified September 24, 2015
911viewsAuthentication is the process of verifying the credentials and if it is correct then allowing to access the database and its components. Only valid identity will be granted the access to the database server....
Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published July 23, 2015 · Last modified September 24, 2015
1.4kviewsRecovery model plays very important role when it comes to data recovery or to minimise data loss. You need excellent understanding of your business requirements and importance of data. Depending on scenarios you have to decide whether you...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published July 21, 2015 · Last modified September 24, 2015
1.1kviewsMicrosoft has introduced backup compression feature from SQL Server 2008. This feature is very useful to save the time, reduces device I/O and storage cost and it is also a good backup strategy option. You...
More
