How to display active connections and running queries in SQL Server?
This query shows all queries executed at the moment, the session id, status, used cpu time and the execution duration SELECT st.text, r.session_id, r.status, r.command, r.cpu_time, r.total_elapsed_time FROM sys.dm_exec_requests r CROSS APPLY...How to connect to / read from / write to SQL Server from Powershell?
First create the connection object, set the connection string and open the connection: $objSqlConnection = New-Object System.Data.SqlClient.SqlConnection $objSqlConnection.ConnectionString = “Server=YourSqlServer; Database=YourDataBase; User Id=YourUsername;...Tape Label Studio
Why buy expensive barcode labels for backup tapes? Try Tape Label Studio for free. For more information on Tape Label Studio visit www.tapelabelstudio.com
Recent Comments