Sqlserver-dba.com - SQL Server support and SQL Server Performance Tuning
    SQL Server DBA:Everything | DBA Scripts | Powershell Scripts | DBA checklists | SQL Antipattern | Wait Stats

May 14, 2021

How to fix the SSMS LoaderPackage package did not load correctly

A crazy error message The 'Ssms2017LoaderPackage' package did not load correctly Read more →

Posted at 08:53 AM in SQL Server Management Studio | | Comments (0)

May 11, 2021

How to register an SPN for SQL Server

A colleague asked about registering a Service Principal Name for SQL Server Read more →

Posted at 02:24 AM in Security Management | | Comments (1)

May 10, 2021

How to get disk capacity from remote server using Powershell Get-PSDrive

Using Powershell to get remote server drive details with Invoke-command & Get-PSDrive Read more →

Posted at 08:51 AM in Powershell | | Comments (0)

April 30, 2021

How does the Service Principal Name process work

Find out more about SPN and SQL Server Read more →

Posted at 05:04 AM in Security Management | | Comments (4)

April 22, 2021

How to identify the the current user on Powershell

Get the current user in Powershell Read more →

Posted at 05:19 AM in Powershell | | Comments (0)

April 20, 2021

How to configure SQL Server static port with Powershell

Use Powershell to configure SQL Server Static Port Read more →

Posted at 03:40 AM in Powershell | | Comments (0)

April 19, 2021

How to capture deadlocks using system_health Extended Events

Find SQL Server deadlock details easily with Extended Events Read more →

Posted at 02:21 AM in Deadlocks, Default Trace, extended events, SQL Error Logs | | Comments (0)

Next »