Kevin Weinrich

Invoke-SqlQuery returns only records that have a unique key

3

The following set of SELECT queries should each return 77 rows since there is no WHERE clause in any of the queries. Yet you can see that I get a...

Is there a way to freeze top rows and/or column after a bunch of Set-ExcelRange calls?

1

Pardon me if my code style is backwards from Doug's examples. In my work, I create a custom spreadsheet from various data. After all that formatting, I would like to...

Open-SQLConnection in 2.x (without TrustServerCertificate=true;) fails: "The certificate chain was issued by an authority that is not trusted" - 1.9.x always works

4

When I connect to our SQL Server via SimplySQL 1.9.0 or 1.9.1, it works fine, regardless of my connection string. When I run the exact same script but specify the...