SQLAuthority News – 3 Performance Tuning Presentations at SQLBits 2018 – London

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.

Read More

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.

Read More

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).

Read More

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

Read More