AKHIL AGARWAL

Hi, everyone. Uh, this is Akshil Agrawal, and I belongs to Barelli, and I completed my graduation in 2016. After that, from 2017, I I moved into the IT environment, and I started my career with COSI Info Systems. That was my first company situated in Hyderabad. There I there I worked as a technical support engineer. After that, uh, I I moved to Infosys where I worked as a SQL database administrator. Um, there I worked on the replications complications, 2 type of replications I worked on, snapshot replication and transactional replications. With that, uh, I worked on always on always on cluster configurations with those FCIs with the listener configurations. Uh, I help team by by building that 12 node OLTP clusters, where 8 nodes were present in Bangalore, DC, and, uh, 4 nodes were present in Mysore DC. So we did and Mysore DC clusters were d r clusters. So we have combined 12 node clusters for the OLTP configurations. And, uh, moving with that, uh, I I gain into gain experience with the performance tuning and query query writing, stored procedures, configurations. Yeah. Those are my tasks and the infosys with then I switched to Dell. Uh, there, I worked as a service delivery engineer. So my key responsibilities was to focus on the p 3 tickets where customer escalations were there and, uh, managing how to provide the better better resource for the for the systems performance students for the for the SQL Servers. And, uh, uh, III got rewarded with the with the with customer feedbacks and with Insta Awards from Dell from, uh, Intel, uh, by performing the greater, uh, great, um, supports to the clients. So those were achievements in build environment. Uh, then I switched to VMware. Until present, I'm working with VMware. There, I worked with the many like, 2 to 3 teams. I worked on VMC on AWS, then I worked with the, um, VM on multi multi cloud environment where I worked on vSphere environment, vSAN. Then I worked on data analytics side where I did perform, like, uh, analytics on the on their products, uh, vSphere products and vSAN products. Uh, there I worked on Python, and SQL was my core over there. Uh, was building the dashboards in Tableau environment, mode reports, Apache Supersets. With that, I did have migrations for the dashboards as well, um, and visualizations to the executive environments and the VPs. And with the with the Tableau dashboards, the data I used to represent to the managers with the team team and or to to to the teams as well. Yeah. Those were my things. Thank you.

Sure. Uh, for these questions, for this type of scenarios, uh, to check the query side or to check on the server side, first, we will check why query is taking a long time. Then we we are having some queries, sp_ who to command, where we check any long running queries who are there who which, like, earlier before hitting this query, before any query were excluding and replacing the entire resource of the, uh, SQL Server. Uh, with that, once if those things are not there, uh, now the things we will ask from the application team, like, whether the query was working fine earlier and from when like, the time slots from when we we observe this slowness into the application. So we will check the indexing, whether the indexing is performed on the servers or not, uh, whether their tables are presented to the indexing format. Because when we do the indexing on the servers, that is on every, uh, 2 days. That's the thing. Any backup is running on the servers. If backup is screen issue might be that is utilizing a resource. With that, we will see the whether whether the table like, recently, if someone has done a bulk upload or any bulk lead delete into the table and then after that indexing was not performed, data got fragmented. So in that case, defragmented. So in that case, we will see, uh, these are the things, like, we can check. Thank you.

Do implement this tool in PowerShell that periodically check the integrity of a SQL server database. How would you implement a system in PowerShell that periodically check the integrators? In PowerShell, we can configure, um, the server details, like server instance name, SA user and SA passwords. That will check, uh, like, in batch file, we can like, PowerShell, we can configure and it will trigger the, uh, pulse to a server where it will do a check whether data is present or not. Uh, whether survey is up or not. So those are the things we can check. Thank you.

So the strategic team validated the performance again after indexing last. So it's a strategy to validate. So this is the strategy to edit the performance gain after indexing a large table in J47. Yeah. Exactly. We can we can write a select select query, and, um, we can see how much time that that table is consuming, and we can generate a execution plan to see what's what is the performance for doing a fetch for that particular table. After that, uh, we can we can check whether the indexing, uh, has performed well and, um, whether data is correct or not, Like, uh, the time consuming in doing a fetch, uh, for that particular table is is is should be minimal minimal minimalized. Yeah. Thank you.

