Posts Categorized: Pythian

Online Storage Migration without ASM

I recently blogged about Playing with ASM Online Migration and still soul searching from not having jumped on the ASM band wagon. How can online storage migration be performed before ASM came about? One option is using Logical Volume Manager (LVM) and I will demonstrate: Display Volume Group [root@lax ~]# vgdisplay –verbose vg02 Using volume…

Missing UKOUG Tech13 — But Still in Manchester at OakTable World UK 2013

This is the first year since 2006 that I don’t present and don’t attend UKOUG Technology annual conference. Sad but I had to withdraw because I didn’t believe UKOUG has been making the right choices in the past little while. The trigger was the introduction of the limit of six presentations per company to present at the conference which I believe doesn’t really serve well the conference attendees nor my company that I’m so passionate about nor my colleagues that I’m so proud to work with.

SQL Server 2014 CTP 2 – Installation

SQL Server 2014 CTP 2 was already announced, which is available now for download as a community technology preview. You can now download SQL Server 2014 CTP2 from http://technet.microsoft.com/en-US/evalcenter/dn205290.aspx. This post covers a step-by-step installation guide of SQL Server 2014 CTP 2 with screen shots. Future release or final release may not be exactly same…

Batched Table Access

When I first saw the suffix BATCHED in an Oracle execution plan from 12c, I was curious to see what is hidden behind and how it works. I had some spare time for testing and wanted to share my findings with you here.

SQL Server 2014 CTP 1 – Installation failure

Recently I was trying to install SQL Server 2014 CTP 1 on my Windows Server 2008 R2 Virtual Machine to explore SQL Server 2014. What I encountered was a failure of a rule “Previous SQL Product installation” ———————————— Rule Check Result ————————————- Rule “Previous SQL product installation” failed. A SQL product other than SQL Server…

Preventing runaway queries using Resource Governor

Section A (Theory) One of the typical reasons for performance issues is runaway queries executed by end users on a busy production database. This problem is fairly common in OLAP or shared systems (OLTP/OLAP) where business users begin executing complex (and often poorly written) queries, leaving their office for hours, and expecting their data to…

Why was SSHD refusing my key?

I was contacted by a colleague about a problem he was having. “I’m trying to set up something simple which I’ve done millions of times, but it’s not working. I might be missing something obvious.” The issue was that the SSH public key authentication didn’t work. The environment was running a virtualized Oracle Enterprise Linux 6.4…

Page 20 of 207« First...10...1819202122...304050...Last »