Archive for the ‘SQL 2008’ Category

Windows 2008R2 MSTDC Clustering how hard can it be. Linked SQL Servers (2011-9-27)

The DTC option is a simple feature just turn it on and it works eh yeh sometimes. but in advanced environments you need often some tweaks and how to’s The following errors are common on misconfiguration on the SQL Cluster / MSDTC source MSDTC encountered an error (HR=0×80000171)  Or if you are using linked SQL [...]

What can go Wrong during the SQL 11 upgrade ( Beta SQL 11 Denali ) (2011-3-21)

Now that there is a beta of SQL 11 ( denali ) I want to see if I can break my Cluster with SQL 2008 on it during the upgrade. Yes I can. <>>Extra These are testing machines ( snapshot of production ) and the screenshot are showing you what can go wrong. It was [...]

Microsoft SQL Server 2008 and SQL Server 2008 R2 (2010-5-27)

The Infrastructure Planning and Design team has released an updated guide for Microsoft SQL Server 2008 and SQL Server 2008 R2. The Infrastructure Planning and Design (IPD) guide for Microsoft SQL Server 2008 and SQL Server 2008 R2 helps organizations address key design decisions and confidently plan the efficient implementation of a SQL Server infrastructure. [...]

Microsoft SQL Server 2008 R2 (2010-4-28)

With the release to manufacturing (RTM) of Microsoft SQL Server 2008 R2 database software, now is the time to prepare for new levels of innovation. Take training to learn how to use-and promote-new features that increase scalability and improve efficiency. With SQL Server 2008 R2, you can: Enable business users to build and share actionable [...]

Deployment part 1 (2010-4-8)

Lately I’m a bit busy with some offline project’s with large deployments and I think there is a good blog item in it but it takes some time to build it. Deployment is easy tools are every where but what tool do I need and what to use Not only Microsoft tools are here but [...]

system Center Data Protection Manager ( DPM 2007 ) (2009-11-8)

MGT102-SUN Why Microsoft Built a Backup Solution Presenters: Jason Buffington, Sandeep Phadke Sun 11/8 | 16:00-17:15 | New York 1 – Hall 7-1a This session was about  DPM today and feature Jason did a brief overview of what is coming this week and take the time for QA. He said DPM is a bit late [...]