PPPradeep Prakashinsqlserverinterview.hashnode.dev·Aug 13, 2025 · 1 min readTopic: FCI (Failover Cluster Instance)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...00
PPPradeep Prakashinsqlstation.hashnode.dev·May 20, 2025 · 1 min read#DynamicSQL: Create customized SQL queries from a query/* 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 ...00
PPPradeep Prakashinpowershellstation.hashnode.dev·May 20, 2025 · 1 min readPowershell : Open Powershell in CMD as Administrator> powershell start-process powershell -verb runas as shown below, open CMD from windows system00
PPPradeep Prakashinpowershellstation.hashnode.dev·May 20, 2025 · 1 min readPowershell – Execute a local script on Remote ServerBelow is the command to execute the script on remote servers Reference: https://theitbros.com/run-powershell-script-on-remote-computer/ -- if script is in local drive Invoke-Command -FilePath c:\ps\tune.ps1 -ComputerName server1,server2,server3 -- i...00
PPPradeep Prakashinsqlstation.hashnode.dev·May 20, 2025 · 2 min readUnusual Wait types CLR_Join in SQL Server Matters After a Windows PatchIntroduction SQL Server is a robust platform, but even the strongest systems can falter when foundational components change—like the operating system. Recently, after applying a Windows Server 2016 Enterprise edition patch, we encountered a sudden an...00
