--- title: "Pradeep Prakash (@ipradeepprakash) | Hashnode" description: "DBA - SQL Server. Read the latest articles by Pradeep Prakash on Hashnode." url: "https://hashnode.com/@ipradeepprakash" --- @ipradeepprakash # Pradeep Prakash @ipradeepprakash · Joined February 2023 DBA - SQL Server ### [Topic: FCI (Failover Cluster Instance)](https://sqlserverinterview.hashnode.dev/topic-fci-failover-cluster-instance?utm_source=hashnode&utm_medium=feed) Topic: Clusters is alive, like alive 1) Can we rename named instance name in SQL server? - No /\* Note that Instance Name rename is unsupported. In named instance the server name is in format of ServerName\\InstanceName. So, you can change it to N... 1 min read · [sqlserverinterview.hashnode.dev](https://sqlserverinterview.hashnode.dev/topic-fci-failover-cluster-instance?utm_source=hashnode&utm_medium=feed) [Aug 13, 2025](https://hashnode.com/posts/topic-fci-failover-cluster-instance/689c23ae29b04993f0170737) ### [#DynamicSQL: Create customized SQL queries from a query](https://sqlstation.hashnode.dev/dynamicsql-create-customized-sql-queries-from-a-query?utm_source=hashnode&utm_medium=feed) /\* using Dynamic SQL – generate multiple customized Select query using dynamic sql \*/ select ‘select top 2 \* from ‘ + table\_name from information\_schema.tables where table\_type = ‘base table’ order by TABLE\_NAME ASC /\* using Dynamic SQL – generate ... 1 min read · [sqlstation.hashnode.dev](https://sqlstation.hashnode.dev/dynamicsql-create-customized-sql-queries-from-a-query?utm_source=hashnode&utm_medium=feed) [May 20, 2025](https://hashnode.com/posts/dynamicsql-create-customized-sql-queries-from-a-query/682c278cd4fcb7752bc861ca) ### [Powershell : Open Powershell in CMD as Administrator](https://powershellstation.hashnode.dev/powershell-open-powershell-in-cmd-as-administrator?utm_source=hashnode&utm_medium=feed) \> powershell start-process powershell -verb runas as shown below, open CMD from windows system 1 min read · [powershellstation.hashnode.dev](https://powershellstation.hashnode.dev/powershell-open-powershell-in-cmd-as-administrator?utm_source=hashnode&utm_medium=feed) [May 20, 2025](https://hashnode.com/posts/powershell-open-powershell-in-cmd-as-administrator/682c269a755afe0cda2914d5) ### [Unusual Wait types CLR\_Join in SQL Server Matters After a Windows Patch](https://sqlstation.hashnode.dev/unusual-wait-types-clrjoin-in-sql-server-matters-after-a-windows-patch?utm_source=hashnode&utm_medium=feed) A critical lesson from CLR\_JOIN waits and SQL Server performance bottlenecks 2 min read · [sqlstation.hashnode.dev](https://sqlstation.hashnode.dev/unusual-wait-types-clrjoin-in-sql-server-matters-after-a-windows-patch?utm_source=hashnode&utm_medium=feed) [May 20, 2025](https://hashnode.com/posts/unusual-wait-types-clrjoin-in-sql-server-matters-after-a-windows-patch/682c2274cdf5abb37d375d43) ### [Topic: Trace Flags](https://sqlserverinterview.hashnode.dev/topic-trace-flags?utm_source=hashnode&utm_medium=feed) 1) what is trace flag 12310 used for in AG? 2) what are trace flags used for Deadlock - 1222, 1204 3) what is the use of trace flag 1117? - forces all db files on each db to grow uniformly. 4) master db files has to be relocated to different drive. h... 1 min read · [sqlserverinterview.hashnode.dev](https://sqlserverinterview.hashnode.dev/topic-trace-flags?utm_source=hashnode&utm_medium=feed) [Jul 1, 2024](https://hashnode.com/posts/topic-trace-flags/689c24ea6ff1b04ce768e31d)