The Controller
Now we get to the meat of the matter.You want a virtual cluster, the first thing you have to do is create your own portable domain.Start with a plain vanilla install of Windows 2003 R2 Standard on a semi-default VM.
Read more →
Planning.
I could stop there and let that be the entirety post #2 in this series. Planning is the single most important element in building a cluster and the Laptop Demo Cluster is no exception.
Read more →
This past Saturday I enjoyed the hospitality of the Tampa SQLSaturday(#32) team.My presentation was “Clustering for Mere Mortals”.Unlike many clustering presentations, I had demonstration content.This resulted in the most asked question being “Do you have instructions on how you built that?
Read more →
I just got this question from a blog reader:
We have a SQL 2005 cluster active/passive. Under my understanding, it would be neccesary to apply patches into a Testing environment, if working fine, proceed to the production environment.
Read more →
Looks like the Great Zune Massacre of 2008 was a day 366 issue. Again, someone forgot to throw out the code from the lowest ten percent of the Stack-Rank system. Sorry to sound harsh, but this is type of thing will flunk you out of Programming 101.
Read more →
Yes, I own a 30 GB Zune.Yes, it crashed today.Yes, I am unhappy.
Having worked in the computer industry for many years now, I watched many companies deal with failed products.
Read more →
Microsoft does not have a complete resolution for this problem yet, but they have found some more details. Evidently the problem with SQL Agent failure only occurs on systems using a domain admin account for the SQL Agent Service account.
Read more →
For the past several editions, SQL Books On-Line (BOL) has helpfully included a script to rebuild or defragment (since 2000) an index. Being Microsoft, this script is NOT located under the reindex or defragmentation topic, it is included in the fragmentation analysis section.
Read more →
SQL 2005 Build 3186 has a major negative side effect on x64 clusters. Installing it pretty much kills the SQL Agent.. The workaround is to enable unconstrained delegation for the machine and the service accounts.
Read more →
Well, yes. Actually you do. Patching a SQL Server cluster sounds like a complex endeavor, but it is really a lot simpler than people think. Much of the confusion is due to SQL 2000 and SQL 2005 having slightly different behaviors when it comes to patching.
Read more →
Clustering and SSIS have a stormy relationship at best. What you think you get after installing SQL and SSIS on a cluster is not always what you expected. For SQL 2000, the installer was cluster-aware on every component.
Read more →
Last week I stopped by the SQL Lounge at the PASS summit in Denver. I met a Microsoft employee named Max Verun, whose official title is Program Manager - Manageability and Servicing Platform.
Read more →