Database Recovery

4 Best Practices to Avoid A SQL Injection Attack in SQL Server

In this article we look at certain best practices that companies can implement to avoid a SQL Injection attack on production database. One of the greatest threat a SQL Server instance will always have is that of a SQL Injections. SQL Injection is rogue SQL injected in a SQL database by hackers, for multiple reasons. A SQL injection modifies the code of the databases, giving the hacker access to the database, and allowing them to make changes, however they like. This is done primarily for...

Read more »

5 Key Drawbacks of Transparent Data Encryption in SQL Server

In this article we look at five key drawbacks associated with Transparent Data Encryption in SQL Server. One of the most helpful and underused, in-built feature for data protection in SQL Sever is the Transparent Data Encryption (TDE). This feature was introduced in the 2008 edition of SQL Server and has since helped SQL users a lot by protecting their data. TDE allows for protection of data when it is at rest. Meaning you do not have to be worried anymore about any one gaining access to the...

Read more »

How to Find the Causes of SSIS Package Failure in SQL Agent

In this article, we will discuss how to get list of packages related to SSIS, connection issues in data store, key access problem in files and protection level for package, SSIS source speed and log logics. If we do not apply necessary functions in our SSIS package then console outputs or windows events logs will show small number of errors. But if we enable the logging function in SSIS then it is a completely different scenario. In general, we can work with five different places that...

Read more »