January 2014 – SQLMint

Powershell – Query server hotfix

Below powershell command will query one or more servers for a specific hotfix as in the example.

cls
get-hotfix -id KB2883201 -computername server1, server2

Below query will list the database file locations on a sql server instance.

USE master

SELECT name AS [Logical Name], physical_name AS [DB File Path], type_desc AS [File Type], state_desc AS [State]

FROM sys.master_files

Click here to download as a PDF or XLS file, the new SQL Server 2012 System Views Map.