Question: How to Install SQL Server 2019?
Answer: This is one of the unique blog posts in the history of SQLAuthority, it is merged blog post.
Install MongoDB on Windows: SQL in Sixty Seconds #091
To install MongoDB on Windows you need two downloads, the server and the shell. This post walks through the MongoDB 9 setup, then proves the install with real mongosh output: the version, a ping, one inserted document and a clean drop. It ends with the common first-run problems and the safe defaults to keep.
SQL in Sixty Seconds – Need Your Feedback
I decided to spend more time in building the videos and have created three videos in the last three weeks. It is time when I need your feedback.
Creating Covering Index to Eliminate Join – SQL in Sixty Seconds #090
How to improve performance so today we are going to see a video about creating converting index to eliminate join and improve query performance.
Remove Bookmark Lookup – SQL in Sixty Seconds #089
We fixed the query performance by removing the bookmark lookup. Let us learn about that in today’s blog post, how we can fix this issue.
Identify Index Used for Query – SQL in Sixty Seconds #088
How do you identify index used for query? It is a popular question in my health checks, and this SQL in Sixty Seconds video shows the easy way.
Stress Testing with oStress – SQL in Sixty Seconds #087
One of the things which we cover in my Comprehensive Database Performance Health Check is how to do Load Testing or Stress Testing with oStress.