With CLUE as (Select * from Random_Thought ORDER BY Common_Sense DESC)

SQL Server thoughts, observations, and comments
posts - 52, comments - 79, trackbacks - 0


Development team, Product Support, Marketing, and anything else that originates from Mt. Doom Redmond.
SQL 2012 Licensing Thoughts

The only thing more controversial than new Federal Tax plans is new Licensing plans from Microsoft.  In both cases, everyone calculates several numbers.  First, will I pay more or less under this plan?  Second, will my competition pay more or less than now?  Third, will <insert interesting person/company here> pay more or less?  Not that items 2 and 3 are meaningful, that is just how people think. Much like tax plans, the devil is in the details, so lets see how this looks.  Microsoft shows it here: http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-licensing.aspx First up...

posted @ Thursday, November 03, 2011 12:34 PM | Feedback (6) | Filed Under [ SQL General Microsoft Denali ]

The first thing you will hate about SQL Denali…

OK, this is really the first thing “I” hate about SQL Denali, but I bet a fair number of you will hate this too. Once again, Microsoft has enforced the dictum that everyone must be either a Developer or an IT Pro. As Data Professionals, many of us have suffered as our employers can’t figure out where to hang us in the company Organization Chart, usually sticking us between Dev and Ops and letting the managers (and us) sort it out. This time, Microsoft has decided we are “Developers” and we shall get our help via the Web. Admittedly, Google...

posted @ Tuesday, July 12, 2011 4:29 PM | Feedback (6) | Filed Under [ SQL General Microsoft Denali ]

Clustering for Mere Mortals (Pt 3)

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. (1 GB RAM, 2 cores, 2 NICs, 128GB dynamically expanding VHD file).  I chose this because it had the smallest disk and memory footprint of any current supported Microsoft Server product.  I created the VM with a single dynamically expanding VHD, one fixed 16 GB VHD, and two NICs.  One NIC is connected to the outside world...

posted @ Wednesday, March 24, 2010 10:42 PM | Feedback (1) | Filed Under [ SQL General Hardware Microsoft High Availability ]

Clustering for Mere Mortals (Pt2)

Part 2 - Where I plan my Cluster.

posted @ Thursday, February 18, 2010 4:27 PM | Feedback (0) | Filed Under [ SQL General Microsoft High Availability ]

Successful Failure

Microsoft has successfully migrated its SQL Server support forums to a platform guaranteed to eliminate an estimated 20-30% of all corporate users.  By including the word "social" in the URL, most corporate firewalls will block access automatically.  Congratulations go to Microsoft for moving people off of their lowest cost support platform. http://social.msdn.microsoft.com/Forums/en-US/category/sqlserver/ Ready, Fire, Aim.      

posted @ Friday, December 12, 2008 3:07 PM | Feedback (0) | Filed Under [ Microsoft ]

PowerShell, Sport of the Future

No wait, that’s kickboxing.  PowerShell is the something of the future.  The management interface, the uber-scripting language, the what???      PowerShell, and its SQL-targeted implementation shipped with SQL Server 2008, brings to mind Michael Faraday’s response when asked “What use is electricity?”  He replied “What use is a newborn baby?”  PowerShell is somewhat of a newborn baby, much like the very early versions of SQL-based databases were.  We see how those databases have grown and transformed IT and business in ways we never thought of.  Maybe the future of PowerShell is just as bright? Enough philosophy, let’s see if we can put this...

posted @ Monday, September 29, 2008 12:20 PM | Feedback (1) | Filed Under [ SQL General Microsoft ]

More, More, More

Fast on the heels of SQL 2008 is the Feature Pack for SQL 2008.  Cool goodies include stand-alone installers for SQLCMD and the SQL Native Client,  SQL 2008 Server Management Objects, SQL 2008 pre-defined Policies, and lots more.  You can find it here. http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C  

posted @ Wednesday, August 13, 2008 1:45 PM | Feedback (0) | Filed Under [ SQL General Hardware Microsoft ]

Wait for it...

It looks like SQL 2008 may have a slight dependency issue.  If you have already installed Visual Studio 2008, you will be blocked from installing SQL 2008 until you install Visual Studio SP1.  The problem is that Visual Studio SP1 is not released yet.  Our guys came in ahead of schedule and they still get no respect. Not to worry, Visual Studio 2008 SP1 should be out very soon (think days, not weeks) and this problem goes away. Microsoft actually documented this issue here: Visual Studio 2008 SP1 may be required for SQL 2008 Installations http://support.microsoft.com/kb/956139 --GNH UPDATE:  It's Here http://www.microsoft.com/downloads/details.aspx?FamilyId=FBEE1648-7106-44A7-9649-6D9F6D58056E&displaylang=en

posted @ Thursday, August 07, 2008 1:09 PM | Feedback (1) | Filed Under [ SQL General Microsoft Low Availability ]


SQL 2008 is finished.  MSDN has all the bits downloadable now.  Expect retail versions shortly.

posted @ Wednesday, August 06, 2008 2:06 PM | Feedback (0) | Filed Under [ SQL General Microsoft ]

Update: SQL 2005 Build 3186 Cluster problem

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.  Microsoft is not 100% sure yet, so this is just a preliminary finding.  However, it does match my own personal experiences.  Worst Practices always has a cost.  Several DBAs just found that out the hard way.  Just as a reminder, this problem only occurs on x64 clusters using SQL Server 2005 build 3186 and higher.

posted @ Monday, November 12, 2007 4:09 PM | Feedback (0) | Filed Under [ Microsoft High Availability Low Availability ]

Full Microsoft Archive

Powered by:
Powered By Subtext Powered By ASP.NET