SQL Server Solutions

Azure Data Lake – Why Users of SQL Enterprise Edition Should Give It a Good Thought

In this article we look at Azure Data Lake and understand why enterprise users of SQL Server should give it a very close look. It is no more uncommon to come across not just an organization but even enterprises struggling to get sufficient storage to store big data on cloud. If you are also a part of one such enterprise and are looking for a reliable software to take care of your big data, our suggestion to you would be making use of Azure Data Lake. Although there are several other...

Read more »

Understanding the Difference between Index Scan and Index Seek in SQL Server

In this article we look at the subtle differences between an Index Scan and Index Seek mechanism in SQL Server Running a query in SQL Server is certainly something we would do on a regular basis. But what often troubles users about working with queries in SQL Server is the amount of time taken by them to give the required result. To do away with this delay, the users make use of the Query optimizer feature, but do you know how does the feature work? What is it about this feature that helps...

Read more »

Understanding the Full Recovery Model in SQL Server and Exploring Its Challenges

The Full Recovery model in SQL Server comes with its own set of challenges and benefits, here we give an overview of both. One of the greatest things about using the SQL Server is the recovery models it provides. Depending upon the kind of data you are working on and your future requirements, you can select which recovery model will be best for you. The action of backing up data and then restoring it is a part of the recovery model provided in SQL Server. As of now, SQL users have the option...

Read more »