(Sergey Gigoyan) In some cases, a SQL Server database occupies much more space than actually is used by the data or would ever be used. In such situations, it would be optimal to reduce the size of the database and return the storage space to the operating system.
Community
React Bootstrap Table with Searching And Custom Pagination
(Sanwar ranwa) In this article, we will learn how to use the React Bootstrap Table in React applications. I will also explain how we can implement paging, searching, and sorting in this Table.
SQL AS keyword overview and examples
(Esat Erkec) SQL AS keyword is used to give an alias to table or column names in the queries. In this way, we can increase the readability and understandability of the query and column headings in the result set.
#PowershellBasics: Run a file and pass it a parameter.
(Kenneth Fisher) I realized in my last #PowershellBasics post that I was talking about running a file and passing in an optional parameter but I didn’t describe how to do it. I decided that it was a distinct enough task that I’d make it it’s own post, so here we go.
Never Concatenate Strings With jOOQ
(lukaseder) jOOQ supports a vast amount of SQL syntax out of the box. As such, most users will not think of resorting to string concatenation like in the old days when writing dynamic SQL with JDBC.
APEX 19.2 upgrade quick tip: run check_lovs_for_errors.sql
(Sven Weller) The APEX 19.2 readme includes info about a small script check_lovs_for_errors.sql that one should run after the upgrade. It is very easy to overlook this in the readme files.
How to show dates in a given time zone when the value is stored in a DATE data type
(Joel R. Kallman) Firstly, this post has nothing to do specifically with APEX. It has everything to do with date conversions in Oracle SQL and how to convert them to a different time zone.
AWR records top 30 SQLs by default
(Bobby Durrett) I forget that Oracle’s AWR only records the top 30 SQL statements in each snapshot by default. I am not sure how long this link will last but here is a 19c manual page describing the default: 19c manual – see the topnsql setting.
Working with IWebHostEnvironment and IHostingEnvironment in dual targeted ASP.NET Core Projects
(Rick Strahl) With .NET Core 3.1 Microsoft broke a fairly low level abstraction by effectively renaming IHostingEnvironment and replacing it with IWebHostEnvironment. IHostingEnvironment still exists in .NET Core 3.x and can still be used and it still works, but it’s been marked as deprecated and wi
Understanding the Utility of Iostreams in C++
(Manoj Debnath) The iostream classes are the first library classes we encounter when we begin with C++. The primary services that we deal with these classes is solving general I/O problems.