Browse by Tags

All Tags » sql server » microsoft   (RSS)
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...
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...
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...
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...
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...
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...
NTFS Cluster size - if changing the default cluster size on the disk is a good idea or not?
16 October 07 05:18 AM | SQL Master | 2 Comments   
You might have come across on the web resources that setting the disk to a 64k cluster size (8 * 8KB pages) might achieve the performance. But have you wondered will this really boost the disk performance, see in what scenario such as lots of reads and Read More...
Determining the required capacity of an I/O subsystem before deploying the database
17 September 07 06:49 AM | SQL Master | 4 Comments   
It is a good practice to determine the required capacity for a database application before it is deployed on the Production environment. As it speaks the I/O system is "most" important to the performance of SQL Server, in the event of any performance Read More...
SQL Server 2005 using Cryptography & Encryption what they are for?
13 September 07 05:46 AM | SQL Master | 2 Comments   
Since the inception of SQL Server 2005 data encryption and cryptography functionality has elevated to a new level, this wasn't the case until SQL 2000 version. The overall security improvements within SQL 2005 is mainly with 'certficate' authentication, Read More...
Disable SA account on a live SQL Server2005 instance, any drawbacks?
13 August 07 02:03 AM | SQL Master | 2 Comments   
Last week I have been delegated to finalize the security standards within a set of SQL 2005 instances that are used by a customer, though it is usual chores for me to apply industry best practices. On these SQL 2005 instances in particular I was more Read More...
How to gain Disk related performance with few simple steps
30 July 07 07:24 AM | SQL Master | 4 Comments   
Within your SQL Server environment there are few simple steps you can take up in order to gain performance to a level, for instance when configuring a SQL Server that will only contain a few gigabytes (GB) of data and not sustain heavy read nor write Read More...
/3GB /PAE and AWE blurb what is it you hear within your environment?
25 July 07 07:06 AM | SQL Master | 4 Comments   
You might have come across a situation to have a better understanding on what /3GB or /PAE switch means that are referred in documentations and forums you go on. I will try my best to give you the notes what I have understood so far in this regard. From Read More...
SQL Server 2005 Security best practices on the Administrative tasks
06 July 07 09:08 AM | SQL Master | 1 Comments   
You have various references available on the web about things to take care on the security management for SQL Server, in addition to the SQL Server 2005 Books Online . Features and options that are new or defaults that are changed for SQL Server 2005 Read More...
Performance and Scalability: SQL Server 2005 Enterprise Edition Benchmarks
20 June 07 01:42 PM | SQL Master | 1 Comments   
SQL Server 2005 achieved the #1 price/performance result for 3TB TPC-H non-clustered benchmark. This is a record breaking TPC-H three terabyte benchmark for a database running on Microsoft Windows and an HP Integrity rx8640 Server. The recent TPC-H benchmark Read More...
Get SYSMON counters using a TSQL query aka DMVs.
31 May 07 08:26 AM | SQL Master | 1 Comments   
SYSMON aka PERFMON is a best tool to find out the system resources usage on a Windows server, similarly SQL Server 2005 has list of such useful DMVs to get you more information on many of the SQL Server-related objects, instances and counters by using Read More...
More Posts Next page »

Search

Go

This Blog

«December 2008»
SMTWTFS
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910

Syndication