(Wayne Leutwyler) The blog post How to Compile Percona Server for MySQL 5.7 in Raspberry Pi 3 by Walter Garcia, inspired me to create an updated install of Percona Server for the Raspberry Pi 3+.
Other News
Delete MGMTDB and MGMTLSNR from OEM using emcli
(mdinh) Doc ID 1933649.1, MGMTDB and MGMTLSNR should not be monitored.
GoLang: Inserting records into Oracle Database using goracle
(brendantierney) In this blog post I’ll give some examples of how to process data for inserting into a table in an Oracle Database. I’ve had some previous blog posts on how to setup and connecting to an Oracle Database, and another on retrieving data from an Oracle Database and the importance of set
Basic Replication — 2b : Elements for creating a Materialized View
(Hemant K Chitale) Continuing the previous post, what happens when there is an UPDATE to the source table ?
SQL SERVER – Show Primary Key for a Single Table – sp_pkeys
(Pinal Dave) When I work with Comprehensive Database Performance Health Check, I get all sort of questions and I love answering them. Recently, one of my clients showed me a very cool trick to check Primary Key for a single table with the help of the system stored procedure sp_pkeys.
Using JSON Based Entities for Caching Remote Data in C#
(honey the codewitch) Aside from a clean way to query remote JSON/REST based services, you usually need a way to cache and index the data you get back.
How Do You Deal with a Toxic Coworker?
This question came from a busy business owner. How do you deal with a toxic coworker? If someone at the office is making you feel consistently stressed or unmotivated, you might be dealing with a toxic coworker. Most importantly don’t take it personally and keep your interactions always profession. Don’t let this toxic behavior damage your professional, emotional and physical...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
SQL Server Statistics and how to perform Update Statistics in SQL
(Rajendra Gupta) This article gives a walk-through of SQL Server Statistics and different methods to perform SQL Server Update Statistics.
Power Query/M Optimisation: Getting The Maximum Value From A Column, Part 2
(Chris Webb) In part 1 of this series – which I strongly recommend you read before reading this post – I showed how removing columns from a table can make a dramatic improvement to the performance of certain transformations in Power Query.
Delete Data Safely with SQL
(Hannes du Preez) You never know what can happen when you attempt to delete data. Some may argue that it is best to delete data through a client application, some may say it is better to do so through SQL Server itself, by using SQL code.