Browse by Tags

SQL Injection attacks - don't forget to visit guidance information from Microsoft

Published 31 May 8 3:59 PM | SSQA.net

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

Filed under: sql server, blogs, security, best practice, injection, authentication, attacks, reference

EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.

Published 27 May 8 3:48 AM | SSQA.net

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

Filed under: sql server, databases, security, permissions, sqlagent, reporting services, reportserver, reportservertempdb, rsexecrole

SQL Server 2005 Connectivity, Security policies & Network protocols: simple practice to follow, after installation?

Published 23 May 8 3:44 AM | SSQA.net

Secured by default, secured by design is the buzzword and catchy stuff for any Enterprise IT administrators. Then it comes about standards and policies to follow such as ISO , with the recent threats (last 10 years) and vulnerabilities within IT world...

Filed under: sql server, blocking, security, best practices, hotfix, service pack, cumulative update

SQL Consolidation: Insights from Customers, Analysts & HP

Published 20 May 8 2:46 PM | SSQA.net

Featured Web Seminar: SQL Consolidation: Insights from Customers, Analysts & HP On-Demand Combat SQL Server Sprawl - Inside Experiences & Best Practices Microsoft SQL Server has enjoyed phenomenal success as a database server. Its relatively low...

Filed under: business continuity, sql server, security, seminar, consolidation

SQL Server 2005 detect DAC session with TSQL

Published 9 May 8 1:11 PM | SSQA.net

SQL Server 2005 has introduce a secret-door for Admins to identify and resolve any connect lockout issues within your database instance, as on http://sqlserver-qa.net/blogs/tools/archive/2007/08/04/dedicated-administrator-console-dac-saved-an-important...

Filed under: sql server, security, dmv, tsql, dac, session

SQL Server 2005 Login Security - CHECK_POLICY and CHECK_EXPIRATION setting, how it affects the password policy?

Published 30 April 8 3:53 AM | SSQA.net

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

Filed under: sql server, microsoft, security, feature, password, best practice, trustworthy, computing, logins, policies, settings, check_policy, check_expiration

Webcast: 24 Hours of SQL Server 2008: Ensuring Your Data Is Secure with a Trusted Platform

Published 28 March 8 6:45 PM | SSQA.net

Another part of Technet webcast series on SQL Server 2008. In this part a focus on IT professionals and the SQL Server 2008 the Trusted Platform. In the first part of the series we spent time looking at how Contoso was using SQL Server 2008 as a productivity...

Filed under: business continuity, sql server, high availability, technet, security, 2008, trusted platform, data loss, data platform

SQL Server Clustering - what is the difference between Active/Passive and Active/Active Clustering, which is good for better performance?

Published 18 March 8 4:20 AM | SSQA.net

First part of question is a pure newbie FAQ to know about, and the simple answer would be it is one of the Clustering type you can adopt within your SQL Server environment. To cover on newbie aspect both Active/Passive & Active/Active configuration...

Filed under: sql server, performance, security, clustering, 2005, partition, monitoring, active/passive, parallel execution, performance monitoring, active/active, scalability

Windows Server 2008 deploy within your environment securely!

Published 6 March 8 2:50 AM | SSQA.net

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

Filed under: sql server, databases, microsoft, security, server, windows, 2008, environment

SQL Server 2008 Data Security - TDE: Transperent Data Encryption what you need to know

Published 5 March 8 2:5 AM | SSQA.net

What kind of security features you adopt to protect your data? Login security, permissions and unauthorised access to your data, there is more you can do with SQL Server 2008 new feature called TDE - Transperent Data Encryption that is provided automatically...

Filed under: sql server, security, features, 2008, data encryption, transperent, tde

SQL Server 2005 BI evaluate and diagnose Analysis Services database performance

Published 18 February 8 3:57 AM | SSQA.net

Performance - one word does it all! You are aware that during the Performance Tuning exercise there are few quick wins within the SQL Server Relational Database Engine such as table statistics for data and indexes. When it comes to Analysis Services Read...

Filed under: sql server, profiler, performance, databases, security, process, sysmon, administrator, Analysis Services, diagnose

SQL Server Lockdown - Step by Step procedure

Published 13 February 8 2:31 AM | SSQA.net

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

Filed under: sql server, microsoft, security, tools, article, sa, procedure, best practice, downloads, bpa, lock down

SQL Server consolidation and virtualization - hot topic in the industry

Published 12 February 8 5:35 AM | SSQA.net

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

Filed under: sql server, microsoft, security, environment, sa, 2000, 2005, virtual server, vmware, operating system, windows server, benefit, costing

See how Resource Governor can help you 'in action' in managing SQL Server resources?

Published 8 February 8 2:11 AM | SSQA.net

As you may be aware about new features within SQL Server 2008, one of the them is Resource Governor which is a feature than you can use to manage SQL Server workload and system resource consumption. It will enable you to specify limits on the amount of...

Filed under: application, sql server, management, blogs, security, query, 2008, resource governor

SQL Server 2005 Agent XPs disabled error - how to resolve this issue?

Published 6 February 8 2:38 AM | SSQA.net

When SQL Server 2005 Management Studio's Object Browser shows the SQL Server Agent service with a red down arrow and the text Agent XP's disabled , the service is not started or disabled. This used to be a problem prior to Service Pack 2 for SQL...

Filed under: sql server, profiler, security, services, sqlagent, sa, error log, msdtc, group policy

SQL Server Performance - what it takes for a newbie DBA in resolving performance issues?

Published 5 February 8 2:57 AM | SSQA.net

SQL Server Performance Tuning, sounds familiar on a DBA perspective and though it sounds like an easy words but when you start analyzing the problem it is far deeper inside. When you refer to the web resources such as forums/newsgroups then a common question...

Filed under: sql server, performance, blogs, blocking, security, query, best practice, index plan, sql server central, newsgroups, forums

Real-time replication with SQL Server reporting, strategies and resolution to the problems?

Published 30 January 8 12:23 PM | SSQA.net

Replication plays important role within the data-driven events in an Enterprise, vital to the sales-work force type of management. DBAs will always have a primary focus in providing protection for the data assets stored in SQL Server. Protection that...

Filed under: sql server, microsoft, data, integration, security, download, replication, reporting services, magazine, windows it pro

Unattended installation of application on multiple sites by using sa password with a symmetric key, is it possible in SQL Server?

Published 29 January 8 1:36 AM | SSQA.net

The newest ranch of Security - trust worthy features in SQL Server 2005 usage of symmetric keys has an important role. Always the document suggests to use Windows Authentication of security purpose and better control of user/security management, but when...

Filed under: application, sql server, security, best practice, sql authentication, sa password, symmettric keys, store, windows authentication

Security best practices - personally & technically

Published 26 January 8 8:12 AM | SSQA.net

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

Filed under: business continuity, sql server, microsoft, blogs, integration, security

SQL Server Security & Compliance - webcast by IDERA

Published 18 January 8 8:58 AM | SSQA.net

"SQL Server Security & Compliance" Sponsored by Idera : SQL Server security and compliance go hand in hand. With the changes in legislation and new requirements to ensure that database platforms such as SQL Server are secure we will take...

Filed under: sql server, management, webcast, security, tools, dba, manager, idera, third party, architect