Database Recovery

Understanding the concept of Table Partitioning in SQL Server

In this article we look at the concept of table portioning as implemented in Ms SQL Server Partitioning in SQL Server involves partitioning tables and indexes and storing them in multiple physical sections. This feature is available in the Enterprise edition of SQL Server, if you wish to use it for production. It is also available in the developer edition for trial. Partitioning is a complex feature of SQL Server, and allows splitting an index into multiple small indexes. Every partition has...

Read more »

Generating secure passwords that are easy to remember in SQL Server

In this article we look at ways to generate secure and easy to recall passwords in SQL Server Almost all of the important information worldwide is often secured using passwords, pin codes or scanners (finger print scans / facial scans). In case of scanning, there is nothing the user needs to remember, for pin, there are only numbers, but in case of passwords, it is always a difficult combination. A lot of people have problems remembering their passwords, for this reason they end up using...

Read more »

A quick lowdown on enhancements rolled out in SQL Server Management Studio 2016

In this article we look at key enhancements that have been incorporated in SQL Server Management Studio 2016 The SQL Server Management studio is one of the multiple applications launched with SQL Server. It was first launched in the 2005 edition of SQL Server, and from 2015 onwards Microsoft decided to ship SQL Server Management Studio separate from the SQL Server. The SQL Server Management Studio was designed with the purpose of negotiating, configuring and handling the SQL Server and its...

Read more »