Spamming about Information Technology (System Center, Exchange, PKI, Unified Communication and Virtualization)
Posts tagged SQL
Upcoming how-to guides
02 years ago
Within two weeks I will post two how-to guides.
- How to setup a high availability SQL Server 2008 R2 cluster (HA clustering and mirroring).
- How to create a highly available SharePoint 2010 farm.
Requests for other how-to guides are always welcome.
SQL Server 2008 R2 RTM
02 years ago
Source: Microsoft SQL Server team blog
We are very excited to share that today, Microsoft released SQL Server 2008 R2 to manufacturing! Customers can expect availability in the next few weeks through Microsoft’s distribution channels. For more information, visit www.sqlserverlaunch.com.
SQL Server 2008 R2 enhancements continue to support mission-critical workloads providing a trusted, scalable platform, increased developer and IT efficiency and managed self-service business intelligence reporting and analytics. It is for these very reasons that SQL Server 2008 R2 is setting records for performance and price/performance on industry standard benchmarks.
Upcoming blog posts
02 years ago
by Bart Timmermans
in Uncategorized
Currently I am working on several articles. These articles will be published within the next couple of weeks on this blog.
- Comparison of SQL Server 2008 High availability options (fail-over clustering, mirroring, log-shipping and replication)
- How to create a SQL Server 2008 2 node cluster on Windows Server 2008 R2 (using iSCSI and Windows Storage Server 2008)
- How to create a baseline of a new MOSS 2007 environment using Visual Studio 2008
- How to extend MOSS 2007 search capabilities using 3rd party software (Ontolica, BA-Insight and open source Faceted search)
Stay tuned.
How to guide: Creating a SQL 2008 cluster on Windows Server 2008 R2 (200)
02 years ago
In development.
MOSS 2007: Patching a mirrored farm with minimal downtime
02 years ago
by Bart Timmermans
in Sharepoint
Source: Microsoft SharePoint Team blog
For administrators of large SharePoint server farms, a newly-published article describes how to update server farms that use database mirroring, while incurring minimal perceived downtime for users. This solution is for enterprise customers who have high-availability needs and infrastructure. The article describes a step-by-step process for Office SharePoint Server farms that incorporate SQL Server mirroring. You can achieve similar results on Office SharePoint Server farms that are set up in a clustered server environment.
In brief, the solution requires that you:
· Disable mirroring and set the mirror databases to read-only
· Route network and database traffic to the read-only databases
· Apply software updates to the offline servers
· Route network and database traffic to the updated servers
· Apply software updates to the secondary farm
· Re-enable mirroring and set the mirrored databases to read/write
To read the full solution, see Configure a server farm for minimal downtime during software updates
Slipstreaming SQL Server 2008 and Service pack 1
03 years ago
As found on the SQL Server blog (petersad): http://blogs.msdn.com/petersad/archive/2009/02/25/sql-server-2008-creating-a-merged-slisptream-drop.aspx
Today, I am going to show you how to create new source media that will slipstream the original source media and SQL Server 2008 Service Pack 1. Once you have created this drop, you can install SQL Server 2008 SP1 in a single step! These instructions are included with the Service Pack 1 release but there are some issues with the documentation that will be addressed in the next revision of the on-line documentation. There is not a lot of user interface that indicates you are slipstreaming, but there are a few clues, see at the bottom for screen shots.
Click here for the full article.
