It was my pleasure and honor that I was invited to the Brent Ozar Unlimited Office Hours. During the office hours, we received quite a few interesting questions, some were very complicated and some were super fun. However, the best part of attending the office hours was the company. I was fortunate to have Brent, Richie, and Tara along with me in this office hours. Please note that the questions which we discussed during the session were asked live.
SQL SERVER – Steps to Migrate Cluster Storage from Old Disks to Newly Attached Disks
One of my clients consulted me for the best and easy method for migrating the Cluster Storage from old to newly attached disks. They wanted to move/reconfigure disks mapped to SQL Server, MSDTC, Quorum.
At present, they were using SQL Server 2014 as a mission-critical database server in a cluster environment. Storage being used was IBM DS 8300. They want to migrate the database from current storage i.e. IBM DS 8300 to new storage IBM DS 8870.
SQL SERVER – FIX: Error: 5511 – FILESTREAM’s file system log record under log folder is corrupted
SQL SERVER – FIX: Error: 5511 – FILESTREAM’s file system log record under log folder is corrupted. Let us fix the error in this blog.
What is SQL Server Launchpad Service? – Interview Question of the Week #168
Question: What is SQL Server Launchpad Service?
SQL SERVER – Identifying Deprecated SQL Server Features with Extended Events
In this blog post with the help of Extended Events, we will learn how to identify all the deprecated SQL Server Features. This feature can be very much handy when we are changing the compatibility of SQL Server and we want to check what are all the deprecated SQL Server features we are still using in our active code.
SQL SERVER – FIX: Arithmetic Overflow Error in Object Execution Statistics Report in Management Studio
Many times, there are unforeseen conditions and few developers can’t predict which writing the code of a product. This is the reason we have bugs in the products and we all have job to do. One of my clients was not able to run one of the inbuilt reports which come with SQL Server Management Studio. The report name was Object Execution Statistics. As per them, this report was running fine until last week and it had suddenly stopped working. They wanted some idea this as it was not a show stopper for them. When they launch the report, they see below error
The Evolution of the DBA – Challenges, Changes and Upcoming Trends
What scares the DBA most besides the Text at midnight with word downtime? Well, the answer to this question is pretty simple – The changing work profile for DBA. I am fortunate that during my job as a Data Consultant, I get to visit different organizations across the world and get to meet some finest Data Professionals and Business Leaders. I get the first-hand experience of the evolution of the DBAs in the constant changing and challenging world. It is extremely important for DBAs to get updated with the current trends to stay relevant to their job. Let us see today a quick story of Evolution of the DBA!