When you want to be successful, you need to run alone and fast. But if you want to run longer, you want to run together. I have personally seen multiple instances where this statement holds true to every word. When working with customers and in various consulting engagements, I have seen it is not enough to just solve the problem. It is important to enable the team working on the project and make them aware of the reasons why it did happen in the first place. I always felt the art of working together will take us a long way. Even in performance engagements, I try to get the team involved as I go through the process of solving their problems. Let us learn in this blog post DBCC Command Enhancement with MAXDOP.
SQL SERVER – FIX: Incorrect Syntax Near the Keyword ‘PROCEDURE’
Along with freelancing, consulting, I also spend time in replying to my blog comments to learn something new. Few such conversations end up in business deals, few in emails and few in the blog. This blog originates from one of such conversation regarding incorrect syntax.
SQL SERVER – How to Get List of SQL Server Instances Installed on a Machine?
There are multiple ways by which we can find a list of SQL Server instances name instances on a machine. In this blog, I would show a few ways to do it.
Personal Technology – Expanding to Open Folder Working with Windows 10
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.