I often get asked a question about how actually Session ID of SQL Server is mapped to Operating System’s’ Thread ID. Well, the answer is very simple, here is the script which provides us three important details – SQL Session ID, OS Thread ID and OS Scheduler ID along with the state of the task.
SQL SERVER – Authentication in SQL Server (Windows and Mixed Mode) – GDPR Series
On May 25, 2018, European privacy law is going to enforce new global standards for privacy rights, security, and compliance. This new regulation is known as GDPR – General Data Protection Regulations. Lots of users who are using SQL Server often wonder How to make SQL Server GDPR compliance? Before you read this blog post, I suggest you read my earlier blog post about here which explains everything about GDPR. This blog post we will take about Authentication in SQL Server (Windows and Mixed Mode) which is for GDPR Article 25.
SQL SERVER – How to Kill All the Processes for Any Database?
Recently during Comprehensive Database Performance Health Check, to test our unique fix, we had to run a stress test on my customer’s development environment. Once we were done testing our script, we did not need our stress test queries to run on our server. Even though we stopped to run the batch file with stress test queries, there were few long-running queries kept on running on the server. This brought us to a very interesting point where we had to kill all the processes for one particular database.
SQL SERVER – DMV to Get Host Information – sys.dm_os_host_info
There was a time when SQL Server used to run on only Microsoft Windows. However, the time has changed and SQL Server now runs on Linux as well. This is indeed a great move as I believe database such as SQL Server should be running on multiple platforms. This is indeed a very interesting but it ads one more additional check before I jump into Comprehensive Database Performance Health Check. In this blog post, we will learn about how to get host information from OS.
SQL SERVER – How to Make SQL Server GDPR Compliance?
I am really not sure how many times I have been asked about GDPR Compliance in the recent months. You must bookmark this page and share with your organizations if you are doing business with European Union or firm based out of European Union.
It is quite often to see the email in mailbox with the following title –
How to Make SQL Server GDPR Compliance?
SQL SERVER – Activity Monitor – Active Expensive Queries
Recently during Comprehensive Database Performance Health Check, I had a very interesting conversation. SQL Server has introduced Activity Monitor many version earlier. I think everybody is now pretty familiar with this tool and use it frequently. However, during my consulting work, I use different scripts which are much more efficient than Activity Monitor. However, it is alright to use it once in a while.
SQL SERVER – FIX: Number Data Type from Oracle Linked Sever Shown in Scientific Notation
One of my clients contacted me for an issue where they reported that they are seeing an issue with numbers when they are accessed via Oracle linked server.