Browse by Tags

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

Best way to deploy SQL Server 2005 with SAN

Published 28 January 8 2:1 AM | SSQA.net

If it is a first time you are deploying the SQL Server 2005 on a SAN, then there are few things you need to be considered that will be raised by installations that are either deploying SQL Server for the first time or are upgrading to SAN from direct...

Filed under: sql server, performance, tools, 2005, san, best practice, raid, hardware, configuration, benchmarking, downloads, iometer, deployment, sqlio

SQL Server performance monitoring requirement and specifications, heard about baseline and benchmarking?

Published 19 December 7 6:6 AM | SSQA.net

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

Filed under: dashboard, sql server, performance, databases, microsoft, security, blog, environment, best practice, backups, monitoring, baseline, benchmarking, downloads, performance monitoring