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…


How to troubleshoot – "Incorrect syntax near – Source: MSSQLServer, Error number: 102)" errors in replication

A quick guide on how to troubleshoot Incorrect syntax near – Source: MSSQLServer, Error number: 102)” errors in replication Firstly, check for any known issues like by searching with the error message in bing If there is no known issue, run a profiler by connecting to the subscriber because these errors are reported while applying…


-MaxBCPThread parameter for Snapshot and Distribution Agent in SQL Server Replication

If you have researched about replication enhancement, for sure you would have heard about this Parameter which is applicable for both snapshot agent and distribution agent. I’m going to share some useful information regarding this parameter which you can leverage in your replication environment. What is MaxBCPThread all about? When used with the Snapshot Agent, …


Error: 18056 State: 29 The client was unable to reuse a session. The failure ID is 29 after upgrading SQL 2000 to SQL 2008 SP2

I want to share this troubleshooting scenario since it may help you: After upgrading SQL Server 2000 SP4 to SQL Server 2008 SP2, SQL Server experienced performance problems and many a times, connection failures SQL Server errorlog shows this message during the problem period: Error: 18056, Severity: 20, State: 29. The client was unable to…


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,…


AUTO_CLOSE and performance issue in a .NET application

One of the interesting scenario I worked recently. .NET application which has multiple tabs showing employee details shows poor performance when run for the first time during anytime of the day but when we connect to SQL Server Management Studio and run any ALTER COMMAND, then switch back to application, performance is as expected. This…