(Itzik Ben-Gan) You’ve probably heard many times before that SQL Server provides a guarantee for ACID transaction properties. This article focuses on the D part, which of course stands for durability.
Tag: sql server
Azure SQL Database – Who Changed My Auto Tuning Settings?
(blobeater) One of the features Microsoft wants us to use for Azure SQL Database is Automatic Tuning. Automatic Tuning is a feature where you can think of it as entering the world of self-running and self-tuning databases.
Parallel Virtual File Systems on Microsoft Azure – Part 4: BeeGFS on Azure
(Kanchan Mehrotra, Tony Wu, and Rakesh Patil) BeeGFS is a Linux-based, hardware-independent parallel file system and designed for high-performance and high-throughput environments at Fraunhofer ITWM. (Its original name was FhGFS.) BeeGFS is free to use and offers commercial support.
Add new article to existing publication for SQL Server Transactional Replication
(Nisarg Upadhyay) SQL Server Replication is a great tool to transfer data between different instances of SQL Server as well as other non-SQL Server databases.
SQL SERVER – Finding Compression Ratio of Backup
(Pinal Dave) During the recent Comprehensive Database Performance Health Check, I was asked if there is any way to know compression ration of backup if we enable compressed backup settings in SQL Server.
How do I look at my error log if SQL won’t open?
(Kenneth Fisher) Quick and easy post today. Hopefully you’ve opened the error log on a SQL instance. However, what happens if you don’t have the log viewer in SSMS? In fact, the instance won’t come up at all so you really need to see what went wrong.
Microsoft Azure SQL Database nears parity with SQL Server
(Craig Stedman) Microsoft is adding functionality to Azure SQL Database to enable users to migrate more SQL Server applications to the cloud platform and run bigger databases on it.
Premium blob storage
(James Serra) As a follow-up to my blog Azure Archive Blob Storage, Microsoft has released another storage tier called Azure Premium Blob Storage (announcement). It is in private preview in US East 2, US Central and US West regions
SQL SERVER – Always On Availability Groups and Full-Text Index
(Pinal Dave) One of the most successful offerings from me has been Comprehensive Database Performance Health Check. Sometimes during my assistance, some random issues appear which I try to solve as well.
SQL Server 2019 – New DMF sys.dm_db_page_info
(Rajendra Gupta) Microsoft released preview of SQL Server 2019 recently in Ignite 2018. With every release of SQL Server is enriched with new dynamic management view and functions along with enhancements to existing features.