ISO File
Using .iso file. Right click on the file .iso and select the option to Mount, this will create a virtual DVD drive (Usually the E: drive). After the virtual drive has been created (mounted), you can use the drive to access the content.
In-Place Upgrade from SQL Server 2014 (12.x) to SQL Server 2019 (15.x)
Upgrade the existing instance to 2019 – specially for the other databases for other projects on the same server instance. You can upgrade instances of SQL Server 2012 (11.x), SQL Server 2014 (12.x), SQL Server 2016 (13.x), or SQL Server 2017 (14.x) directly to SQL Server 2019 (15.x). For SQL Server 2008, and SQL Server... » read more
How to Grant Permissions to run SQL Server Profiler for a non System Admin User
In order to run a trace against SQL Server you must be a member of sysadmin fixed server role or have the ALTER TRACE permission. Sources: https://www.mssqltips.com/sqlservertip/3559/how-to-grant-permissions-to-run-sql-server-profiler-for-a-non-system-admin-user/ https://learn.microsoft.com/en-us/sql/tools/sql-server-profiler/permissions-required-to-run-sql-server-profiler?view=sql-server-ver16
Always On Availability Group – Select Data Synchronization
Select “Automatic seeding” (default) if you have not created the database on the secondary replica and would like this wizard to create the database on the secondary replica based on the same setting as the primary replica. Use this option, if this is a small database. Select “Join only” if you already have already created... » read more
Upgrading SQL Server 2014 via Uninstall/Re-install
Process Detach databases. Uninstall SQL Server 2014 Install SQL Server 2016/2019 Reattach databases. Uninstall SQL Server 2014 (v12) To uninstall SQL Server instance, go to Control Panel and then Programs and Features. Select and right-click on Microsoft SQL Server 2014 and select Uninstall/remove. Upgrade to SQL Server 2016 (v13) SSMS Tool https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 Upgrade to SQL... » read more
SQL Server Transaction Log Backup Errors
Common Transaction Log Failure Erros Make sure all databases in transaction log job are marked as Full backup. Make sure there is at least one successfully full database backup. Disable transaction log backup job when running a full database backup job. Back up the log Under the full recovery model or bulk-logged recovery model, if... » read more
Cross Join
The CROSS JOIN joined every row from the first table (T1) with every row from the second table (T2). In other words, the cross join returns a Cartesian product of rows from both tables. In general, if the first table has n rows and the second table has m rows, the cross join will result in n... » read more