ALL POSTS

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 #2: Commanding

Introduction This is the second blog post as a continuance in the series on the Pillars of PowerShell. In the initial blog post we went over the various interfaces that can be used to work with PowerShell. In this blog post we are going to start out by going through a few terms you might find when you…

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…

SQL Server 2012 SP2 Cummulative Update 5

Hey folks, Microsoft released the 5th Cummulative Update for SQL Server 2012 SP2. This update package contains fixes for 27 different issues, distributed as follows:     One very important issue that was fixed on this CU release was KB3038943 –   Error 4360 when you restore the backup of secondary replica to another server in AlwaysOn Availability Groups….

Pythian at Collaborate 15

Make sure you check out Pythian’s speakers at Collaborate 15. Stop by booth #1118 for a chance meet some of Pythian’s top Oracle experts, talk shop, and ask questions. This many Oracle experts in one place only happens once a year, have a look at our list of presenters, we think you’ll agree. Click here…

Oracle Database 12c In-Memory Q&A Webinar

Today I will be debating Oracle 12c’s In-Memory option with Maria Colgan of Oracle (aka optimizer lady, now In-Memory lady). This will be in a debate form with lots of Q&A from the audience. Come ask the questions you always wanted to ask. Link to register and attend: https://attendee.gotowebinar.com/register/7874819190629618178 Starts at 12:00pm EDT.

Page 2 of 27912345...102030...Last »