Browse by Tags

SQL Server 2005 detect DAC session with TSQL
09 May 08 01: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?
30 April 08 03: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

Justifying Business Continuity and Risk Management - Web Seminar
07 April 08 06:01 PM | SSQA.net

Better enable your users to execute their job functions, regardless of any disastrous event Availability of mission-critical applications to all users at all times is a key component of justifying business continuity and risk management plans. Merging...

Filed under: business continuity, analysis, data, security, disaster recovery, impact, production, success

Webcast: 24 Hours of SQL Server 2008: Ensuring Your Data Is Secure with a Trusted Platform
28 March 08 06: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?
18 March 08 04: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!
06 March 08 02: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
05 March 08 02:05 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
18 February 08 03: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
13 February 08 02: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
12 February 08 05: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?
08 February 08 02: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?
06 February 08 02: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

More Posts Next page »