Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.
SQL Server Management Studio (SSMS) is one of the most used tool by SQL Server DBAs around the world. Here are a few lesser-known features.
SQL Server 2016 is shipped with significant enhancements to Microsoft’s reporting generating toolkit — SQL Server Reporting Services (SSRS).
The new enhancement available in SQL Server 2016 availability group is called as direct seeing or automatic seeding. Learn more about it here.
Instant File Initialization surfaced in SQL Server 2005. I will show you how to enable this feature and show how it drastically improves performance.
Every 5 years we see technology innovations that rock the industry and I am amazed to see how we seem to have to make a fresh start every other year.
If we ask any DBA about the types of indexes in SQL Server, most likely they would answer – clustered index and non-clustered index.
One of the major myths about SQL Server In-Memory OLTP is that since the data resides in memory, it would be lost once SQL Server is restarted.