Database Recovery

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 »

8 Main Improvements and Enhancements of the Database Engine in SQL Server 2017

The SQL Server 2017 edition is out, with several improvements and updates; this article explains the Database Engine and its features for this edition. MS SQL Server had already been providing users with features that were quite fulfilling for its potential. Up until now the application was not only allowing users to store data in a secure and easy to retrieve manner, but also for easy transfers, cloud storage, and a lot more. With the coming of SQL Server 2017, its potential and...

Read more »