Detail the steps for setting up for Windows. Okay. Uh, to do a setting up our Windows server, hello, clustering or SQL server. Sure. So in this case, um, as clusters, uh, the the the count of, uh, the servers or the system should be greater than 1. Uh, so suppose we have 2, uh, servers. Uh, so we will configure, uh, active passive clusters. Okay? So there should be 1 1 shared drive between them where we will mount like, it's a mounted drive. It should be shared between both the servers. And, uh, then we will be having 2 I like, 4 IPs. 1 is, like, 2 2 IPs for the for the physical physical IPs, like, for, um, for, uh, for machines. Then 2 IPs, we want when we assign a name to a cluster name to a cluster name. So for those, we need IP. And, uh, then we will open failover cluster manager. Once we open a failover cluster manager, there is option in the side. There will be option called add cluster. Once we add our machines, then first we first we enter the machine, then it will ask active s a plus. So we we have to choose active s a 1. Then, again, other than machine, we have to enter, provide the name, IP, what we got from the, um, um, from the DCM team. Like, in our environment, we call it DCM team. So did a cluster manager team. So that IP, we have to mention. And once in the Fellow cluster we manage, then, um, the the the servers are added to a Fellow cluster manager. Yeah. Those are my answers. Thank you.

Okay. In SSIS package, there will be a logs getting deleted into if it's configured into a SQL server servers. So in that, uh, logs, you can see, uh, where which part it is failing, and, uh, then we will we can check. We can open the package in the video studio. I used to do, uh, some links. And once I open the package, then, manually, I try to execute and see where it's getting blocked. So there are some paragraphs or some parts, some components of that, um, SSH package are missing. So we can check and we can connect to application team, and we can inform them this part is missing from the SQL Server or from your query. Uh, that's why the package is getting filled. Yeah. Those are the workarounds we can do. Thank you.

How do you block a Python? Is it block of the script? Intended to connect to a security. Can you spot and explain any concerning regarding the security first? Yeah. In this query, we can see, like, username and passwords are clearly visible, and, uh, it should be like, uh, anyone can access the data once they have a password. So it should be in encrypted format, and we should not display the passwords or the usernames like that. So just we can pass the value and, uh, hide the passwords from from entering like this way.

Uh, to this query, I don't think so it will create a performance issue. Just to if it's a it's first, it's a it's a parametrized, you know, stored procedure, and, uh, we have to pass a user ID whenever we execute this stored procedure. And when ID equals to user ID because, yeah, user ID, we are passing the value, so that's why ID equals to user ID, it will be there only. I don't think so it will create any issues.

SketchUp. High availability strategy for SQL Server database that minimize downtime during updates. Uh, in this case, we can use as we talk about the high availability in this, um, according to me, like, what I worked till now, uh, so we can do it's like, uh, we can configure listener, or we can use a active active cluster or active passive clusters configurations if it's, uh, provided to the environment. And the strategy of downtime is, like, whenever we do a patch to a server or the SQL patching to SQL Servers, micro SQL Servers, in that case, we can do a failover of, uh, active active databases to the passive nodes. Once we do a passive nodes, uh, failover, then it will be a minimal downtime. Uh, it's just like a glitch, in a network, it seems like, and the the service will be available, uh, to the applications every time. And if we configure the listener configurations, uh, when we do a failover, listener will be connecting or they if the 1 of the server is down, then the listener will be, uh, always be online to our servers, which is an online state. So we can use that way also. So listener configurations, we can do. That's also part of the high availability features. Then Windows Fellow clusters in which active, passive node should be there, and we can do a failover when we go to the failover manager. And we can do a failover of a note from the active to a passive note, and, uh, the service will be active every day. So the drives from the active notes will move to the passive notes. Like, note drive will be there. It will it will get available to those notes as well. Yeah. Thank you.

What what, uh, methods? What do you employ to incorporate existing PowerShell script with the service package for advanced CDL process? Uh, sorry. I have not I have not worked on a PowerShell with the SSIS things. I'm unable to answer this.