It becomes a great win-win situation. Let us learn about Extended Event wait_info in this blog post. Do you think this script will be useful for you?
SQL Server – InMemory OLTP Hash Collisions Performance Overhead
Sometimes the best of learnings are based on people’s questions. I always feel when questions are asked, more the learnings are. In a recent session for a customer who had implemented SQL Server 2014 InMemory OLTP in their systems, they were getting bad performance even when they were using InMemory OLTP.
SQL SERVER – Why DBAs Need to Know about Kerberos – Notes from the Field #126
Not everyone knows about Kerberos. Many think it is a two headed dog from mythology, well that is true but when we talk about database,
SQL SERVER – FIX: Error 1807 Could not obtain exclusive lock on database ‘model’. Retry the operation later – Part 2
I have always mentioned in the blogs that the most sought out blogs would be around troubleshooting or around specific error messages. These blogs are the biggest source of page views from various search engines. I love getting these error messages and an opportunity for me to learn something new. Here is my first blog written in the year 2010 and I still get questions around the blog via emails. FIX: Error: 1807 Could not obtain exclusive lock on database ‘model’. Retry the operation later. Let us learn to fix error 1807 in this blog post.
PowerShell – Querying SQL Server From Command Line
PowerShell is quite an interesting capability that is added as part of Windows. I wonder how many of us really appreciate the power of this tool being out of the box. The more I see it being used in customer locations, the more I get intrigued by what it can do. Let us learn about Querying SQL Server From Command Line via powershell.
SQL SERVER – What is Trace Flag – An Introduction
Last week I published below blog where I talked about a trace flag. Backup Randomly Failing with Error 112 (There is not enough space on the disk.) One of the reader commented, whether he needs to enable trace flag every time SQL Server is restarted?
SQL Domain Controller – Interview Question of the Week #072
This blog is an outcome of questions asked by my client and answer provided to them after doing a lot of searches on the internet. I am very confident that sooner or later, these questions will show up in interview questions and answers. Let us understand about the SQL Domain Controller.
Q1. Can I install SQL Server on a domain controller?
Answer: This is no restriction in SQL Server setup which would block the installation of SQL Server on Domain Controller. So, yes – it can be installed.