-
Database Accidents : Unwanted Restore
Number of times, while working as a DBA many accidents happen. Most common of them is when a database is restored without checking if a backup is available or not. As a thumb rule – a DBA must take backups of everything before performing any action. At any point of time, I must be in…
-
Fragmentation of Log files and VLFs
In a SQL server, having multiple log files does not have any performance benefits as the log files are written sequentially. The log files can have external (disk level) fragmentation or internal (VLF, Virtual Log File) fragmentation. The external fragmentation can be solved by de-fragmenting the disk on which the log file resides on, followed…
-
What is SlipstreamMediaInfoCheck?
Checks whether the language of the original media is the same language as the specified service pack.
-
What is RS_IsDotNet3_5Installed?
This rule determines if the Microsoft .NET Framework 3.5 Service Pack 1 is required on the system, based on the features you selected and whether Microsoft .NET Framework 3.5 Service Pack 1 is already installed.
-
What is DEV10RTMDetected?
This rule determines whether the computer has any prior installations of Visual Studio 2010 that might require Service Pack 1 update.
-
What is ServerCoreNetFxCheck?
Checks if The Microsoft .NET Framework 4 Server Core is already installed on this computer or is available for installation.
-
What is ServerCoreBlockUnsupportedFeaturesCheck?
Checks if all selected features are supported on Windows Server Core.
-
What is PowerShellCheck?
Checks whether Windows PowerShell 2.0 is already installed on system. Windows PowerShell is needed by some SQL Server features.
-
What is InternetConnectionToNETFX4DownloadSite?
SQL Server media for Express packages does not include Microsoft .NET Framework 4.0 package. If Microsoft .NET Framework 4.0 is not already installed on the computer, SQL Server setup for the Express packages requires connection to Microsoft .NET Framework 4.0 dowload center to download and install .NET 4.0 Framework through Web setup. Ensure internet connection…
-
What is DotNet35OrInternetConnectionCheck?
If you are installing SQL Server on Windows 8 or higher version of Windows, Microsoft .NET Framework 3.5 might not be installed by default. In order to ensure successful installation of all SQL Server features that require Microsoft .NET Framework 3.5, confirm that Microsoft .NET Framework 3.5 is installed or enabled prior to running SQL…
-
What is ASSPIInstanceNameNotInUseCheck?
Checks for the required instance name.
-
What is ASIsValidEditionForDeploymentModeCheck?
Checks whether the SQL Server edition supports the currently selected Analysis Services server mode.
-
What is SSMS_IsInternetConnected?
Verifies that the computer is connected to the Internet. When a Microsoft .NET application like Microsoft Management Studio starts, there maybe be a slight delay while the .NET security check validates a certificate.
-
What is IsFirewallEnabled?
Checks whether the Windows Firewall is enabled.
-
What is FusionRebootCheck?
Checks if a computer restart is required because of broken fusion ATL. A pending restart can cause SQL Server Setup to fail.