Microsoft Visual C++ – Compiling for 64-bit

Background As I tried to run our little ODBC application noticed that we have not created the targeted ODBC Data Source. Error Error Image Error Text Remediation Created the datasource and as I thought more, opted to consider 64-bit platforms, as well Target - x64 Objective Let us compile our application and target 64-bit bitness. … Continue reading Microsoft Visual C++ – Compiling for 64-bit

SQL Server – Integration Services – Error – “Failed To Compile Scripts Found In Package”

Background Ran into an error trying to run an "Integration Services" package. Error Error Image Error Text CS2001 - Source file 'C:\Windows\TEMP\.NETFramework,Version=v4.5.AssemblyAttributes.cs' could not be found, CSC, 0, 0 Create JobID:Error: Failed to compiled scripts contained in the package. Open the package in SSIS Designer and resolve the compilation errors. Create JobID:Error: The binary code … Continue reading SQL Server – Integration Services – Error – “Failed To Compile Scripts Found In Package”

SSMS – v2008 – Error – “Index was outside the bounds of the array. (Microsoft.SqlServer.Smo)”

Background Drew a quick error running Sql Server Management Studio (SSMS). Error Text The error reads :- Index was outside the bounds of the array. (Microsoft.SqlServer.Smo) Image Explanation Error reads Microsoft.SqlServer.Smo Index was outside the bounds of the array Recreate Tried connecting to Microsoft SQL Server v2017 instance with Sql Server Management Studio v2008.   … Continue reading SSMS – v2008 – Error – “Index was outside the bounds of the array. (Microsoft.SqlServer.Smo)”

SQL Server – v2017 – Install – “Oracle JRE 7 Update 51 (64-bit) is required for Polybase”

Background Installing SQL Server v2017 and ran into an error that I have seen before. Error Error Image Error Textual Oracle JRE 7 Update 51 (64-bit) or higher is required for Polybase Tackled Before History Already tackled before here: SQL Server (v2016) – Installation – Blocked – "Oracle JRE 7 Update 51 (64-bit) or higher … Continue reading SQL Server – v2017 – Install – “Oracle JRE 7 Update 51 (64-bit) is required for Polybase”

DataStore.edb

Background An alarm was raised by our monitoring software. An alarm is raised whenever a drive free space falls below 10%. Combed the drive using SpaceSniffer and found out that the DataStore.edb file on C:\Windows\SoftwareDistribution\DataStore is larger than usual.   Image Here it is clocking in at 1.3 GB   TroubleShooting SysInternals Process Monitor Overview … Continue reading DataStore.edb

SQL Server – Files In use – Day 1

Background One of the many areas that that one needs to keep an eye one when monitoring database engines  is which files are opened, how they are opened ( exclusively, read only), what other processes are competing for them, etc. Day 1 This is Day 1 and so we will start off with the basic … Continue reading SQL Server – Files In use – Day 1