Category Archives: security

security

Top 2014 News of Database – the fall of Microsoft Azure SQL Prices

Microsoft has not ceased in its bid to attract more and more enterprise customers onto their Azure cloud computing system, with all their databases in tow of course. This came shortly after the company disclosed to the public a preview of Azure’s enhanced security auditing feature. With the fall, the company announced its intention to change its cloud-based computing and database offering to make it more affordable. Continue reading Top 2014 News of Database – the fall of Microsoft Azure SQL Prices

How to encrypt SQL server backups

database encryption SQLBackupAndFTP
 
Make sure to encrypt SQL Server backups in order to add another level of security to your data. 
Adding this option to your backups is extremely easy with the help of the Encryption option in SQLBackupAndFTP.
 Read the short tutorial in this article below to encrypt your backups. 
Continue reading How to encrypt SQL server backups

[DBMS-MSSQL:11006#916] The server principal “NT AUTHORITY\SYSTEM” is not able to access the database under the current security context

If you encounter the error message:

[DBMS-MSSQL:11006#916] The server principal "NT AUTHORITY\SYSTEM" is not able to access the database <database-name> under the current security context

you will find the solution below:

Go to the “SQL Server” sections and click on the gear button. At the opened “Connect to Server” window you need to select “Microsoft SQ: Server (local) as your Server type, choose “Windows Authentication” and enter User Name and Password. Press “Test Connection” to make sure that you have specified the correct data and then click on “Save & Close” to save and apply new settings. Continue reading [DBMS-MSSQL:11006#916] The server principal “NT AUTHORITY\SYSTEM” is not able to access the database under the current security context

Why choose SQL Server Express?

Sql Server ExpressWhen you choose Microsoft SQL Server Express, you’re opting for the most practical way to go when it comes to getting database software that is versatile and effective. The best advantage to the SQL Server Express is the fact that it’s free. No matter what web application framework you prefer, this edition gets the job done. You’ll also find that it’s streamlined to function with your top picks in applications as well. This is a database that can grow with you, sufficient to meet all of your needs. You’ll also find that its capacity for expansions is more than you would expect. In a time when you need to be savvy and watch your budget, SQL Server Express Edition is the answer you’ve been looking for all along. Continue reading Why choose SQL Server Express?