SQL Server Database Recovery

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 »

Learn About the Python Support in SQL Server and Machine Learning Services

In this article we look at the apt support for Python in the 2017 edition of SQL Server The R Services in SQL Server are now known as SQL Server Machine Learning Services; this service now allows you to make use of not just R language, but also Python. The Machine Learning Services feature in databases allows you to run scripts written in Python or R, when using SQL Server. However, if you do not have access to this service, you can also opt for downloading and installing the MS Machine...

Read more »