Microsoft SPLA

Thursday, December 1, 2011

As a SaaS provider, we utilize the Microsoft Services Provider License Agreement (SPLA).  Adding this electronic note for future reference.

SPLA “is for organizations that want to offer hosted software and services to end customers, such as Web hosting, hosted applications, messaging, collaboration, and platform infrastructure.

Hosting providers who want to offer software services to their customers and who will include software licenses as part of their service offering should use SPLA. Microsoft SPLA is the only Microsoft Volume Licensing program that allows Microsoft products to be used for commercial hosting.”


MSDN Explained

Wednesday, November 9, 2011

While attempting to take the time to understand MSDN licensing, I found a blog titled “What is an MSDN Subscription… Really?”  I found the information to be helpful in comprehending an MSDN subscription.

The development teams use Visual Studio along with a server OS, SharePoint, and/or SQL Server.  Visual Studio Premium with MSDN satisfies this requirement.

Found a helpful comparison chart for Visual Studio 2010.


SQL Server Script – Size of all tables in a database

Monday, October 10, 2011

While researching information regarding vCenter database retention policy, I stumbled upon this SQL script which displays the number of rows and the physical size of all tables in a specified database.


Capacity Specs for SQL Server

Tuesday, September 27, 2011

Recently referenced the Maximum Capacity Specifications for SQL Server information.  The link provides information for SQL Server 2008 R2, 2008, 2005, and Denali.


SQL Server Versions

Wednesday, September 7, 2011

Update 27-Oct-2011

Found more recent build information on SQLSecurity.com and sqlserverbuilds.blogspot.com.

********************************************

Found this helpful information regarding SQL Server versions and service packs from Bill Graziano on SQLTeam.com.  Posting the SQL Server 2008 R2 information for my future reference, however Bill lists this and prior SQL server versions as well.

SQL Server 2008 R2
10.50.1765.0 SQL Server 2008 R2 CU6 21 Feb 2011
10.50.1753.0 SQL Server 2008 R2 CU5 20 Dec 2010
10.50.1746.0 SQL Server 2008 R2 CU4 18 Oct 2010
10.50.1734.0 SQL Server 2008 R2 CU3 17 Aug 2010
10.50.1720.0 SQL Server 2008 R2 CU2 25 Jun 2010
10.50.1702.0 SQL Server 2008 R2 CU1 18 May 2010
10.50.1600.1 SQL Server 2008 R2 RTM 12 Apr 2010

Windows OS Versions

Thursday, September 1, 2011

Recently been referring to this information in the MSDN library.  Decided to post in my blog for easy reference in the future.

Operating system Version number
Windows 7 6.1
Windows Server 2008 R2 6.1
Windows Server 2008 6.0
Windows Vista 6.0
Windows Server 2003 R2 5.2
Windows Server 2003 5.2
Windows XP 64-Bit Edition 5.2
Windows XP 5.1
Windows 2000 5.0

Database Crash with Tablespace in Hot Backup

Monday, June 6, 2011

I encountered this problem twice before a few years ago and most recently last week.  Adding this to my notes when it happens again a few years from now.

Snippet from alert log showing database crashed.

Fri May 27 19:07:27 Eastern Daylight Time 2011
Errors in file i:\oradba\admin\pd102\bdump\pd102_pmon_1464.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [kksCursorFreeCallBack+112] [PC:0x71E70C] [ADDR:0x68] [UNABLE_TO_READ] []

Fri May 27 19:07:45 Eastern Daylight Time 2011
LGWR: terminating instance due to error 472
Fri May 27 19:07:59 Eastern Daylight Time 2011
Instance terminated by LGWR, pid = 1508

Login to restart the database.

> sqlplus "sys as sysdba"

SQL*Plus: Release 10.2.0.5.0 - Production on Fri May 27 20:52:14 2011

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Enter password:
Connected to an idle instance.

SQL> startup;
ORACLE instance started.

Total System Global Area 1157627904 bytes
Fixed Size                  2077040 bytes
Variable Size             201330320 bytes
Database Buffers          939524096 bytes
Redo Buffers               14696448 bytes
Database mounted.

ORA-01113: file 8 needs media recovery if it was restored from backup, or END BACKUP if it was not
ORA-01110: data file 8: 'I:\ORADATA\PD102\TMF43WT.DBF'

I reviewed the alert log and was able to determine the data file specified was in backup mode when the database terminated.  Following the instructions in Oracle Support Doc ID 183367.1, I executed the commands below to resolve the problem.

SQL> alter database datafile 'I:\ORADATA\PD102\TMF43WT.DBF' end backup;

Database altered.

SQL> alter database open;

Database altered.

References
Common Causes and Solutions on ORA-1113 Error Found in Backup & Recovery (Doc ID 183367.1)

AT STARTUP AFTER CRASH WITH TABLESPACE(S) IN HOT BACKUP *******************************************************
1. Mount the database.

   SQL> STARTUP MOUNT;

2. Find out which datafiles were in hot backup mode when the database crashed or was shutdown abort or the machine was rebooted by running the query:

   SQL> SELECT V1.FILE#, NAME
FROM V$BACKUP V1, V$DATAFILE V2
WHERE V1.STATUS = 'ACTIVE' AND V1.FILE# = V2.FILE#;

3. For each of the files returned by the above query, issue the command:

   SQL> ALTER DATABASE DATAFILE '<full path name>' END BACKUP;

4. Open the database.

   SQL> ALTER DATABASE OPEN;


Follow

Get every new post delivered to your Inbox.