This is a very interesting question. I really do not know why interviews are fascinated with this question. One of the professional services I offer is to help organizations select an ideal employee for their organization and last week, I was on a conference call with a large MNC who was looking for performance tuning expert for their organization. We interviewed around 50 different employees and offered jobs to 2 experts and 1 has so far accepted it. One of the questions which I see my friends from the interview panel asking again and again was about Primary Key. I noticed that most of the candidate got it correct.
SQL SERVER – FIX – Linked Server Error 7399 Invalid authorization specification
I have personally seen when people use Linked Server there are a number of issues from authentication to performance. These issues are part of working with something that has so many variations and permutations of actually going wrong. Many a times I suggest people to keep away from Linked Servers as much as possible. But it cannot happen all the times and there are code blocks in their application that relies on this as a requirement.
SQL Server 2016 Management Studio – Warning: SSMS install detected shared components on this machine
As soon as SQL Server 2016 Management Studio was released on 1st June 2016, I tried installing it. This is a great way to learn and I love to get going as soon as the new software gets released. I especially get excited when it is related to SQL Server. If you have not known new process to install SQL Server Management Studio, then you should read below the blog.
SQL SERVER 2016 – How to Use SQL Server 2016 – Stretch Database – Notes from the Field #127
[Notes from Pinal]: First of all, last week SQL Server 2016 released. If you have not downloaded the developer version for free. You can download from here. SQL server 2016 has many different features which are related to performance and stability. One of the feature which attracted me very much is stretch database. I am sure of the name, you might have understood that it is about extending the current features of the SQL Server. Well, the feature is very interesting, and to understand how it works, you will have to read this entire blog post.
SQL SERVER – System Objects Not Visible in SQL Server Management Studio
There are so many settings in SQL Server Management Studio that it can sometimes make someone nervous. Once of my client sent me email telling that something is not right with their SQL Server 2016 installation. Here is an email which I received:
Hi Pinal,
One of the developer has installed SQL Server 2016 on our development environment. I already had SQL Server 2014 running on the server. I am seeing a strange behavior in SQL Server Management Studio. When I connect from SSMS 2014, I am seeing system views as you can see below.
SQL SERVER – How Much Free Space I Have in My Database?
This is one of the simplest query that I wrote for one of my consulting customers who asked me. When I was discussing with the customer on some of the best practices of working with SQL Server, I was telling him not to use the autogrowth as a regular feature to use. I wanted the DBA to make sure that the autogrowth never gets called. The immediate question was – how do I know I need to increase my database files? When should I be doing them? In What maintenance cycle should this be done to find Free Space.
SQL SERVER – Vertical Select Mode feature in SQL Server Management Studio
During last SQL Bangalore user group meeting, Balmukund presented a surprise session of tips and tricks with SQL Server Management Studio. Even though I was not able to attend the event due to travel abroad, I contacted Balmukund to share what he presented.
He was kind enough to give me a list. One of the things which I didn’t know was the usage of vertical block select mode. I have been using block select mode to cut the text by selecting it. This needs a mouse and I found that there is no keyboard shortcut.