(David Ramel) One of the more popular recent features added to Visual Studio Code is a preview of remote development functionality, getting a boost in the June release, version 1.36.
Community
How to use if condition in laravel select query?
(Hardik Savani) We will learn how to use if condition in laravel select query. we can use mysql case when statement with db raw in laravel.
Network design for Oracle Cloud Infrastructure
(Syed Jaffar Hussain) Assuming, you are planning to migrate your resources from Oracle Cloud Infrastructure Compute classic environment to Oracle Cloud Infrastructure, this blog post explains the details of network design for Cloud Infrastructure environment.
v$sql_hint.target_level
(Sayan Malakshinov) Today I wanted to give a link to the description of v$sql_hint.target_level to show that no_parallel can be specified for statement or object, and though it’s pretty obvious, but surprisingly I haven’t found any articles or posts about it, so this short post describes it.
Creating HR in Oracle Autonomous Database w/SQL Developer Web
(Jeff Smith) When I say, ‘Oracle Autonomous Database,’ assume I mean one of the following environments:
SQL SERVER – Impact of CHECKPOINT and DBCC DROPCLEANBUFFERS on Memory
(Pinal Dave) I love working with my clients and solving their SQL Server Performance Tuning challenges which are difficult to solve. I have been working for over 10 years performing Comprehensive Database Performance Health Check at many different clients and my clients can vouch that I have seen pr
Brand-new Web Document Scanning Methods Based on JSON Data Interchange
(Xiao Ling) In this post, we discuss how to control your scanners and acquired images easily and efficiently using JSON objects. The article is also a guide for beginners to get started with Dynamic Web TWAIN programming.
SQL Server MERGE Statement overview and examples
(Ranga Babu) In this article, we will review SQL Server MERGE statement, alternatives to MERGE statement, different clauses and examples of MERGE statement in SQL Server.
What permissions do temp stored procedures use?
(Kenneth Fisher) In a performance tuning class I recently took with Brent Ozar (b/t) he mentioned temporary stored procedures and an interesting question came up.
The DBA is Dead? No, the DBA as Gatekeeper is Dead!
(Ember Crooks) I still remember this meeting when I had been a DBA for less than a year at IBM. It was IBM, so I was the lone primary DBA for this internal client.