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 ...

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 ...

Adding password complexity and password expiration to SQL Server logins is one of best feature I quote for SQL Server version 2005 onwards, similarly such password complexity policies are designed to deter brute force attacks by increasing the number of possible passwords. When password complexity policy is enforced and password expiration ...

Security - a major ingredient for every Enterprise to avoid the adversaries attempt to invade your customers’ networks and access their servers—to bring them down, infect them with viruses, or steal information about customers or employees, every day! The recent release of Windows Server 2008 from  Microsoft will help them address these ...

Do you want to lockdown your SQL Server environment? Hope you dont'! Though it is not a good practice or recommendation to perform, but will atleast prove how far your SQL Server environment has securit compliance as per the industry best practices. Before we go to know how you can lockdown or know the steps, I would like to visit few leads on ...

I have no doubt in stating that Virtualization has become hot topic in the industry now a days, that is leading to consolidate your Database platform using available technologies. The main interest in getting this up is that virtualization can lower overall IT costs which is the priority for any Enterprise, but at the same time one ...

Replication plays important role within the data-driven events in an Enterprise, vital to the sales-work force type of management. DBAs will always havea primary focus in providing protection for the data assets stored in SQL Server. Protection that covers the security and data recoverability is also equally important, during this process ...

See this awesome post about how best you can adopt security and beaware about which is right and which is wrong Avoiding the bad guys - detecting potentially malicious advertising campaigns that is applicable on both personal security & techinical security for your systems.  

When you have problems with SQL Server replication where the transactional replication is common case in setting up, eventually you will have problems when the data is growing up and any sudden changes in the ETL will also have affect on replication process. In this case I would suggest in referring to links ...

How do you define the terms ''Performance Monitoring''? What is your baseline & benchmarks? Have you ever used PERFMON (SYSMON) & PROFILER for serious performance issues within your SQL Server environment? The answer may be not 'yes' for all the questions above, in general getting know more about performance monitoring methods is not ...