SQL Server expert Allan Hirt shares what database pros need to know about their core infrastructure.

The first one was simple. The Developer Edition of SQL Server is not set up for Remote connections by default so I had to enable TCP/IP in the SQL Configuration Manager for the Database Servers.

The Microsoft OLE DB Provider is an SQL tool that enables developers to write code that provides an application with ADO access to an SQL database. The OLE DB Provider is not installed by default ...

SecurityFocus is recommending that companies running SQL Server check that their account does not have a blank password, and use a firewall to block port 1433.

Roger Jennings and a reader acknowledge that using the SQLXML interface to provide HTTP access to SQL Server is not appropriate for high-performance enterprise solutions.

Let us see how to fix the issue. Windows could not start the SQL Server (<DB-NAME>) on Local Computer. For more information, review the System Event Log.

For those legacy SQL Server 2008/R2 applications that remain critical, some form of high availability or disaster recovery protection will be required to preserve business continuity.

Quest is also introducing Toad for SQL Server v6.8, which is designed to help DBAs quickly resolve issues, manage change and ensure the highest levels of quality, performance and maintainability in ...