(Nenad Noveljic) I asked the question on Oracle-L to learn about the use cases where people prefer database JVM to PL/SQL. One reason that appeared was better performance when writing BLOBs to files.
Editorials
Bridges Between Servers
February 12, 2020Many times as you build out environments, you’re left pulling information from different SQL Servers and different sources, so you can assemble [...]Upgrades, Tuning and SQL Server
February 11, 2020One of the areas that is coming up more and more frequently with the ability to move from version to version of SQL Server pretty fluidly with the [...]
Complexities of "It Just Works"
January 17, 2020There is a lot of talk about technical debt – that thing where systems have been allowed to run because, well, they work. Why poke a sleeping [...]
- Selecting a Data Platform
- Data Drift, Data Maturation and Working With It
- Data Protection on Your (and Your User’s) Travel Times
SQL Server
How Do I Change an Employee’s Attitude About Work-Hours?
February 14, 2020Hello, this is Laura Lee Rose – author of the business and time management books TimePeace: Making peace with time – The Book of Answers: 105 [...]Bridges Between Servers
February 12, 2020Many times as you build out environments, you’re left pulling information from different SQL Servers and different sources, so you can assemble [...]Tips for using full-text search in SQL Server 2019
February 12, 2020Tips for using full-text search in SQL Server 2019 Make full-text index population during periods of low database access. Because full-text index [...]
- Upgrades, Tuning and SQL Server
- How Do I Leave A Company When It Seems Like The Company Will Crumble When I Leave?
- Tips for using tempdb database in SQL Server 2019
Other News
Quick hack for GTID_OWN lack
(Shlomi Noach) One of the benefits of MySQL GTIDs is that each server remembers all GTID entries ever executed.
Download And Upload Google Drive Files In ASP.NET Core
(Bipin Joshi) In the previous article we displayed a list of files from Google Drive. By now you know how to configure a Google API project and establish a connection with your Google drive. In this part you will build on top of what you learned in the previous part.
Advanced usage of gdb for profiling
(Frits Hoogland) This post is about how to use gdb, which is a debugger, so very simplistically put an aid for looking at C programs, as a profiler. I use gdb quite a lot for profiling because it’s the easiest way for profiling for me.
Server Side Pagination Using ASP.NET Core And Angular 8
(Siddharth Gajbhiye) In this article, we will learn how to create server side paging which is very useful whenever we have to display large number of records.
Learn SQL: Foreign Key
(Emil Drkusic) In the previous article, we talked about the primary key (PK). In this one, we’ll check what is the foreign key (FK) and how it’s related to the primary key. This is the final step, after creating tables, inserting data, and defining primary keys, to cover all basics related to the da
Letting the Client Control Data Retrieval with GraphQL in .ASP.NET Core
(Peter Vogel) GraphQL lets you create data access services without writing controllers. Instead of writing procedural code, you declare schemas describing what queries you’ll accept and what you’re willing to return. Here’s how to get started in ASP.NET Core.
DB2 for z/OS Locking for Application Developers Part 1
(Gareth Copplestone-Jones) This DB2 for z/OS Locking blog series is mostly targeted at DB2 for z/OS application developers, but is also appropriate for application designers, database administrators, DB2 systems programmers and other DB2 professionals who are concerned with data integrity and applic
Using A File Upload Or The Request Body To Overcome The Slow Processing Of A Large Form POST In Lucee CFML 5.3.3.62
(Ben Nadel) Yesterday, I demonstrated that Lucee CFML appears to incur a request-cloning cost when spawning CFThread tags. In most circumstances, this cost is negligible.
Permissions required for row counts to show up on Object Explorer Details
(Kenneth Fisher) I ran into a rather obscure permissions problem the other day. Since I wasn’t able to figure it out on my own I posted for help. This wasn’t something I felt could be easily translated into #sqlhelp so I went ahead and posted it on Stack Exchange then tweeted the link, with a brief