Browse by Tags

• bi
• bids
• clustering
• Conferences
• database
• database mirroring
• disaster
• error
• failover
• geographic
• Installation
• Integration
• Katmai
• kba
• mirror
• msdtc
• New Features
• not found
• performance
• performancepoint
• principal
• recovery
• security
• server
• SQL 2005
• SQL 2008
• SQL Community
• SQL Server
• SSMS
• surface
• tips
• tsql
• witness
• x64

• Some things don't change - DB Snapshots & Backups of Snapshots

  Again, I wanted to blog about something that still does not change between 2005 and 2008. At a recent conference, there were some great questions/ideas that should make it to Connect if they haven't already. When DB Snapshots were first introduced, one Read More... Posted Thursday, May 08, 2008 12:40 AM from Rick Heiges | (Comments Off) Filed under: SQL 2008, high availability, SQL 2005

• Some things don't change - Partitioning

  After spending the past couple of weeks at the MVP Summit in Seattle and at SQL Connections in Orlando, I thought I should blog about things that do not change in 2008 (at least partially). One of the reason s to partition your tables is to make it more Read More... Posted Monday, April 28, 2008 9:09 AM from Rick Heiges | (Comments Off) Filed under: SQL 2008, Katmai, high availability

• No More HCL - in 2008

  The old Hardware Compatibility List which was renamed the "Windows Catalog" is no more. When creating a Clustered Solution, you need to have a system that is Certified for clustering or there will be no official support. This has been a point of pain Read More... Posted Thursday, December 20, 2007 12:25 AM from Rick Heiges | (Comments Off) Filed under: SQL Community, SQL 2008, Katmai, high availability, New Features

• Compression in DB Mirroring

  When you start to look at SQL Server 2008, there is a sub-theme of using compression to help drive performance and usefulness. When I hear the word compression, my first thought is "No - I remember Stacker". How many years ago was that obscure reference? Read More... Posted Tuesday, November 20, 2007 9:19 PM from Rick Heiges | (Comments Off) Filed under: SQL 2008, Katmai, high availability, New Features

• Who's got your DB's back?

  While I was reviewing one of the sessions from the PASS Community Summit using the streaming media on some new things in SQL Server 2008, I stumbled across a new reason to mirror. The primary reason to mirror of course is availability and to give DBAs Read More... Posted Saturday, November 10, 2007 1:05 AM from Rick Heiges | (Comments Off) Filed under: Conferences, SQL 2008, high availability

• Number of databases limit for Database Mirroring within X64 environment?

  We have had a request from one of the solutions company stating they have to mirror 15 SQL Servers that are dispersed across the European locations to a central location. For this they have deployed the X64 environment for operating system and SQL Server Read More... Posted Thursday, August 30, 2007 8:27 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, x64, server, database mirroring, high availability, geographic

• Data Protection and Disaster Recovery Tips

  How to protect and secure data in the event of a disaster? It's not possible to anticipate every possible disaster your organization may encounter, but you don't have to. Discover a wealth of information about how to protect and secure your data in the Read More... Posted Tuesday, August 28, 2007 8:54 PM from SSQA.net | (Comments Off) Filed under: SQL Server, server, recovery, high availability, tips, disaster

• How to rebuild or move a MSDTC installation to be used with a SQL failover cluster

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications How to rebuild or move a MSDTC installation Read More... Posted Wednesday, August 22, 2007 7:03 PM from SSQA.net | (Comments Off) Filed under: SQL Server, Installation, kba, high availability, msdtc, clustering, failover

• [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). [ODBC SQL Server Driver][DBNETLIB]Specified SQL server not found

  --------------------------- Microsoft SQL Server Login --------------------------- Connection failed: SQLState: '01000' SQL Server Error: 11004 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Connection failed: SQLState: '08001' Read More... Posted Wednesday, August 22, 2007 12:06 AM from SSQA.net | (Comments Off) Filed under: security, SQL Server, Integration, SSMS, error, high availability, surface, not found

• Get basic Database Mirroring information- principal or mirror

  SELECT DB_NAME(database_id) AS 'DatabaseName' , mirroring_role_desc , mirroring_safety_level_desc , mirroring_state_desc , mirroring_safety_sequence , mirroring_role_sequence , mirroring_partner_instance , mirroring_witness_name , mirroring_witness_state_desc Read More... Posted Monday, August 20, 2007 8:32 AM from SSQA.net | (Comments Off) Filed under: SQL Server, tsql, database, database mirroring, principal, high availability, witness, mirror

• BI - PerformancePoint Server LAST CTP announced!

  Microsoft released PerformancePoint Server’s LAST Community Technical Preview (CTP) before launch! To date, the CTP program has gathered close to 10,000 members and the product has been enjoying fantastic pre-launch press and analyst coverage. For more Read More... Posted Friday, August 17, 2007 1:32 AM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, performancepoint, bi, bids, high availability