Why transaction log may get full during full backups even if database is in SIMPLE recovery model?

https://am2.co/2017/04/transaction-log-growth-backup/

https://www.sqlskills.com/blogs/paul/debunking-a-couple-of-myths-around-full-database-backups/

https://www.sqlskills.com/blogs/paul/more-on-how-much-transaction-log-a-full-backup-includes/

 

Advertisements

Implementing SSL encryption for SQL Server in a DNS forwarding environment (CNAMEs)

If CNAMEs or aliases are being used to connect to SQL Server and SSL Certificate is enabled, applications may face connectivity issues.

[System.Data.SqlClient.SqlException]         
{"A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate's CN name does not match the passed value.)"}        

https://blogs.msdn.microsoft.com/sqlserverfaq/2011/08/08/implementing-ssl-encryption-for-sql-server-in-a-dns-forwarding-environment/

In such a scenario, the certificate should have the “SUBJECT ALTERNATIVE NAME” field enabled, and this should contain the actual name or FQDN of the SQL Server as well as all the aliases.

T-SQL User Defined Functions and Performance considerations

 

Source: From session T-SQL User-Defined Functions, or: How to Kill Performance in One Easy Step with Hugo Kornelis GroupBy

Extended events, trace may cause (>10x) negative effect on performance of UDFs

If you notice unexpected degradation in performance of queries calling UDFs, please stop any active extended events sessions, traces that capture query plan information (sqlserver.sp_statement_completed) on SQL Server and verify.

Measuring Performance Can Slow SQL Server Down

http://www.scarydba.com/2014/12/19/pretty-plans-vs-performance/