Posts Categorized: Case of the Week

dbatools Command Failing:  “The Parameter is Incorrect”

SQL Server case study of the week

This week’s case of the week post comes from Jack Corbett. Quick Summary  When attempting to use Copy-DBACredential in dbatools, I received the error “The parameter is incorrect,” yet other commands connecting to the same servers worked.  Context  I was working with a client to do an upgrade/migration from SQL Server 2016 to SQL Server … Read more

Curious Case of SQL Server Shutting Down Whenever a Job Runs.

SQL Server case study of the week

This is a post in our new Case of the Week series — short write-ups from the real SQL Server issues our team of 17 SQL Server experts helps clients solve every day. Case of the Week: Quick Summary A client reported that their SQL Server service was “randomly shutting down”. They would restart SQL … Read more

SQL Server Partition Management Job Failure After Migration to Availability Group.

SQL Server case study of the week

This is the first post in our new Case of the Week series — short write-ups from the real SQL Server issues our team of 17 SQL Server experts helps clients solve every day. Case of the Week: SQL Server Partition Job Failure after Migration from AWS FCI to AWS AG. Quick Summary A client … Read more