Database Recovery

4 Salient Aspects that One Must Keep in Mind while Protecting SQL Server Assets

SQL Server assets including the data contained in them needs to be protected. In this article we give a close look at how these can be achieved.  Our assets are supposed to be people, objects or information that gives us an advantage over the others. Anything that is exclusive and forms a source of strength becomes one’s asset. SQL Server is used for storing databases that are already full of sensitive data, and there are parts of data that are more sensitive than the rest. Any...

Read more »

6 Categories of Spatial Data Types Supported by SQL Server

In this article we give a close look at spatial data types supported by SQL Server and the differences between them. Apart from storing data in the form of databases, for commercial enterprises, SQL Server also supports spatial data, and can be used by organizations dealing with spatial data. Spatial Data mainly includes data related to space, in SQL Server, two different types of spatial data are supported – Geometry and Geography. Geometry mainly includes data about flat – Earth (it...

Read more »

Why is It Extremely Important to Enforce Stringent Security Measures in a SQL Server Deployment?

Using a case study where an organization had to suffer the consequences of lax security measures, we try to understand why it is critical to enforce strict security measures in any enterprise SQL deployment. The most preferred enterprise level relational database management system – SQL Server, is also supposed to be one of the most protected and well maintained software. No company fills a SQL Server database with data that is not important; being an expensive product that it is, SQL is...

Read more »