Recent Blog ArticlesNewest TopicsMost LikesTagged:TagI/O optimizations for tempdb in SQL Server and Azure SQL Tempdb optimizes log flushes and disk writes in Microsoft SQL. Watch out for performance problems due to antipattern queries in SQL Both SQL Server and Azure SQL contain the query_antipattern extended event. The description for the event (from sys.dm_xe_objects) states that it “occurs when a query antipattern is present and can p...Take the SQL Server Mac challenge Modernize your data estate on SQL from cloud to edge Experience SQL innovation with consistency and rich Azure integration At this year’s Microsoft Ignite 2022 event, we talked about doing more with less and unlocking the value of your data. Leve...SQL Server Mysteries: The Case of the Not 100% RESTORE…First published on MSDN on Apr 21, 2017 I recently visited a customer onsite and presented to them topics on SQL Server 2016.SQL Server Mysteries: The Case of TDE and Permanent Tempdb EncryptionFirst published on MSDN on Jan 26, 2017 I’m a huge Sherlock Holmes fan (I’ve read all the books, watch Elementary on CBS every week, and loved the most recent season Four of Sherlock) so when I recent...SQL Server 2016 - It Just Runs Faster: Always On Availability Groups TurbochargedFirst published on MSDN on Sep 26, 2016 When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to achieve high availability, hardware environments included NUMA ma...
MicrosoftMicrosoftMicrosoftMicrosoft
