SQL Server – v2019 / Java JDK – Binaries

Background Thankfully, with SQL Server version 2019, Microsoft bundles a Java JDK. Lineage Past In the past one will go to the Oracle Web Site and download a Java JDK. Once downloaded the JDK will be installed. To ensure that SQL Server installation is aware of the install, one needs to restart the SQL Server … Continue reading SQL Server – v2019 / Java JDK – Binaries

SQL Server – 2019 – Developer Edition – Installation Media

Background Microsoft SQL Server Developer Edition is free for non-production use.   Explore Let us touch on where to get our hands on the install media/ISO. Media Microsoft SQL Server Downloads URL Link Microsoft | Visual Studio Subscriptions URL Link   Review Media Availability Microsoft | Visual Studio Subscriptions Outline Go to Visual Studio Subscriptions … Continue reading SQL Server – 2019 – Developer Edition – Installation Media

DBeaver :- Generate Schema – Datatypes and Column Widths – Error – “Cannot specify a column width on data type”

Background Let us stay with Dbeaver and point out a slightly different issue.   Sample Data SQL Server DDL DDL - Create Schema and Table DBeaver Launched Dbeaver and worked towards scripting the object's DDL. Outline Here are the steps :- Connect to the Database Transverse the Database Navigator outline and select Instance\Database\Schema\Tables Select the … Continue reading DBeaver :- Generate Schema – Datatypes and Column Widths – Error – “Cannot specify a column width on data type”

DBeaver :- Export Data – Timestamp / SQL Server – Error – “Cannot insert an explicit value into a timestamp column”

Background Reviewing a system and wanted to get the data from one of it's table and copy it into a new system. Sample Data SQL Server DDL DDL - Create Schema and Table DML DML - Add Data to Table Microsoft SQL Server Management Studio ( SSMS ) SQL Server's Management Studio capably manages such … Continue reading DBeaver :- Export Data – Timestamp / SQL Server – Error – “Cannot insert an explicit value into a timestamp column”

SSMS – AWS/RDS – Error – “The EXECUTE permission was denied on the object ‘xp_regread'”

Background When SQL Server Management Studio ( SSMS ) is ran against an Amazon/RDS SQL Server instance, we can get a little error. Error The error reads :- Error Message Image Text Error Message - Advanced Information Image Text Explanation Looking at the Stack Trace the error occurs at :- Microsoft.SqlServer.Management.Smo.Agent.JobServer.get_MsxServerName() TroubleShooting What is the … Continue reading SSMS – AWS/RDS – Error – “The EXECUTE permission was denied on the object ‘xp_regread'”

SQL Server – Visual C++ Runtimes

Background When a program is compiled using Microsoft Visual Studio .Net, it sometimes relies on Microsoft Visual C++ Runtime. SQL Server Some of Microsoft's SQL Server is written in C and C++ and compiled with Visual Studio .Net. In the table below, we list the corresponding Visual C++ Runtime for each of Version of SQL … Continue reading SQL Server – Visual C++ Runtimes

SQL Server – v2017 – Installation Error -“VS Shell installation has failed with exit code 1638.”

Background Trying to install Microsoft SQL Server v2017, but ran into a blocking error. Error Error - VS Shell installation has failed with exit code 1638 Error Text Install_VCRuntime140_Cpu32_Action VS Shell installation has failed with exit code 1638. Error Image TroubleShooting The status indicates that the current step is "Install_VCRuntime140_Cpu32_Action". Remediation Outline Exit SQL Server … Continue reading SQL Server – v2017 – Installation Error -“VS Shell installation has failed with exit code 1638.”