• About
  • Contact
  • Resources
  • Speaking, Technical Community Involvement & Publications

– Microsoft technologies and what I do for fun –

Monthly Archives: November 2011

From *-SqlHadrService to *-SqlAlwaysOn

17 Thursday Nov 2011

Posted by Edwin M Sarmiento in High Availability, PowerShell, SQL Server "Denali"

≈ Leave a comment


If you’ve been playing with SQL Server “Denali” AlwaysOn, you probably have seen the new PowerShell cmdlets for managing the new AlwaysOn feature. However, as SQL Server 2012 RC0 has been made available for download, you need to watch out for these “breaking changes” for AlwaysOn (I call them breaking changes because if you are using PowerShell scripts to automate AlwaysOn configuration, your scripts would no longer work.)

With SQL Server “Denali” CTP3, you may have used cmdlets like *-SqlHadrService to enable the AlwaysOn features across all instances that you join in your availability group.


Starting with SQL Server 2012 RC0, these have now been converted to *-SqlAlwaysOn.


So be sure to update those PowerShell scripts before you run them for testing to make sure you don’t waste your time trying to figure out what went wrong. And if you haven’t downloaded SQL Server 2012 RC0 yet, make sure you do so and get your hands dirty trying out the latest bits.

And since we’re already on the topic of SQL Server 2012, you also might want to catch my webcast on AlwaysOn Availability Groups on 30-Nov-2011. You can register for the webcast thru this URL.

Advertisements

Building a Scale-Out SQL Server 2008 R2 Reporting Services Farm Whitepaper Now Available

15 Tuesday Nov 2011

Posted by Edwin M Sarmiento in Reporting Services, Scale-Out, SQL Server 2008 R2, SQL Server MVP Deep Dives

≈ Leave a comment


Back in 2009, I wrote a 4-part series article on installing SQL Server 2008 Failover Cluster on Windows Server 2008 and, for the past two years, has been on the Top Ten Tips. I think one of the reason is because of the fact that we humans learn easily with the use of visuals (the articles are packed with screenshots and explanations). And since the internet has provided us with the opportunity to explore different types of media – graphics, videos, animations, etc. – our demand for these different types of media has increased with our need for continuous learning.

Last year, I was searching for official documentation on building a scale-out SQL Server 2008 R2 Reporting Services farm from both the Microsoft TechNet and MSDN sites. However, the amount of documentation and the way they were written were too much for me. I guess that’s because they were written for a more highly technical and advanced audience. In more cases than not, I’ve been frustrated when I can’t even understand the jargon used in the documentation. And I’m guessing I’m not alone. More and more IT professionals want to try out new stuff but are taken aback by the complexity of the documentation available out there. And, so, with the same motivation behind the SQL Server 2008 Failover Cluster series of articles, I wrote a document on building a scale-out SQL Server 2008 R2 Reporting Services farm. I thought, since I’ve been doing it or SharePoint, why not do it for Reporting Services. This was the basis of the five-part series article made available on MSSQLTips.com.

You can download the whitepaper from here. I would, however, request that you’d fill in your information here for my reference and feedback. Print out as many copies as you like, share it with your friends who you think will benefit from it or send them the PDF version. If you would be using this document for purposes other than personal – presentations, blog posts, articles, etc., please provide proper attribution to the original source.

I definitely would love to hear from you as this helps me improve my work.

Watch Out for SQL Server 2012 AlwaysOn Webcast

03 Thursday Nov 2011

Posted by Edwin M Sarmiento in SQL Server, SQL Server "Denali", SQL Server Disaster Recovery

≈ 2 Comments


My friends at MSSQLTips.com asked me to do a webcast on SQL Server 2012 AlwaysOn Availability Groups. You’ve probably noticed that I have not been writing anything about SQL Server 2012 (formerly “Denali”) from both the articles that I’ve been writing and the previous blog posts as compared to when SQL Server 2008 was being released. That’s just my preference specifically because of all the stuff that I can’t talk about back then. Well, now that it is officially out in the public with the new name, I guess I no longer have to worry about mentioning anything that isn’t publicly available.

Being a high availability/disaster recovery (HA/DR) guy, AlwaysOn is one of the features that I like about SQL Server 2012. This provides organizations with more options to consider when implementing an HA/DR solution.  Two things that are being introduced here are AlwaysOn Availability Groups and AlwaysOn Failover Clustering.

On the 30th of November 2011 (3PM EDT), join me and the guys from Fusion-IO and MSSQLTips.com as we explore this new feature in SQL Server 2012 called AlwaysOn Availability Groups. To register for this webcast, simply click on this link. If you have questions about AlwaysOn Availability Groups  even before the webcast, you can post them here so we can discuss it further. I will try my very best to make sure that your question be mentioned during the webcast

Twitter Updates

Error: Twitter did not respond. Please wait a few minutes and refresh this page.

SQL Server 2012 with PowerShell v3 Cookbook

SQL Server MVP Deep Dives Vol 2

Grab a copy now: SQL Server MVP Deep Dives Volume 2

SQL Server MVP Deep Dives Vol 1

Categories

AlwaysOn Availability Groups High Availability PowerShell SharePoint SQL PASS SQLPASS SQL Server SQL Server "Denali" SQL Server 2005 SQL Server 2008 SQL Server 2012 SQL Server Administration SQL Server Disaster Recovery SQL Server learning TechEd Asia 2008 Uncategorized Windows Cluster Windows PowerShell Windows Server 2008 Windows Server 2008 Clustering

Archives

  • March 2015 (4)
  • February 2015 (1)
  • November 2014 (1)
  • September 2014 (1)
  • July 2014 (1)
  • January 2014 (1)
  • December 2013 (1)
  • October 2013 (3)
  • September 2013 (4)
  • August 2013 (3)
  • July 2013 (2)
  • June 2013 (1)
  • May 2013 (1)
  • April 2013 (2)
  • February 2013 (1)
  • January 2013 (2)
  • December 2012 (1)
  • November 2012 (2)
  • October 2012 (1)
  • September 2012 (1)
  • July 2012 (3)
  • June 2012 (1)
  • March 2012 (4)
  • January 2012 (1)
  • December 2011 (1)
  • November 2011 (3)
  • October 2011 (2)
  • September 2011 (1)
  • August 2011 (2)
  • July 2011 (2)
  • June 2011 (5)
  • May 2011 (1)
  • April 2011 (3)
  • March 2011 (3)
  • February 2011 (1)
  • January 2011 (1)
  • December 2010 (1)
  • November 2010 (4)
  • August 2010 (2)
  • May 2010 (2)
  • April 2010 (1)
  • March 2010 (2)
  • February 2010 (2)
  • January 2010 (1)
  • December 2009 (1)
  • November 2009 (3)
  • October 2009 (1)
  • September 2009 (3)
  • July 2009 (3)
  • June 2009 (3)
  • May 2009 (2)
  • April 2009 (6)
  • March 2009 (8)
  • February 2009 (8)
  • January 2009 (2)
  • November 2008 (2)
  • October 2008 (3)
  • September 2008 (2)
  • August 2008 (5)
  • July 2008 (12)
  • June 2008 (5)
  • May 2008 (4)
  • April 2008 (4)
  • March 2008 (7)
  • February 2008 (3)
  • January 2008 (5)
  • December 2007 (6)
  • November 2007 (6)
  • October 2007 (22)
  • September 2007 (5)
Advertisements

Blog at WordPress.com.

Cancel
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy