Read our high-quality articles on SQL Server administration. Learn how to efficiently administer the world’s biggest DBMS, that is SQL Server.
About the Error Message: “Exclusive access could not be obtained because the database is in use” A very neat feature of SQL Server is the way it lets the DBA to control connections. To this end, you can explicitly control connections with specific commands and methods. Even though this is not usually needed, there are … Read more…
In this article, we will be discussing about the “A transport-level error has occurred when sending the request to the server” error message, you might get in SQL Server. This article’s purpose is to explain the above connectivity error and ways of resolving it. Why you might get the “transport-level” error in SQL Server … Read more…
I was recently asked by a friend, how can we control the level of locking in SQL Server when executing SELECT, UPDATE, INSERT and DELETE statements. The answer to this question is by using locking hints. Locking hints direct SQL Server to the type of locks to be used. Even though the SQL Server Query … Read more…
This short post, discusses about SQL Server 2008 Feature Pack, what it is and what functionality it offers. SQL Server 2008 is undoubtedly an extremely powerful Relational Database Management System. It comes with many new features that increase the database developer’s productivity and make the life of the DBA easier. In September 2008, Microsoft has published … Read more…
This article, discusses about the SQL Server 2005 Surface Area Configuration Tool. What is SQL Server 2005 Surface Area Configuration Tool? An important security improvement in Microsoft SQL Server 2005 is that various of its features that could be potentially susceptible to security risks are turned off by default. One of these features is … Read more…
Hi friends, this article discusses the “Backup Compression” feature in SQL Server. About Backup Compression in SQL Server How many times have we backed up a database and then we have tried to minimize the size of the backup set by compressing it with an archiving utility? I am quite sure that such cases … Read more…