Tag: Troubleshooting

Feed: Planet MySQL. Author: Erik Ljungstrom. I typically keep this blog strictly technical, keeping observations, opinions and the like to a minimum. But this, and the next few posts will be about basics and fundamentals for starting out in system administration/SRE/system engineer/sysops/devops-ops (whatever you want to call yourself) roles more generally.Bear with me!“My web site is slow” I just picked the type of issue for this article at random, this can be applied to pretty much any sysadmin related troubleshooting. It’s not about showing off the cleverest oneliners to find the most information. It’s also not an exhaustive, step-by-step “flowchart” ... Read More

Feed: Microsoft Azure Blog. Author: Jan Kalis. Microsoft Azure team is committed to helping you achieve more with the power of the cloud. The Azure support teams are here to help you build, deploy and run your Azure solutions with confidence. We are continuously expanding troubleshooting and support areas to help you accelerate your cloud journey. This post provides an overview of key self-help tools and a quick glance at Azure support. Self-help and troubleshooting Comprehensive documentation and get started resources are a good start for all Azure customers. As you begin to design your solutions and look for help ... Read More

Feed: AWS Compute Blog. Author: Bryan Liston. John Pignata, Solutions ArchitectWith the explosion of device types used to access the Internet with different capabilities, screen sizes, and resolutions, developers must often provide images in an array of sizes to ensure a great user experience. This can become complex to manage and drive up costs. Images stored using Amazon S3 are often processed into multiple sizes to fit within the design constraints of a website or mobile application. It’s a common approach to use S3 event notifications and AWS Lambda for eager processing of images when a new object is created ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . There may be times when a query is taking longer to execute than expected. With Oracle, the Automatic Workload Repository collects statistics on a regular schedule to report on how the system is performing, including elapsed time for queries. Since a full AWR report may not be necessary a script using some of the AWR data can generate elapsed time reports by sql_id. Let's look at a script that does that and see how it can report longer elapsed times. Looking at the code there is nothing unusual: set linesize 200 trimspool ... Read More

Feed: SQL Server Release Services. Author: Parikshit Savjani. With cloud first strategy, the SQL Product Team has observed great success and adoption of SQL Server 2016 compared to any previous releases. Today, we are even more excited and pleased to announce the availability of SQL Server 2016 Service Pack 1 (SP1). With SQL Server 2016 SP1, we are making key improvements allowing a consistent programmability surface area for developers and organizations across SQL Server editions. This will enable you to build advanced applications that scale across editions and cloud as you grow. Developers and application partners can now build to ... Read More

Feed: SQL Server Customer Advisory Team. Author: Dimitri Furman. Reviewed by: Steven Green, Peng Song, Xiaochen Wu, Kun Cheng, Sanjay Mishra Introduction Database migration from SQL Server to Azure SQL Database is a process that many organizations must implement as they move to Azure public cloud. This article is a guide that describes one specific implementation path for the migration process, that has been commonly used by Microsoft customers. To aid others in the same task, in this article we present lessons learned, recommendations, examples, caveats, potential issues, solutions, and workarounds. A sample PowerShell script that automates some migration steps ... Read More

Feed: Planet PostgreSQL. Last week a new PostgreSQL major version with the number 9.6 was released! Announcement, release notes and the official “What’s new” overview can be found here, here and here – it’s highly recommended reading, so check them out. But as always, also a slew of blog-posts from exited members of the global Postgres community follows (check out Planet PostgreSQL here if not yet subscribed), each with a bit different angle, and now I would like to add my own impressions on the most interesting/relevant features summarized for easy digestion. As always, users who upgrade or initialize a ... Read More