Question: What is Lock Pages In Memory?
Free Video Learning – Practical Real World Performance Tuning
Earlier I wrote a few blog post about my experience with Practical Real World Performance Tuning. I have so far presented the session 4 times and I had an amazing response to my training. When I am writing this one there are over 37 positive 5 stars feedbacks. In this blog post, we will explore free video learning.
SQL SERVER – Setting ARITHABORT ON for All Connecting .Net Applications
Readers of this blog post are aware of SQL Server Expert Tim Cartwright, who has previously written an enhanced version of How to Generate Random Password script. Here is another very interesting find by Tim on the subject of ARITHABORT ON setting. It is one of the most interesting blog post I have read in a while.
How to Identify Process ID for SQL Server Services? – Interview Question of the Week #185
Question: How to Identify Process ID for SQL Server Services?
SQL SERVER – Script – Turn off Firewall Remotely (PowerShell, NetSh, PsExec)
I was working with a client to deploy an automated solution to install SQL Server. Since this involved scripting and running PowerShell remotely, we wanted to disable the firewall. Due to automation, we were not supposed to log in to the server and use UI. So, I search on the internet and found a few ways to do that. In this blog, I am going to share scripts which can turn off the firewall remotely.









