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 →Author: Balazs Berki
You might want to monitor the Windows Event Log by using a tool built in .Net which reads certain Event IDs where the Source is the SQL Server. I prepared a small test case which shows how Windows stores the Event ID and how you should (not) read them. I am using a Windows Server 2012 R2…
Read More →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 →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 →