SQL Journey

A blog about real-life SQL Server Troubleshooting, providing solutions that actually work. By a SQL Server Enthusiast.

Browse by Tags

Tagged Content List
  • Blog Post: An interesting issue with Peer to Peer Replication

    I recently ran into an interesting issue when setting up Peer 2 Peer Replication across 3 instances. The primary instance was SM-UTSQL, where we configured a Peer-to-Peer publication named "PUBLISH1" on the database "DDS-TRANS". Next, we proceeded to configure Peer-to-Peer topology...
  • Blog Post: Something to watch out for when using IS_MEMBER() in TSQL

    I recently worked on an interesting issue with my good friend Igor (@sqlsantos), where we were facing performance issues with a piece of code that used the IS_MEMBER () function. Basically, the IS_MEMBER function is used to find out whether the current user (windows/sql login used for the current session...
  • Blog Post: When using SSL, SQL Failover Cluster Instance fails to start with error 17182

    I recently worked on an interesting issue with a SQL Server Failover Cluster Instance (FCI). We were trying to use an SSL certificate on the instance, and we followed these steps: Made sure the certificate was requested according to the requirements defined here . Loaded the certificate into the Personal...
  • Blog Post: SQL Server patch fails with "Could not find any resources appropriate for the specified culture or the neutral culture"

    I recently worked on a number of issues where SQL Server Service Pack/patch installation would fail, and we would see this error in the relevant Detail.txt (located in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\<Date time of the installation attempt> for SQL 2008/2008 R2):  ...
  • Blog Post: How To: Troubleshooting SQL Server I/O bottlenecks

    One of the most common reason for server performance issues with respect to SQL Server is the presence of an I/O bottleneck on the system. When I say I/O bottleneck, it can mean issues like slow disks, other processes hogging I/O, out-dated drivers, etc. In this blog, I will seek to outline the approach...
  • Blog Post: An interesting issue with SQL Server Script upgrade mode

    Here's another common issue that I've seen quite a few people run into of late. When you run a patch against SQL Server, the patch installs successfully, but on restart, SQL goes into "script upgrade mode" and you're unable to connect to it. Upon looking at the errorlog, you see something like...
  • Blog Post: An in-depth look at SQL Server Memory–Part 1

    I know that memory management in SQL Server is one area that’s a bit of an enigma for a lot of people, and most of us only tend to know as much about memory as is related to our day-to-day activities. In this post(and others in this series), I shall seek to do a deep dive into SQL Server memory...
Page 1 of 1 (7 items)