We are all hard wired when it comes to doing certain tasks. I have attended tons of sessions at the local SQL Server user group meets and it amazes me every time to what I didn’t know about the tools that I use often. Every time when I attend sessions from my friend Balmukund or others from the community – they show a trick or two using SQL Server Management Studio that makes me rethink how I would be working the very next day using these methods. I think it is part of learning and that is never going to stop. Let us see about tips about Windows 10.
SQL SERVER – Configuring Startup Options for SQL Server Management Studio
Yesterday I started my day early to get to a gym. I know this was the first day and I had loads of work pending to be completed at work too. This got me busy and I started to drive my car, oblivious of the fact that I had to take a turn which I missed. Just while crossing the junction I realized I had missed it. It was a bad start to the day as I wasted 5 minutes to retrace back to the original route. On second thought, this mistake from my side got me thinking. My mind was tuned to specific routes and this is the same thought process that got me the inspiration to write this post. Let us learn how to configure startup options.
SQL SERVER – FIX Error 5120 – Database is in Read Only Mode After Attaching Files
Sometimes you need to know more about permissions on file, service account etc. to fix certain errors. In my recent visit to a customer location, one of the database developers came to me with a problem. He said that when he attaches MDF and LDF file to the SQL instance, attach is successful, but the issue was next to database name it was saying read-only. Let us see how we can FIX Error 5120.
PowerShell – Script to Listing all Backups Taken with SQL Server
I always like to keep a number of scripts handy in my USB drive with my Laptop. These scripts are used for my internal use when I am suddenly looking for something interesting in customer environments. One of the scripts that I use is shown below. Many a times I have seen customers don’t really have any backup strategy. And when I start working with them, I call out some of the basic backup techniques that they need to be doing.
SQL SERVER – How to Avoid Triggers for Multiple Row Operations in a Table
Customers have a unique way to give you challenges that you never faced. It was one of those evenings that I was working late night on some SQL activity when I received a mail from one of my very old customers. It is rare that I get a ping from them and I was surprised at what had gone wrong. As I started to chat with them, he didn’t know I had recently moved to consulting. This got him double excited and I was unaware to why such a reaction. Your best customers are your best well-wishers too. Let us read about How to Avoid Triggers for Multiple Row Operations in a Table.
SQL SERVER Management Studio – Why I am Seeing White Icon Instead of Green or Red?
One of my clients faced a strange situation. She was using SQL Server Management Studio and was not seeing SQL server and SQL Agent status. It was showing white circle. When she would right click the instance, the options of Start, Stop and Resume were disabled. She also said that she is having SysAdmin permissions in SQL Server (logging using the SA account).
SQL Server – Understanding Connection Timeouts and Query Timeouts
Have you ever got into a situation wherein you feel you see something and work for a solution in a completely opposite direction? Recently I was out of the country for a session and at the breakfast table I found a dark red bottle of ketchup which I used for my sandwich. Lesser did I know it was actually a spicy sauce. And on closer look this time, I found the mistake I did and how I ruined my whole breakfast. These are times when you oversee something which looks like one and you land up as something completely different. This blog post we will be Understanding Connection Timeouts and Query Timeouts.