Microsoft Ignite New Zealand 2016 Highlights and Session Downloader

Microsoft Ignite New Zealand 2016 Highlights and Session Downloader

Thanks to my employer Equinox Limited , I was able to attend my 5th Microsoft Ignite 2016 (previously known as Microsoft TechEd) conference up here in Auckland. Every TechEd / Ignite conference that I have attended had some unique flavour it dished out to all of its delegates every year, and this year was no exception, but deep down I felt there was something missing. Don’t get me wrong here, the “missing” part was not a bad thing, it was rather the new focus or vision that Microsoft today wants its consumers, partners to embrace. Let me explain. (more…)

SQL Server 2008 R2 Service Pack 1

…. And it’s finally available for Download. Actually it’s been pretty exciting couple of weeks , SharePoint 2010 Service Pack1 and now SQL 2008 R2 SP1 .

Download Links for Service Pack for SQL are available here http://www.microsoft.com/download/en/details.aspx?id=26727&utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+MicrosoftDownloadCenter+%28Microsoft+Download+Center%29

The KB article might be your preferred first place of hunting for Bugs or issues you might have been facing and to check if they have been rectified or addressed http://support.microsoft.com/kb/2463333

So our playground for this post is

  1. Windows 2008 R2 Sp1
  2. SQL 2008 R2

 

Before You Install Service Pack 1

For a list of the bugs that are fixed in SQL Server 2008 R2 Service Pack 1, see the master KB article.

Recommended Disk Space Requirements to Download, Extract, and Install SQL Server 2008 R2 Service Pack 1

The recommended disk space requirements to download, extract, and install SP1 are approximately 2.5 times the size of the specific package.

The SQL Server Service Cannot Start after You Uninstall SP1 for SQL Server 2008 R2 if a UCP Exists in the Instance of SQL Server

Symptoms

Consider the following scenario:

  • You have an instance of Microsoft SQL Server 2008 R2 that hosts a utility control point (UCP).
  • You have installed SP1 for SQL Server 2008 R2 on the instance and later decide to uninstall it.

In this scenario, the uninstall action succeeds. However, the SQL Server service cannot start.

Cause

This problem occurs because the Agent XPs option is not enabled when SQL Server 2008 R2 runs the upgrade script for the msdb database.

The upgrade script runs when the SQL Server service starts. The script runs a stored procedure that is related to the UCP. The stored procedure requires that the Agent XPs option be enabled.

Resolution

If you experience this behaviour after removing SP1, follow these steps to work around the problem. To avoid the problem, perform these steps before removing SP1.

1) If SQL Server is running, stop the SQL Server service.

2) Enable trace flag 902 on the instance of SQL Server 2008 R2. To do this, follow these steps:

  • Open SQL Server Configuration Manager.
  • In SQL Server Configuration Manager, click SQL Server Services.
  • Double-click the SQL Server service.
  • In the SQL Server Properties dialog box, click the advanced tab.
  • On the Advanced tab, locate the Startup Parameters item.
  • Add ;–T902 to the end of the existing string value, and then click OK.

3) Right-click the SQL Server service, and then click Start.

4) If the SQL Server Agent service is running, right-click the SQL Server Agent service, and then click Stop. Set the Agent service start mode to Manual.

5) Open SQL Server Management Studio, and then connect to the instance of SQL Server 2008 R2.

6) Run the following statements:

EXEC sp_configure ‘show advanced’, 1;
RECONFIGURE;
EXEC sp_configure ‘allow updates’, 0;
RECONFIGURE;
EXEC sp_configure ‘Agent XPs’, 1;
RECONFIGURE;
GO

7) Modify the extended property of the sysutility_mdw database back to the SQL Server 2008 R2 version. To do this, follow these steps:

  • In SQL Server Management Studio, right-click the sysutility_mdw database and then click Properties.
  • In the property dialog box, click Extended Properties.
  • Update the value to 10.50.1600.1 for the “Microsoft_DataCollector_MDW_Version” property.

8) If you have not yet uninstalled the service pack, uninstall it now. If you have already uninstalled it, continue to step 9.

9) In SQL Server Configuration Manager, right-click the SQL Server service, and then click Stop.

10) Remove trace flag 902 on the instance of SQL Server 2008 R2. To do this, delete ;–T902 from the string value that you updated in step 2.

11) Right-click the SQL Server service, and then click Start.

12) Right-click the SQL Server Agent service, view properties, and set the service start mode back to its original value. Then click Start to start the Agent service.

13) In SQL Server Management Studio, reconnect to the instance of SQL Server 2008 R2.

14) In Object Explorer, expand Management, right-click Data Collection, and then click Enable Data Collection.

Note: If data collection is already enabled, the Enable Data Collection item is unavailable.

 

Download Size

 

Installing SP1













Updating Management Studio






And then continue the installation to update your SQL Management Studio. If you have applied SP1 earlier you wouldn’t need to run the Update SQL Management Studio after that.

SQL 2008 R2 SP1.

As always do this several times within a TEST ENVIRONMENT before trying it anywhere closer than 2km’s from your Production Datacentre J

Cheers

Quick Uninstallation of .net 4

