Changes to the Virtualization Support Policy for SQL Server

Policy Support for Virtual Environments Our policy of support for virtual environments has evolved, we now support almost all our applications to virtual environments. Some recommendations are to be considered depending on the product, I invite you to read the articles and using corresponding product below. Platform for non-Microsoft virtualization, a certification program has been…


The SQL Network Interface library was unable to register SPN

The SQL Network Interface library was unable to register SPN. Problem In the SQL Server error log you got the following message: The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098, state: 15. Failure to register an SPN may cause integrated authentication to fall…


How to install SQL Server 2008 32Bit on Windows 2008 X64

How install SQL Server 2008 32Bit on Windows 2008 X64 In a specific case, you have to install SQL Server 2008 32Bit (X86) on Windows 2008 X64. It can be due to the provider of your end application who supports only on a SQL 32Bit his application. If you want to install SQL server 2008…


Determining SQL Server Table Size

Determining SQL Server Table Size There a few days, I had to identify areas of my database that were taking up the most physical storage space.The process that the stored procedure goes through is very simple. I create a temporary table to store the individual data elements for each table.The Script has been tested and…


SQL Server Management Studio spends over 10 seconds to load

Problem descriptionSQL Server Management Studio spends over 10 seconds to load.CauseIn general, this behavior is due to 2 things:1. The host computer not has access. By default “SQL Server Management Studio” is configured to use online help resources. 2. The host computer not has access. SSMS tries to go on internet to check for server…