Visual Studio 2015 Update 1 crash on install

Microsoft has released the Visual Studio Update 1
Source:

On my test machine I get the following error when I tried to start the Setup (on Windows Server 2008 R2):

Microsoft Visual Studio Community 2015 has stopped working

Problem Details

Description:

  Stopped working

Problem signature:

  Problem Event Name:                        CLR20r3

  Problem Signature 01:                       vs_community.exe

  Problem Signature 02:                       14.0.23107.156

  Problem Signature 03:                       55414f16

  Problem Signature 04:                       PresentationCore

  Problem Signature 05:                       3.0.0.0

  Problem Signature 06:                       4ef6cf9b

  Problem Signature 07:                       1f

  Problem Signature 08:                       28

  Problem Signature 09:                       Exception

  OS Version:                                          6.1.7601.2.1.0.274.10

  Locale ID:                                             2055

Solution

I need to install the .NET Framework 3.5. This seems to be a prerequisite for the setup.

OK, lets go to Servermanager and install the feature .NET Framework 3.5.1:

Features Wizard: Install .NET Framework 3.5.1

After Installation the setup for Visual Studio 2015 Update 1 works :)

MSSQL Snippet: Grösste SQL Tabelle finden

Das folgende SQL Skript zeigt die grössten Tabellen nach MB oder Rows

SELECT 
    t.NAME AS TableName,
    i.name as indexName,
    sum(p.rows) as RowCounts,
    sum(a.total_pages) as TotalPages, 
    sum(a.used_pages) as UsedPages, 
    sum(a.data_pages) as DataPages,
    (sum(a.total_pages) * 8) / 1024 as TotalSpaceMB, 
    (sum(a.used_pages) * 8) / 1024 as UsedSpaceMB, 
    (sum(a.data_pages) * 8) / 1024 as DataSpaceMB
FROM 
    sys.tables t
INNER JOIN      
    sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN 
    sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN 
    sys.allocation_units a ON p.partition_id = a.container_id
WHERE 
    t.NAME NOT LIKE 'dt%' AND
    i.OBJECT_ID > 255 AND   
    i.index_id <= 1
GROUP BY 
    t.NAME, i.object_id, i.index_id, i.name 
ORDER BY 
    object_name(i.object_id)

Sortiert nach Anzahl Rows:

ORDER BY RowCounts DESC

Sortiert nach Speicherplatz:

ORDER BY TotalSpaceMB DESC

Quelle:
http://stackoverflow.com/questions/2094436/how-to-find-largest-objects-in-a-sql-server-database

SQL Error: Object reference not set to an instance of an object

Problem

Beim Ausführen eines Maintenance Plans kommt es zur folgenden Fehlermeldung:














TITLE: Execute Maintenance Plan
------------------------------
Execution failed. See the maintenance plan and SQL Server Agent job history logs for details.
------------------------------

ADDITIONAL INFORMATION:
Object reference not set to an instance of an object. (Microsoft.SqlServer.SqlEnum)

Mögliche Lösung

Im Namen des Maintenance Plans wurde ein Sonderzeichen verwendet.

In meinem Fall "Backup & Wartung". Nach dem Entfernen des Und-Zeichen (&) funktionierte das Ausführen des Maintenance Plans korrekt.
Es empfiehlt sich also auf Sonderzeichen zu verzichten.