SQL recovery

How On-demand Analytics Service Works with Azure Data Lake

This article addresses how on-demand analytics service works with Azure Data Lake. Azure Data Lake is an analytics service, which aims at easing big data analytics into a simpler avatar. This allows organizations to focus on managing, running and writing jobs instead of operating on a distributed infrastructure. Users use queries to extract valuable insights …

How On-demand Analytics Service Works with Azure Data Lake Read More »

In-depth Study on Compressed Backups in SQL Server and Its Storage Needs

In this article we learn about compressed backups in SQL Server and compare them with Trace Flag In SQL Server 2008 and all its later editions, users are given access to what is called the compressed backup. Meaning once you backup your database you can also compress it to reduce the amount of space it …

In-depth Study on Compressed Backups in SQL Server and Its Storage Needs Read More »

How to Copy the Schemas & Statistics of Multiple Databases without Data via TSQL

With the service pack 2 of SQL Server 2014, you can create a copy of a user database without the actual data. i.e., you would be creating just the schema and statistics of your source database. In this article, we will learn how to quickly create clone of multiple user databases A copy needed for …

How to Copy the Schemas & Statistics of Multiple Databases without Data via TSQL Read More »

error

Enjoy this blog? Please spread the word :)

LinkedIn
Share
RSS