Now Connect PHP website running in Linux Apache Webserver to SQL Server

How? Here is the answer: Preview of SQL Server ODBC driver for Linux is now available for download: Download Link: The Microsoft SQL Server ODBC Driver for Linux provides native connectivity from Linux to Microsoft SQL Server http://www.microsoft.com/download/en/details.aspx?id=28160 More info: http://blogs.technet.com/b/dataplatforminsider/archive/2011/11/28/available-today-preview-release-of-the-sql-server-odbc-driver-for-linux.aspx

0

OPTIMIZE FOR UNKNOWN in SQL Server 2005

Just helped a performance problem with the information below and thought of sharing since it might be useful in some situations.. OPTIMIZE FOR UNKNOWN introduced in SQL Server 2008 gives this benefit: “….This hint directs the query optimizer to use the standard algorithms it has always used if no parameters values had been passed to…

0

Error: 17127 "No memory for kernel buffer hash table" during startup along with FAIL_PAGE_ALLOCATION 262

This is a simple information sharing post because there is nothing much to troubleshoot… SQL Server failed to start with following message: Server  Failed allocate pages: FAIL_PAGE_ALLOCATION 262Server Error: 17127, Severity: 16, State: 1.Server initdata: No memory for kernel buffer hash table. This message appears exactly after: Server Detected 32 CPUs. This is an informational…

0

Video Tutorial on Managing Virtual Log Files (VLF) in SQL Server

Do you know what is VLF? Are you aware that as a SQL Server DBA, you need to take care of the VLF Fragmentation in your SQL Server? Do you know that not-managing VLF’s in your SQL Server databases can cause multiple recovery, performance issues? If you don’t have answer for any of these questions,…

0