This error has to be one of the most famous error. I have installed SQL Server quite a many times, but I keep on getting this error once in a while. This is also one of the most searched error online. I have previously blogged about this but today, I planned to create a small video on the same subject. In this video, I demonstrate how one can resolve the permissions issue with this error. Let us learn about fixing a backup error.
SQL SERVER – List the Name of the Months Between Date Ranges
Here is another interesting question, I received the other day. “How to list the name of the months between two date ranges?” Very interesting question. I had no script ready for it so I asked my friend who used to my co-worker earlier and he has sent me the script…
Read MoreSQL SERVER -Fix Error – Cannot open backup device. Operating system error 5(Access is denied.)
This has to be the most popular error in taking database backups. There are many reasons for this error and there are different ways to resolve it. I recently faced this error and for a while I was taking backup and found a very interesting solution to the problem. The error was as mentioned below:
SQL SERVER – Finding if Current Week is Odd or Even – Script
Here is an interesting question I received from my friend who is working in Bank as a DBA. “Pinal, We have a requirement in bank that every 2nd and 4th week we keep more cash in our bank where as we can keep less cash on other weeks. I want…
Read MoreSQL SERVER – Reverse String Word By Word
Earlier I wrote a blog post where I have reversed the entire string which was passed to the function. You can read that over here User Defined Functions (UDF) to Reverse String. In that blog post I wrote a function which would reverse an entire string. However, recently I read…
Read MoreSQL SERVER – FIX: Error 5161 – An Unexpected file id was Encountered
Recently I was planning to give a demo about increasing tempdb files and its performance benefit. So while making the demo at home, I was doing multi-tasking. Talking to my daughter, having food and making demo. So, I ran the script and restarted SQL Server service but SQL Service didn’t…
Read MoreSQL SERVER – The Basics of the SSIS Data Flow Task – Notes from the Field #057
[Note from Pinal]: This is a new episode of Notes from the Field series. SQL Server Integration Service (SSIS) is one of the most key essential part of the entire Business Intelligence (BI) story. It is a platform for data integration and workflow applications. As wikipedia says – It features…
Read More
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.