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 →Year: 2016
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 →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 →With this post I aim to present a lightweight CPU Monitoring solution for individual processes that can be automated on Windows Hosts. This can be useful if we see a constant CPU peak on some of our MSSQL Hosts but no heavy load on the instance itself. In such cases we need to monitor all…
Read More →Recently I was in charge of implementing the single-sign-on feature of Oracle using Kerberos at my workplace. With this post I would like to pinpoint some pitfalls and how to avoid them when setting up and troubleshooting Oracle Kerberos. I do not aim to provide a complete guide on the topic as there are already many…
Read More →