(Iggy Fernandez) The execution plans in the last post were interesting—especially the one in which the child table was counter-intuitively used as the lookup table during the antijoin. It just goes to show what a wealth of possibilities is available to the Oracle query optimizer.
Other News
MySQL 5.6 Transportable Tablespaces best practices
(Muhammad Irfan) In MySQL 5.6 Oracle introduced a Transportable Tablespace feature (copying tablespaces to another server) and Percona Server adopted it for partial backups which means you can now take individual database or table backups and your destination server can be a vanilla MySQL server.
ASP.NET MVC 5 with EF 6 – Working With Files
(Mike Brind) This tutorial explores how to upload files in an ASP.NET MVC application and how to use Entity Framework to store them in a database. It builds on a series of 12 featuring the fictitious Contoso University that teach you how to build MVC 5 applications using Entity Framework for data ac
Revisiting Partial View Rendering in ASP.NET MVC
(Dino Esposito) For any browser-based application, it makes sense to load into the web page just the content that is immediately required and avoid whole-page refreshes whenever possible. Ajax technology and JSON makes this partial-rendering easy. It is, however, worth considering ASP.NET’s own part
Multiselect, Filtering And Functions In Power Query
(Chris Webb) If you’re a Power Query enthusiast you’re probably already comfortable with creating functions and passing values to them. However in some scenarios you don’t want to pass just a single value to a parameter, you want to pass multiple values – for example if you are filtering a table by
5 Things You Didn’t Know About SQL Agent
(Thomas LaRock) Microsoft SQL Server comes with a boatload of additional components. One component is the SQL Agent service. The purpose of the SQL Agent is to serve as a job scheduler. Many experienced DBAs use jobs running inside the SQL Agent to perform routine tasks such as backups, updating sta
Using Power BI to access on-premise data
(James Serra) The following blog describes how to use certain cloud-based Power BI for Office 365 products (Power View and Q&A) on a Power BI Site that will reference data on-premises. To do this you will use certain on-premise Power BI products (Power Pivot and Power Query) to gather the data.
Sharpening Developer Productivity with ReSharper
(Ondrej Balas) Working in Visual Studio is already a fantastic experience, especially compared to many of the other development environments out there. But it can be even better.
Multiple Forms in VB.NET – Part 1
(Ged Mead) Back in 2003, when VB.NET first appeared, those of us trying to move from classic VB found we had a really steep learning curve to navigate. Of the many things that had us scratching our heads, one was how to work with multiple forms in Windows Forms projects, something that had changed
DB2 Tips n Tricks Part 56 – How to Force Query to use IXSCAN over a TBSCAN
(Harishkumar Baburao Pathangay) How to Force Query to use IXSCAN over a TBSCAN Solution: