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 More info:


Snapshot replication fails after adding a column to a table (article)

This post is all about “replicate_dll” property in sp_addpublication, so if you are aware of this property then this is the answer for the problem described in the blog title. Here is a little more background about this issue: A column was added to an existing table using the query below: ALTER TABLE [db].[tblUsers] ADD [BloodGroup]…



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…


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…


Large Network Packet Size and Memory Pressure in SQL Server

Today I worked on a interesting performance issue whereby SQL Server 2005 x86 (32-bit) had sever Non-BPool memory pressure causing all sort of errors lilke Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 1048576 Downgrading backup log buffers from 1024K to 64K Failed allocate pages: FAIL_PAGE_ALLOCATION 6 SQL Server failed with error code 0xc0000000 to spawn a thread to…