Year archive

Posts from 2022

Blog posts

July 13, 2022 Publishing a Code of Conduct isn't enough
March 8, 2022 How do I prevent a trigger from firing for one process?

Stack Exchange answers

December 24, 2022 Stack Exchange answer: Using OPENJSON, can't get results to GROUP BY
November 18, 2022 Stack Exchange answer: SQL Modulo Function gives the wrong value?
November 8, 2022 Stack Exchange answer: Is SQL Server affected by OpenSSL 3.0 Vulnerabilities: CVE 2022-3786 and CVE 2022-3602
September 25, 2022 Stack Exchange answer: What's the use case of disabling an index?
August 25, 2022 Stack Exchange answer: What ports to open for sql server behind secure domain firewall
August 18, 2022 Stack Exchange answer: snapshot replication - corrupted BCP files
May 23, 2022 Stack Exchange answer: GRANT ADMINISTER Database Bulk Operations - Incorrect syntax near ADMINISTER
April 22, 2022 Stack Exchange answer: How do I generate the private key needed to restore the encrypted backup?
April 20, 2022 Stack Exchange answer: Temporarily turn on Cascade Delete
March 9, 2022 Stack Exchange answer: SQL Main query value used in the WHERE in the subquery
March 3, 2022 Stack Exchange answer: How to await the execution of the rds_backup_database stored procedure?
February 15, 2022 Stack Exchange answer: How to change the web browser used by SSMS when you hit Ctrl+Alt+R
February 14, 2022 Stack Exchange answer: Allow create table (dynamic name) and insert but nothing else
February 10, 2022 Stack Exchange answer: Add default rows to the query result if restrictions are not met
February 2, 2022 Stack Exchange answer: How to revoke SA permissions that seem to be "stuck" to a login?
January 13, 2022 Stack Exchange answer: CASE statement issue