At this rate, I think I am going to exhaust the whole error set available in SQL Server. I am glad that I am able to get into unique situations and then resolve them too. And this is more of a diary of the error messages I am getting into. I was playing with my Demo database on SQL Server 2016. Once done, I started restoring from the previous copy. But is failing with below error 3169:
SQL SERVER – SSMA Error : System.Data.OracleClient requires Oracle client software version 8.1.7 or greater
I said I have no clue as to why this is happening and I asked if it was in any way related to SQL Server? Let us fix SSMA Error.
It’s a New Year, Take Advantage of It – Notes from the Field #110
[Note from Pinal]: This is the first episode of Notes from the Field series in the year 2016 and 110th overall. There is one place where I see the maximum crowd in the new year – fitness center (gym). It is indeed a good thing that we all want to…
Read MoreSQL SERVER – Monitoring and Troubleshooting SQL Server Got Easy with Diagnostics Tool
Blogging has never been an easy task. With close to 9 years of non-stop learning and sharing has got me into a rhythm that I rarely miss a single day without writing one. Over these years, there is one topic area that gets most number of hits based on subject.…
Read MoreSQL SERVER – FIX: sp_rename error Msg 15225 – No item by the name of ‘%s’ could be found in the current database
Few days back I have written blog containing script for removing space in column name using sp_rename. In case you missed, I am listing them below for quick reference. SQL SERVER – Script: Remove Spaces in Column Name in All Tables SQL SERVER – How to Rename a Column Name…
Read MoreSQL SERVER – Someone was trying to hack my SQL Server Logins in Azure!
When I started to work with SQL Server on Azure VMs, I was completely excited because now the need to build local VMs has become super easy. If I need something for testing, then I know I can get a SQL Server instance in a jiffy and it can be…
Read MoreInterview Question of the Week #052 – Print String in Reverse Order
Last week, I attended the last interview of the year. One of my co-interviewer asked a coding question to the candidate. In this type of question, the candidate is given one hour with SQL Server with a help file. The computer does not have internet candidate can use all the…
Read More