(Pinal Dave) A few days ago, I wrote a blog about log shipping job failure due to missing permission. In this blog, I would share my experience with another log shipping error “Connection Timeout Expired” for which my client contacted me via Comprehensive Database Performance Health Check.
Other News
OCI Serverless Functions invoking other Functions – synchronous and asynchronously through API Gateway and Streaming
(Lucas Jellema) OCI allows for cloud native application development, using facilities such as serverless functions, a light weight API gateway, a streaming service for asynchronous communication based on event messaging and built-in monitoring.
Maximizing Database Query Efficiency for MySQL – Part Two
(Paul Namuag) This is the second part of a two-part series blog for Maximizing Database Query Efficiency In MySQL. You can read part one here.
Angular – Typescript Fundamentals
(Veerendra Annigere) In order to build an application in Angular, we need to know the fundamentals of Typescript. In this article, I’m going to explain the fundamentals of Typescript and object-oriented programing principles.
Analytics, Reporting and Fine Line of Privacy
It can be very challenging to pull together reporting, analytics, data privacy expectations and support for legislation for information in your systems. People – those users that you support – are learning to request more and more from reporting. They’re expecting systems to be smarter about the information stored in your databases. Azure does amazing things with analytics, looking at […]
What should I do if I’m realizing being a product manager is not for me?
What should I do if I’m realizing being a product manager is not for me? Discovering early that you’re not doing what you enjoy (or aren’t succeeding at it) is probably a gift. Two possible situations: You know what you’d like to do (or try) next. Have a frank but humble discussion with your current manager about it. If there’s...
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
Why Wait Stats Alone Are Not Enough
(Greg Gonzalez) Waits and Queues has been used as a SQL Server performance tuning methodology since Tom Davidson published the above article as well as the well-known SQL Server 2005 Waits and Queues whitepaper in 2006.
What Tables Are Being Written To The Most?
(Michael J. Swart) You have excessive WRITELOG waits (or HADR_SYNC_COMMIT waits) and among other things, you want to understand where.
What is the JVM? Introducing the Java Virtual Machine
(Matthew Tyson) The Java Virtual Machine is a program whose purpose is to execute other programs. It’s a simple idea that also stands as one of our greatest examples of coding kung fu.
Guru: SQL Functions Can Do Non-function Things
(Ted Holt) We all know that the SQL SELECT statement only retrieves data, right? If you want to modify data, you have to use INSERT, UPDATE, DELETE, or MERGE, correct? Well, to quote the great George Gershwin, It Ain’t Necessarily So. You can modify data from a SELECT statement, and maybe sometimes