SQL Server Solutions

7 Key Things to Keep in Mind when Backing Up Your SQL Server Data

In this article, we will address things that will serve as important pointers don’t want to forget while backing up your SQL server. Backup is like a disaster plan, which shields the organization from any miscellaneous calamities. However, it is important that the user is able to come up with an effective disaster plan and is also able to implement it properly. System administration strategy is one of the most important priorities for all businesses, as it protects the organization...

Read more »

How to Insert Bulk Data in SQL Azure Databases with PowerShell

This article explains the process of bulk transfer to Azure Blob with little reference to T-SQL. When working with SQL Server databases, one of the most common problems we face is the insufficient space for storing data. Although SQL users are given the option of using the Azure cloud to store data, that also proves to be insufficient when working with Big Data. So, one of the common solution many SQL users opt for, involves making use of Azure Blob storage for storing SQL Server databases....

Read more »

How to Create Basic Index for your Stack Overflow Public Database

In this article we learn about the basic differences in clustered and nonclustered indexes, and how and why you should use nonclustered, basic indexes for stack overflow public databases Stack Overflow Public databases are those which have clustered indexes for all tables. It does not allow for nonclustered or full text databases, and does not even allow the user to store data from any stack site except Stackocerflow.com. One of the main reasons why you should have indexes in your database...

Read more »