Products retiring


Products retiring   On April 12, 2016 the following products will NO longer be supported: SQL Server 2005 .Net Framework 2.0 System Center Data Protection Manager 2006 Visual Studio 2005 Dynamics CRM 3.0 Windows Embedded for Point of Service   On July 12, 2016 the following products will NO longer be supported: BizTalk Server 2006…

MS SQL Server Max-Min Memory – PLE


Setting the Memory Options Manually. Use the two server memory options, min server memory and max server memory, to reconfigure the amount of memory (in megabytes) that is managed by the SQL Server Memory Manager for a SQL Server process used by an instance of SQL Server. Error: PLE: Page Life Expectancy is number of seconds a…

MS SQL database backup file


MS SQL database backup file SQL Server 2016 Community Technology Preview 2 (CTP2) through current version). To make your database secured and protective; it helps you to restore your inaccessible files of the main database when any type of corruption or damage occurs. But, what if backup also corrupt, while attempting to restore database from…

Troubleshooting SQL Server problems


MS SQL Server problem’s. MS SQL Server is a separate technology, it is often the case that when problems occur, uncertainty arises regarding the root cause, and problem scope is rarely well outlined. Although many of the details here are not specific to SQL Server problems, they are good practices for troubleshooting many types of complex IT…

Memory configuration


Configuration ??? As with security configuration, you should make server and database configuration changes with care. Most of the configurable settings in SQL Server work best when left at their default values. You should measure any changes from the defaults for performance and stability impacts in a controlled testing environment before introducing those changes into…

Database file configuration


Database file configuration When it comes to individual databases, there are a number of recommended configuration steps that SQL Server doesn’t perform, in large part due to dependencies on disk configuration and unknown future usage of the databases. Before covering specific file configuration recommendations, let’s address some of the terms used when discussing database files:…