Quick Uninstallation of .net 4

I have been coming across a lot of clients, who provide fresh Vanilla Windows 2008, Windows 2008 R2 servers with .net 4 installed. Unfortunately this could lead to issues with MOSS and SharePoint 2010 installations.

You can use the following commands to get rid of them
.NET Framework 4 product family


Below are various options of uninstalling .net 4 from your server. Find the option that best suits you and copy the two associated lines of code and save them as a batch file. Once done execute that batch file.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
.NET Framework 4 Client Profile (32-bit) – silent repair
%windir%\Microsoft.NET\Framework\v4.0.30319\SetupCache\Client\setup.exe /repair /x86 /x64 /ia64 /parameterfolder Client /q /norestart

.NET Framework 4 Client Profile (32-bit) – unattended repair

%windir%\Microsoft.NET\Framework\v4.0.30319\SetupCache\Client\setup.exe /repair /x86 /x64 /ia64 /parameterfolder Client /passive/norestart

.NET Framework 4 Client Profile (32-bit) – silent uninstall

%windir%\Microsoft.NET\Framework\v4.0.30319\SetupCache\Client\setup.exe /uninstall /x86 /x64 /parameterfolder Client /q /norestart

.NET Framework 4 Client Profile (32-bit) – unattended uninstall

%windir%\Microsoft.NET\Framework\v4.0.30319\SetupCache\Client\setup.exe /uninstall /x86 /x64 /parameterfolder Client /passive /norestart

.NET Framework 4 Client Profile (64-bit) – silent repair

%windir%\Microsoft.NET\Framework64\v4.0.30319\SetupCache\Client\setup.exe /repair /x86 /x64 /ia64 /parameterfolder Client /q /norestart

.NET Framework 4 Client Profile (64-bit) – unattended repair

%windir%\Microsoft.NET\Framework64\v4.0.30319\SetupCache\Client\setup.exe /repair /x86 /x64 /ia64 /parameterfolder Client /passive /norestart

.NET Framework 4 Client Profile (64-bit) – silent uninstall

%windir%\Microsoft.NET\Framework64\v4.0.30319\SetupCache\Client\setup.exe /uninstall /x86 /x64 /parameterfolder Client /q /norestart

.NET Framework 4 Client Profile (64-bit) – unattended uninstall

%windir%\Microsoft.NET\Framework64\v4.0.30319\SetupCache\Client\setup.exe /uninstall /x86 /x64 /parameterfolder Client /passive /norestart

.NET Framework 4 Full (32-bit) – silent repair

%windir%\Microsoft.NET\Framework\v4.0.30319\SetupCache\Client\setup.exe /repair /x86 /x64 /ia64 /parameterfolder Client /q /norestart

.NET Framework 4 Full (32-bit) – unattended repair

%windir%\Microsoft.NET\Framework\v4.0.30319\SetupCache\Client\setup.exe /repair /x86 /x64 /ia64 /parameterfolder Client /passive /norestart

.NET Framework 4 Full (32-bit) – silent uninstall

%windir%\Microsoft.NET\Framework\v4.0.30319\SetupCache\Extended\setup.exe /uninstall /x86 /x64 /ia64 /parameterfolder Extended /q /norestart

%windir%\Microsoft.NET\Framework\v4.0.30319\SetupCache\Client\setup.exe /uninstall /x86 /x64 /parameterfolder Client /q /norestart

.NET Framework 4 Full (32-bit) – unattended uninstall

%windir%\Microsoft.NET\Framework\v4.0.30319\SetupCache\Extended\setup.exe /uninstall /x86 /x64 /ia64 /parameterfolder Extended /passive /norestart

%windir%\Microsoft.NET\Framework\v4.0.30319\SetupCache\Client\setup.exe /uninstall /x86 /x64 /parameterfolder Client /passive /norestart

.NET Framework 4 Full (64-bit) – silent repair

%windir%\Microsoft.NET\Framework64\v4.0.30319\SetupCache\Client\setup.exe /repair /x86 /x64 /ia64 /parameterfolder Client /q /norestart

.NET Framework 4 Full (64-bit) – unattended repair

%windir%\Microsoft.NET\Framework64\v4.0.30319\SetupCache\Client\setup.exe /repair /x86 /x64 /ia64 /parameterfolder Client /passive /norestart

.NET Framework 4 Full (64-bit) – silent uninstall

%windir%\Microsoft.NET\Framework64\v4.0.30319\SetupCache\Extended\setup.exe /uninstall /x86 /x64 /ia64 /parameterfolder Extended /q /norestart

%windir%\Microsoft.NET\Framework64\v4.0.30319\SetupCache\Client\setup.exe /uninstall /x86 /x64 /parameterfolder Client /q

.NET Framework 4 Full (64-bit) – unattended uninstall

%windir%\Microsoft.NET\Framework64\v4.0.30319\SetupCache\Extended\setup.exe /uninstall /x86 /x64 /ia64 /parameterfolder Extended /passive /norestart

%windir%\Microsoft.NET\Framework64\v4.0.30319\SetupCache\Client\setup.exe /uninstall /x86 /x64 /parameterfolder Client /passive /norestart