(Bobby Durrett) Last week I was asked to help with a performance problem that looked a lot like a problem I fixed in July with a SQL Profile.
Other News
Why do I (they) own that database?
(Kenneth Fisher) Ever looked at the list of databases and wonder why you own one of them? Or why some other user owns the database? Just to be clear, by owner I mean the one and only actual owner of the database, not just a member of the db_owner role.
JAX-WS Change Endpoint Example
(Gilbert Lopez) In this example, we will demonstrate how to change the service endpoint in a Java web service client application.
Projecting Content Into The Root Application Component Using Slots In Vue.js 2.6.6
(Ben Nadel) In almost every Vue.js demo that I’ve looked at, the root Vue() instance is created with an “el” property and a render() function that does nothing but render the “App” component.
March Spotlight – Db2 Developer C
(Martin Hubel) If you are a serious Db2 user, chances are you have downloaded and used free Db2 versions for a few years.
Reduced recompilations for workloads using temporary tables across multiple scopes
(Joseph Sack) SQL Server 2019 introduces several performance optimizations which will improve performance with minimal changes required to your application code.
Undocumented SQL Server 2017 oledb stored procedures
Undocumented SQL Server 2017 oledb stored procedures SQL Server 2017 supports the following useful undocumented oledb stored procedures: sp_oledb_language sp_oledb_ro_usrname sp_oledb_database sp_oledb_defdb sp_oledb_deflang sp_oledb_language The sp_oledb_language database engine stored procedure returns the official language name and alternative language name for each language presents in the instance of SQL Server 2017. Syntax sp_oledb_language Return Code Values None. Result Sets Column name...
Reverse Engineering EF Core Model And Data Validation Techniques
(Bipin Joshi) While working with ASP.NET Core and Entity Framework Core you need to create data model for your application.
MySQL 8.0.14 Replication Enhancements
(Luis Soares) MySQL 8.0.14 is out and it contains some new and very interesting replication enhancements. As always, we are very pleased to share with you the details about the exciting new features in this release.
Returning Files from .NET Core or ASP.NET MVC Controllers
(Peter Vogel) In ASP.NET MVC, the File helper method built into your controller gives you multiple options for retrieving the file you want to send to the client.