Browse by Tags

• 1433
• article
• backups
• baseline
• benchmarking
• blog
• blogs
• bpa
• check_expiration
• check_policy
• computing
• dashboard
• databases
• dba
• dbcc
• dmv
• downloads
• environment
• feature
• lock down
• logins
• management
• max worker threads
• monitoring
• operating system
• password
• performance
• performance monitoring
• policies
• port
• procedure
• resources
• sa
• security
• server
• settings
• slow query
• sql server
• sqlperf
• system
• technet
• testing
• tools
• trustworthy
• tuning

SQL Server 2005 Login Security - CHECK_POLICY and CHECK_EXPIRATION setting, how it affects the password policy?
30 April 08 01:53 AM | SQL Master | 2 Comments   

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

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

SQL Server Lockdown - Step by Step procedure
13 February 08 01:31 AM | SQL Master | 4 Comments   

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

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

SQL Server performance monitoring requirement and specifications, heard about baseline and benchmarking?
19 December 07 05:06 AM | SQL Master | 3 Comments   

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

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

Changing ports on production SQL Server - things to watch for 1433
07 December 07 11:29 AM | SQL Master | 2 Comments   

What is your criteria on assigning ports to SQL Server? Are you leaving them to default 1433? Is your SQL Server is exposed to Internet or any external sources where there is a chance to produce mass attach or run code injection? Every DBA should give Read More...

Filed under: sql server, microsoft, security, databases, best practice, 1433, operating system, port

SQL Server: How do I identify the queries that are worth tuning?
16 November 07 06:02 AM | SQL Master | 2 Comments   

Have you ever asked this question about how do I identify the queries that worth tuning? The simple answer it is neither easy or hard to obtain such information if you have managed your SQL Server by deploying industry best practices (wherever possible). Read More...

Filed under: performance, sql server, microsoft, management, dmv, dba, best practice, blogs, technet, slow query

If MAX WORKER THREADS increased from 255 to 500 what will be the usage or availability of system resources on the server?
15 November 07 08:41 AM | SQL Master | 2 Comments   

Continuing on the MAX WORKER THREADS topic from ThisBlog I have been asked about method of calculating the amount of system resources that will be used when the setting is increased to 500 from 255 (default). Well, as one of the best practices you must Read More...

Filed under: tuning, performance, sql server, microsoft, server, dbcc, testing, best practice, resources, max worker threads, sqlperf, system