A month or so ago we started seeing crashes on the SQL Server associated with one of our dogfood TFS servers. The crashes ultimately resulted in us having to restore the database from backup. It was a significant work disturbance and an important thing to avoid. We diagnosed the problem in...
SQL Server 2016 on the wayWe are pretty excited with the new features coming out SQL 2016. With SQL 2014, I helped a lot of...Date: 06/08/2016Want to work at Microsoft?"je ne sais quoi"...do you have it? Check out this cool webcast if you are interested in learning......
Last commit date Latest commit ezraodio1 and Ezra Odio Default to not allow HTML content in tables (#7064) Jan 15, 2025 10ce280·Jan 15, 2025 History 7,843 Commits .ci Revert build (2 of 2) (#6967) May 14, 2024 .github
I created a PPKG and Configuration file for Hub2S, but the configuration file is not loaded when applied in the OOBE phase. I checked this file and found...
date, time, datetime2, and datetimeoffset Allow change Allow change* Block change *SQL Server Compact Subscribers convert these data types at the Subscriber. If an error occurs when applying a schema change (such as an error resulting from adding a foreign key that references a table not availa...
Here's an example of what I was referring to in my last post, a working example that discounts the first $100 by 10%, anything above that by 30%. But you can change the table that contains those values and see the effect immediately. No need to rewrite the...
Describes the problem that occurs when you open or make a reference to a linked table in Access. You may receive the Couldn't find input table or query 'name' error message.
The first approach is to ensure all your libraries target net7.0+ (preferably net8.0 because it has the most up-to-date annotations on the System.* APIs). Then you can use #if directives around your attribute usages. When your library builds for earlier TFMs (like netstandard2.0) the attr...
Adds various outputs that contain "tick count" and/or "date and time" to make debugging an issue easier. Adds the outputs of fsutil and volume information to the error file, in order to map the file offset to the offset on the physical disk and filter the I/O subsystem trac...
59 sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21.