I have so far attended many different technology conferences all over the world. SQLBits 2018 is my all time the favorite conference ever. This year, I was fortunate to present 1 Pre-Con and 2 Breakout Sessions on SQL Server subjects. I had received an amazing response to my sessions and pre-conferences.
SQL SERVER – What is Forwarded Records and How to Fix Them?
During the early year of my career, one of the most popular questions I used to receive was – What is Forwarded Record? I used to find this question very valid as many people yet did not know what is the forwarded record. In most of the cases as time passes by more knowledge is spread amount SQL Server users and the number of questions reduces on a single topic. However, this is something I can’t say is true for Forwarded Records.
SQL SERVER – What is Tail-Log Backups?
A Very popular question since many years often resurfaces in my mailbox. I am writing this blog here so in the future, I can direct users to this blog posts when they ask about Tail-Log Backups.
SQL SERVER – Why SQL Server Service is Stuck in Starting / Change Pending State?
Recently, I wrote a blog about “Change Pending” state of SQL Server service. After looking at that blog one of my readers contacted me via email for the “similar” issue. In this blog, we would learn about another variation of “Change Pending” state.
SQL SERVER – How to Execute the Query Without Using Management Studio?
One of my clients asked few interesting questions during my performance tuning consultation. If you are interested, you can check more details here SQL Server Performance Tuning and Optimization. In this blog, we would discuss how to execute the query without SQL Server Management Studio (SSMS).
SQL SERVER – Patch Rule Failure: Not Clustered or the Cluster Service is Up and Online
One of my clients contacted me for quick assistance. They were trying to install a Service pack for SQL Server 2016 instance, but it was failing with below error message about cluster service.
SQL SERVER – Full-Text Search Not Working For PDF Documents
Full-Text is a feature of SQL Server which allows linguistic search in various languages. In general, we use LIKE operator to search inside the column data, but it is not very efficient. There are multiple advantages of full-text search. You can read more about this on my blog Creating Full-Text Catalog and Full-Text Search