Here's a few of the new posts today on the forums. To see more, visit the forums.
|
| SQL Server 2019 - Administration |
| i noticed the sqlhealth extende event is on by default , so can i reduce - hi, i noticed the sqlhealth extended event is on by default , and it logs many thing, Q1) can i reduce few thing so that file size and recording that is wirting from buffer to file can be reduced, thus i will save some resources. q2) and can i add few events which are required […] |
| SQL Server 2019 - Development |
| data type gets lost in data flow - Hi, in a simple oledb source->derived column->oledb destination data flow, 2 of my date columns that are converted to varchar, format 101, in the source view, ultimately seem to end up as unicode in the oledb destination. And that seems to bring down the pkg. everywhere else they are dt_str length of 30 . […] |
| is there a no code way to limit an ssis extract from excel to the 1st 21 rows? - is there a no code way to limit an ssis extract from excel to the 1st 21 rows of the sheet? for now anything past that is just noise in what im doing. |
| SQL Azure - Administration |
| New-AzSqlInstanceServerTrustCertificate - Failed and no clues - Using New-AzSqlInstanceServerTrustCertificate to import a certificate and get the message New-AzSqlInstanceServerTrustCertificate: Long running operation failed with status 'Failed'. Additional Info:'An unexpected error occured while processing the request. Tracking ID: 'd21c42cd-515c-40b4-b8b6-60b851c66a39' I've confirmed that the parameters are correct and most articles I've looked at suggest just waiting and trying again. Needless to say, that hasn't worked. […] |
| Editorials |
| The Challenge of AI - Comments posted to this topic are about the item The Challenge of AI, which is is not currently available on the site. |
| The AI Bubble and the Weak Foundation Beam - Comments posted to this topic are about the item The AI Bubble and the Weak Foundation Beam |
| Refactoring SQL Code - Comments posted to this topic are about the item Refactoring SQL Code, which is is not currently available on the site. |
| Article Discussions by Author |
| Stairway to Azure SQL Hyperscale Level 6: Backup and Restore Internals - Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale Level 6: Backup and Restore Internals |
| Deprecated Feature Tracking - Comments posted to this topic are about the item Deprecated Feature Tracking |
| Think LSNs Are Unique? Think Again - Preventing Data Loss in CDC ETL - Comments posted to this topic are about the item Think LSNs Are Unique? Think Again - Preventing Data Loss in CDC ETL |
| A Big PK - Comments posted to this topic are about the item A Big PK |
| The Read Committed Snapshot Isolation behaviour - Comments posted to this topic are about the item The Read Committed Snapshot Isolation behaviour |
| Working with JSON/JSONB Data in PostgreSQL using Python - Comments posted to this topic are about the item Working with JSON/JSONB Data in PostgreSQL using Python |
| SQL Server 2022 - Administration |
| Deadlock graph anomaly - I've come across what appears to be a strange deadlock anomaly. As seen in the attached image/XML, a typical deadlock is shown (bottom), but then a completely isolated process graph is also shown (top). The top section has appeared in multiple deadlocks on different unrelated databases/app processes. It doesn't appear to be involved in the […] |
| Change Tracking – Troubleshooting - I have change tracking configured in several databases, in QA and production environments, and we have config in place to feed from these databases to data warehouse databases. It works well, but ... In a QA environment, we have been receiving the following sev-16 alert for a few days: Change tracking autocleanup is currently not […] |
B: 
C: 
