Browse by Tags

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

Receive 24 hours of free, online training on new Microsoft products
27 February 08 11:29 PM | ssqa.net | 2 comment(s)

Jump into training with Microsoft Learning! This was the theme with Heroes Happen Here launch and here are further details from Microsoft Learning page: Receive 24 hours of free, live online training Microsoft Certified Trainers present 24 hours of live...

Filed under: sql server, 2008, microsoft, online, launch, conference, learning, windows server, visual studio, heroeshappenhere, training

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