SqlServer-QA.net

Here is the monthly security update that I receive from Microsoft that I would like to share, this is more important to put this into practice to secure your Server environment.  This security update resolves a privately reported vulnerability in the Server service. The vulnerability could allow remote code execution if ...

When the SQL Server is faced to the internet then you have to take utmost care to ensure that the each row in the table is not compromised to avoid any unprecedented activity. As it is getting popular that rise in SQL injection attacks has reminded the best practices and rules to secure the database & web environment to avoid any escalation ...

While I was scrolling through the logins for a permission task, I found the login name such as  ##MS_PolicyEventProcessingLogin## & ##MS_PolicySigningCertificate##, I was bit confused and perplexed to see what it is for? As usual searching in Books Online (2008) and on web doesn't get much information on this login properties, also this ...

Do not click any of the links below:  Here is the piece of advice I would like to share that do not fall for tricks played by SPAMMERS and phishing email you see below: *************************************************************************     Alert Name: My Custom AlertObama has big speech plans in ...

When it comes to the data encryption within SQL Server 2008 you would think about Transparent data encryption (TDE) which is a new encryption feature.   It sounds good that this is a high level security feature you can deploy to secure the data, and a catch is you can do it without affecting existing applications. Traditional ...

Ok this is not new to say you can write stored procedures in any language to manage them in SQL Server, as 2005 version has started this CLR integration functionality that is exposed in an assembly called system.data.dll, which is part of the .NET Framework. So think about code access security in addition to managing security privileges for the ...

As it seems the error text on the subject looks familiar when you have installed SQL Server or working with SQL Server databases. How about getting the error on Analysis Services databases (OLAP) within your BI Platform. So in the case of handling the Business Intelligence platform you must be aware of necessary data providers that are ...

I believe it has been a while that we have seen the security hotfix from Microsoft Security team on SQL Server (alone). The latest security bulletin has announced important security patches that are related to SQL Server in addition to Windows operating system. They quote that ''...With the release of the bulletins for July 2008, this bulletin ...

One of the biggest threats in IT industry & Database world is unprecedented attacks aka most commonly termed as 'SQL injection'. There is no doubt that biggest database vendors, one of them as Microsoft so far providing recommendations regarding security-related configuration settings since the good & bad times of SQL Server version 2000, ...

Granting permissions to relevant account is a required criteria within the SQL Server databases management, for this even Reporting Services is not exceptional. As per the configuration by default the users connect to the report server by using their own Windows domain credentials and integrated security. TO change this criteria you can also ...