Browse by Tags

Cumulative Update 9 for SQL Server 2005 Service Pack 2 - another update package in line
01 September 08 08:05 AM | ssqa.net | with no comments

In continuation to the CumulativeUpdate package posts here for SQL Server 2005 SP2 we have another set of cumulative update package no.9 ready for testing. TO obtain this read the notes from Microsoft: .... Apply it only to systems that are experiencing...

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

Microsoft Security Bulletin Summary for July 2008, pay attention this is for SQL Server!
09 July 08 09:17 AM | ssqa.net | with no comments

I believe it has been a while that we have seen the security hotfix from Microsoft Security team on SQL Server (alone). The latest security bulletin has announced important security patches that are related to SQL Server in addition to Windows operating...

Filed under: sql server, security, best practices, service pack, hotfix, gdr, patch, qfe

Tech-ed North America - next 2 weeks make yourself busy with learning & sharing
01 June 08 10:49 PM | ssqa.net | with no comments

Blogger buttons courtesy: Microsoft Be a part of the experience. Help spread the excitement about Tech Ed 2008! -Satya SKJ ( SQL Server MVP )

Filed under: microsoft, best practices, conference, tech-ed, professionals

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

More Posts Next page »