Browse by Tags

Leveraging SQL Server Technologies to Build a Solid High-Availability Strategy - Tech-ed Online Panel video available to view

Published 22 July 8 6:37 AM | SSQA.net

In continuation to Tech-ed North America - what I'm doing there? & Say goodbye to Tech-ed 2008 Developers and say hello to IT-PRO! posts here and to wrap up the earlier posts about Tech-ed Online Panel: Leveraging SQL Server Technologies to Build...

Filed under: sql server, high availability, tech-ed, online, strategy, networking, panel discussions, standards

Tech-ed Online Panel: Leveraging SQL Server Technologies to Build a Solid High-Availability Strategy

Published 29 May 8 4:11 AM | SSQA.net

Are you visiting Tech-ed, North America? Tech·Ed offers the premier technical education conference just for IT professionals. Microsoft and industry experts will share their expertise about how to architect, deploy, manage, and help secure a connected...

Filed under: sql server, high availability, tech-ed, 2008, 2005, online, panel, discussion

SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!

Published 25 January 8 3:41 AM | SSQA.net

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, performance, indexes, cache, users, tsql, best practice, backups, create, online, monitoring, operating system, busy, creation

SQL Server 2005 Service Pack 2 Cumulative Update 5 instalment available for download with a request to CSS!

Published 27 December 7 2:2 AM | SSQA.net

From the series of the SQL Server 2005 Service Pack2 Cumulative Update packages blogs and for instance we blogged about SQL2005SP2CU5 earlier, it is available to download now and before that there is a catch to obtain this package. It is not that easy...

Filed under: sql server, package, msdn, blogs, support, service pack2, testing, online, cumulative update, pss, css, installallation

SQL Server 2005 Cumulative Update 5 for Service Pack 2 - available for download with a request to CSS!

Published 24 December 7 4:42 AM | SSQA.net

From the series of the SQL Server 2005 Service Pack2 Cumulative Update packages blogs and for instance we blogged about SQL2005SP2CU5 earlier, it is available to download now and before that there is a catch to obtain this package. It is not that easy...

Filed under: sql server, package, msdn, microsoft, blogs, support, service pack2, testing, online, cumulative update, pss, css, installallation

SQL Bits II - here it comes again

Published 13 December 7 5:1 AM | SSQA.net

SQL Bits is back again, this time 01st March 2008 at The Lakeside Conference Centre in Birmingham. Its a bigger venue than Microsoft TVP that will give more people 'SQL Geeks' to attend. Hold on your horses, registrations aren't open yet but...

Filed under: sql server, microsoft, community, 2008, 2005, sqlbits, online, conference, configuration, speakers, meeting, sessions, selection

Cluster resource 'SQL Server (<SQL Server instance name>)' in Resource Group '<Cluster group name>' failed.

Published 10 October 7 4:31 PM | SSQA.net

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, dba, sqlagent, best practices, cluster, error log, online, failure, active/passive

Msg: 2522 The index "<name>" (partition 1) on table "TableName" cannot be reorganized because page level locking is disabled.

Published 7 August 7 8:43 AM | SSQA.net

All of sudden the re-org of an index started failing and no error was displayed within that scheduled job we execute. After executing the code from Query Editior I was able to get the message as follows: Msg 2552, Level 16, State 1, Line 3 The index "<name>"...

Filed under: sql server, performance, indexes, service pack, online, allow_page_lock

Upcoming events (webcasts & online) about SQL Server 2008 July 2007 CTP

Published 1 August 7 2:58 AM | SSQA.net

So July2007Ctp is available now and you need to learn more details about this release, then look at the calendar of events (online & webcasts) that are lined up by Microsoft SQL Server Developmetn Team. The first event is scheduled to host on 13th...

Filed under: sql server, webcast, 2008, ctp, connect, whatsnew, webchat, online