PowerShell & SQL Server: Search & Find Indexes By SchemaName, TableName, IndexName Or ColumnName Across Instances/DB’s

Necessity is the mother of new PowerShell code :-)! Today, I received an email request to get the list of all indexes in a given TableName but the requester did not specify the DatabaseName although the SQL InstanceName was specified. It would be too easy to ask the person for the DBName and script it … Continue reading PowerShell & SQL Server: Search & Find Indexes By SchemaName, TableName, IndexName Or ColumnName Across Instances/DB’s

SQL Server – Aliasing Tables In UPDATES For The Oracle Folks

If you transition from Oracle¬†to SQL Server, something as simple as aliasing a table in an UPDATE statement might stump you (things that SQL Server developers take for granted) Here is what I mean: Create a temporary table (#Temp) to play with: Get the structure of #Temp This is also a trick to view the … Continue reading SQL Server – Aliasing Tables In UPDATES For The Oracle Folks