(a minor) Open Letter to NVidia, from one Developer to another..

Hey, just a quick easy request from a simple Developer: Please make your video card driver installers’ default to use the Temp environment path variables I have configured on my computers.

Please? Other than installing the telemetry without asking, you’re doing great on keeping our systems updated!

My C: (system) SSD disk is reserved for the Windows 10 Operating System.. not temp files.

ūüôā

Advertisements

SQL Server Management Studio – Changelog (version 17.5)

Download SSMS 17.5!¬† (If this link doesn’t work, please let me know.)

Here is Microsoft’s changelog for build number 14.0.17224.0,

What’s new

Data Discovery & Classification:

  • Added a new SQL Data Discovery & Classification feature for discovering, classifying, labeling & reporting sensitive data in your databases.
  • Auto-discovering and classifying your most sensitive data (business, financial, healthcare, PII, etc.) can play a pivotal role in your organizational information protection stature.
  • Learn more at¬†SQL Data Discovery & Classification.

Query Editor:

  • Added support for SkipRows option to the Delimited Text External File Format for Azure SQL DW. This capability allows users to skip a specified number of rows when loading delimited text files into SQL DW. Also added the corresponding intellisense/SMO support for the FIRST_ROW keyword.

Showplan:

Bug fixes

Showplan:

  • Fixed Live Query Statistics elapsed time, to show engine execution time instead of time elapsed for LQS connection.
  • Fixed an issue where showplan was not able to recognize Apply logical operators like GbApply and InnerApply.
  • Fixed an issue related to ExchangeSpill.

Query Editor:

  • Fixed on issue related to SPIDs where SSMS could throw an error like “Input string was not in a correct format. (mscorlib)” when executing a simple query preceded by a “SET SHOWPLAN_ALL ON”.

SMO:

  • Fixed an issue where SMO was not able to fetch AvailabilityReplica properties in case the server collation happened to be case-sensitive (as a result, SSMS could display an error message like “The multi-part identifier “a.delimited” could not be bound.”
  • Fixed an issue in DatabaseScopedConfigurationCollection class, where incorrectly handling collations (as a result, an SSMS running on an ma machine with a Turkish locale could display an error like “legacy cardinality estimation is not valid scoped configuration” when right clicking on a database running on a server with a case-sensitive collation).
  • Fixed an issue in JobServer class, where SMO was not able to fetch SQL Agent properties on a SQL 2005 server (as a result, SSMS was throwing an error like “Cannot assign a default value to a local variable. Must declare the scalar variable “@ServiceStartMode” and, ultimately, was not displaying the SQL Agent node in Object Explorer).

Templates:

Object Explorer:

Auditing:

  • Fixed an issue with the¬†Merge Audit Files¬†feature.

Known issues

Data classification:

  • Removing a classification and then manually adding a new classification for the same column results in the old information type and sensitivity label being assigned to the column in the main view.
    Workaround: Assign the new information type and sensitivity label after the classification was added back to the main view and before saving.

Google Chrome: Fix to remove all ‘Other Search Engines’.

Found via Google Chrome: Remove all ‘Other Search Engines’ – Super User.

Finally! I’m so tired of every little site I visit adding baggage into my Chrome browser.
There really should be an option to add a site, WHEN I DESIRE TO DO SO.

Freakin’ chrome design team. Grr.

Meanwhile, there is a chrome extension that is supposed to block these silent custom search engine additions: “Don’t add custom search engines“.

Here’s to hoping it works!

C# Dependency Injection via /r/csharp

via Trying to understand something about Dependency Injection : csharp

User badlife says this:

DI is a lot deeper than you’re thinking. It’s an entirely different way of doing architecture. Here’s a simple example:

Without DI:

  • I’m a component. I need X to do some work. So I’ll create an instance of X and use it. I don’t want Y, or something that looks like X but behaves differently– I want an instance of X and only X.

With DI:

  • I’m a component. I need an instance of X to do some work
    • I’m not going to create an instance of X– I’ll let you give me one when you create me
    • I don’t care if X is really X, as long as it¬†looks¬†like X.
    • I don’t want Y, but if Y pretends to be X, I’ll never know. This is because I only want something that¬†lookslike X.

Here’s an example in concrete terms:

  • The ‘component’ is something that does a calculation. As part of the calculation, it needs to call a web service to get a value (let’s say an interest rate)
  • X is usually a component that calls a web service to get the interest rate
  • Y is a testing component that just returns ‘1.0’ for the interest rate

Without DI, the component is very hard to test because it needs to call a ‘live’ web service to get an interest rate. What if that web service isn’t live? What if it isn’t accessible from the testing environment? The test could be running as part of a build, and the build server might not be able to see the web service.

With DI, both X and Y can implement a common interface. The component doesn’t actually create an instance of X– it just asks for a reference to the interface. So in a real world scenario, the system gives the component a ‘real’ instance of X by¬†passing a reference to its interface. In a testing scenario, the system gives the component a ‘fake’ version of X (it’s actually Y!) also by¬†passing a reference to its interface. The component doesn’t know or care about the internal implementation of what it thinks is X, and can do its work without the web service being available.