Posts Categorized: Technical Blog

Pillars of PowerShell: Profiling

Introduction This is the fourth blog post continuing the series on the Pillars of PowerShell. The previous post in the series are: Interacting Commanding Debugging Profiles This is something I mentioned in the second post and can be a great way to keep up with those one-liners you use most often in your work. A profile…

Keeping Cassandra Alive

Troubleshooting Cassandra under pressure This is the second blog post in the series. This is a bit more technical than the first one. I will explain some things that can be made to keep a cluster/server running when you are having problems in that cluster. There were a lot of changes in Cassandra over the…

Pillars of PowerShell: Debugging

Introduction The is the third blog post continuing the series on the Pillars of PowerShell. The first two post are: Interacting Commanding We are going to take a bit of a jump and dig into a particular topic that I think is better to go over up front, instead of later. In this post I…

Disable Lock Escalation in SQL Server

If a lot of rows or pages are locked, the SQL Server escalates to a table-level lock, to save resources. Each single lock takes approx. 100 bytes. So if you have many locks it takes a lot of resources to manage them. (There is a great blog about lock escalation, if you want some more…

OakTable World at IOUG COLLABORATE15

Update history: 5-Apr: WIT panel added, Alex removed, Gwen and Pete schedule shifted. 11-Apr: Gwen and Pete swapped sessions. 13-Apr: Jonathan off lightning talks. Guess what? OakTable World at IOUG C15 is happening again! Last year, we had awesome sessions and wonderful attendees. The sessions were so successful, in fact, that we needed a bigger…

Pillars of PowerShell #1: Interacting

Introduction PowerShell is a tool that if adopted can be used to help automate and standardize processes in your Windows and SQL Server environment (among other things). This blog series is intended to show you some of the basics (not all of them) that will get you up and running with PowerShell. I say not…

PowerShell Script to Manipulate SQL Server Backup Files

Scenario I use Ola Hallengren’s famous backup solution to back up my SQL Server databases. The destination for full backups is a directory on local disk; let’s say D:\SQLBackup\ If you are familiar with Ola’s backup scripts, you know the full path for backup file looks something like: D:\SQLBackup\InstanceName\DatabaseName\FULL\InstanceName_DatabaseName_FULL_yyyymmdd_hhmiss.bak Where InstanceName is a placeholder for…

Using strace to debug application errors in linux

strace is a very useful tool which traces system calls and signals for a running process. This helps a lot while debugging application level performance issues and bugs. Aim of this post is to demonstrate the power of strace in pinning down an application bug. I came across an issue in which nagios was sending…

Monitoring Cassandra with Grafana and Influx DB

Grafana_cassandra-test2

Hello, In this post I will explain how to set up Cassandra monitoring with influxDB and Grafana. This can also be used to connect to other monitoring systems (Graphite, Collectd, etc…) but since both influxDB and Grafana are hot topics at the moment I decided to follow the trend! I was asked why I was…

Page 1 of 6312345...102030...Last »