Author: Balazs Berki

By: Date: April 16, 2017 Categories: READ_COMMITTED_SNAPSHOT

When working with a busy database you might run into problems when you want to change a database setting which requires the database to be in a consistent state, meaning no uncommitted transactions and no schema or table locks. Ideally the application(s) using the database should be offline for such a change but for cases…

Read More →
PowerShell and Scheduling
By: Date: December 11, 2016 Categories: Powershell,Scheduled Task

With this post I aim to show how to create a Windows Scheduled Task using powershell with the basic modules by using the COM Objects (Schedule.Service) of Windows. In the second part of my post I will show how to use powershell and SQL Server Management Objects (SMO) to create an SQL Agent job with multiple steps using powershell…

Read More →
SQL Server Management Studio: scripting does not show Data_Compression by default
By: Date: November 16, 2016 Categories: DATA_COMPRESSION,SQL Server,SSMS

With this post I aim to highlight a feature of  SQL Server Management Studio (SSMS) regarding the DATA_COMPRESSION property when scripting objects. First I create a table and an index with PAGE compression: use TESTDB GO CREATE TABLE People ( PersonID int, LastName varchar(200), FirstName varchar(200), Address varchar(200), Phone varchar(20) ); CREATE NONCLUSTERED INDEX [comp_index_LastName] ON [dbo].[People]…

Read More →
Monitoring Oracle WaitEvents with Python
By: Date: October 15, 2016 Categories: Oracle,Oracle monitoring,Oracle WaitEvents,Python

In this post I will present a script called WaitCheck which you can use to monitor wait events in an Oracle database. You can find and download it from my GitHub Page here: The script was written in python and uses the cx_Oracle Python module which you can download here: The following two historical views are…

Read More →