Browse by Tags

SQL Server multiple instances and resource utilization - best practices
15 May 08 10:48 AM | ssqa.net | with no comments

A newbie or FAQ within Forums and Newsgroups that having multiple instances and how best to set the resources on the server such as memory, CPU etc. Should you configure each of the instances to use specific portions of the available Operating System...

Filed under: sql server, resources, performance, best practices, installation, multiple, instances, consolidation, virtualization

SQL Server 2005 and Disk drive allocation unit size to 64K - any benefit or performance?
28 April 08 04:28 PM | ssqa.net | 1 comment(s)

You may be aware that or seen within your Database platform about slower disk performance than expect having multiple disks in Windows Server 2003 environment when you use a hardware-based redundant array of independent disks (RAID) or a software-based...

Filed under: sql server, performance, best practices, database, benefits, data file, sizes, 64k, allocation

How to configure SQL Server Reporting Services in a DMZ environment?
22 April 08 07:27 AM | ssqa.net | with no comments

Many questions will come out if you need set your Reporting Server on Internet within DMZ environment? The important aspects involves SQL Server database, Reports Services & Report Manager, for the sake of discussion say if Report Services and Report...

Filed under: sql server, report builder, reporting services, security, best practices, ssrs, tcp, report server, port, udp, 1433

Cumulative Update 7 available for SQL Server 2005 SP2 - get it now to test and apply (if needed)
15 April 08 10:16 PM | ssqa.net | with no comments

Here is another candidate of 7 within Cumulative Update service for SQL Server 2005 SP2. SQL Server Release Services team has announced (yesterday) that another instalment of Cumulative Update ( series here ) for SQL Server 2005 on Service Pack 2, it...

Filed under: sql server, microsoft, best practices, download, service pack, cumulative update, package, releases

SQL Server Integration Services - think about Transactions and Checkpointing?
07 April 08 07:21 AM | ssqa.net | with no comments

Transactions and Checkpoints are important factors for data consistency, when it comes for ETL processes that too on SSIS what is your stand? I'm covering this important task for the sake of newbie & junior DBAs, also the similar question was...

Filed under: sql server, best practices, ssis, setup, package, checkpoint, bol, commit, rollback, dts, ssis package, transaction

SQL Server Integration Services and Clustering - confguration gotcha to ensure SSIS works with failover of cluster!
17 March 08 01:06 PM | ssqa.net | with no comments

A newbie or FAQ within Forums and Newsgroups that having multiple instances and how best to set the resources on the server such as memory, CPU etc. Read more from here.

Filed under: sql server, best practices, configuration, benefits, management studio, multiple, memory, instances, cpu

Cluster resource 'SQL Server (<SQL Server instance name>)' in Resource Group '<Cluster group name>' failed.
13 March 08 09:05 AM | ssqa.net | with no comments

A common mistake by DBAs for missing to check whether all the functionality of tools are working when a SQL Server Cluster environment is setup, though you may not catch hold of few issues with basic failover/failback testing initially but when the application...

Filed under: sql server, best practices, sqlagent, error log, online, dba, failure, active/passive, cluster

Few hours to go for Windows Server, Visual Studio and SQL Server 2008 launch, here is big deal on SQL release date!
27 February 08 12:09 PM | ssqa.net | with no comments

I have been following Dan Jones's blog on " Launch_T-1 , Launch_T-3 & Launch_T-5 " series about SQL Server Launch in US (PST), as a Development Program Manager they have huge task ahead to complete and its not that easy to manage as per the schedule...

Filed under: sql server, 2008, microsoft, best practices, blogs, msdn, launch

Vote now: Index defragmentation best practices for SQL Server 2005 & 2008 documentation
26 February 08 10:25 AM | ssqa.net | with no comments

From the snippet of Tibor Karaszi , SQL Server MVP I have raised a feedback form on Connect.Microsoft website to get newer version (SQL Server 2005) about Index Defragmentation Best practices information. Vote your interest to get newer documentation...

Filed under: sql server, best practices, index, vote now, defragmentation, connect

SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!
25 February 08 07:53 AM | ssqa.net | with no comments

Though it is not a best practice to perform a CREATE INDEX on large tables during the online hours where you have number of users accessing the metadata of SQL Server database. Within SQL Server 2005 Enterprise Edition you can perform ONLINE indexes operation...

Filed under: sql server, 2005, server, performance, best practices, index, clustered, online, production

Cumulative update package 6 for SQL Server 2005 Service Pack 2 - available now
20 February 08 11:57 AM | ssqa.net | with no comments

Cross post from http://sqlserver-qa.net/blogs/tools/archive/2008/02/20/cumulative-update-package-6-for-sql-server-2005-service-pack-2-available-now.aspx

Filed under: sql server, microsoft, best practices, download, sp2, testing, service pack, cumulative update

SQL Server 2005 Index Optimization Best Practices
19 February 08 07:04 AM | ssqa.net | 3 comment(s)

Do you have a maintenance window to perform database reindexing? Have you ever performed full set of re-organize and re-index process on a bigger database? Do you know there are best practices to deploy in this regard? On large database systems, with...

Filed under: sql server, ssqa, 2005, performance, best practices, reorganize, optimization, database, statistics, blogs, index, dbreindex, reindex

SQL Server Books Online - Whats new and how to get most out of it!
18 February 08 08:29 AM | ssqa.net | 1 comment(s)

A must for all SQL Server users and don't forget to upgrade your local copies and further read on from this article - http://sqlblogcasts.com/blogs/ssqanet/pages/sql-server-books-online-what-s-new-and-how-to-get-the-most-out-of-it.aspx

Filed under: sql server, microsoft, best practices, documentaiton, download, books online

SQL Server 2008 links and resources
14 February 08 09:37 AM | ssqa.net | 1 comment(s)

Buck Woody, Program Manager for SQL Server has posted very useful links and resources for SQL Server 2008 and I would like to share them over here, refer to this SQL2008 resources link. -Satya

Filed under: sql server, 2008, resources, best practices, links

SQL Server Lockdown - Step by Step procedure
13 February 08 11:06 AM | ssqa.net | with no comments

Cross posting from other blog - http://sqlserver-qa.net/blogs/perftune/archive/2008/02/13/3502.aspx fyi. Hope you don't want to do it!

Filed under: blog, sql server, ssqa, security, best practices, lock down, availability