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: https://github.com/bbalazs83/WaitCheck The script was written in python and uses the cx_Oracle Python module which you can download here: https://pypi.python.org/pypi/cx_Oracle/5.2.1 The following two historical views are…

Read More →