Tag: Microsoft SQL Server

Log Buffer #213, A Carnival of the Vanities for DBAs

Warm welcome to the Log Buffer, a weekly amalgamation of database news across different technologies. Let’s get warmed up with sizzling Log Buffer #213.

Read More >

Log Buffer #209, A Carnival of the Vanities for DBAs

Welcome to Log Buffer, the weekly news update of happenings in the database world.

Read More >

Log Buffer #208, A Carnival of the Vanities for DBAs

Welcome to Log Buffer, the weekly round up of news and happenings in the database world.

Read More >

Disaster Recovery is more than Technology Pt 2:The Acronyms

In this blog post, I’ll describe a few acronyms – sometimes called buzzwords – that are commonly referred to in HADR projects and implementations (I know I use them a lot when addressing questions regarding HADR.) These acronyms fall under the second P in my PPT for HADR – PROCESS.

Read More >

Disaster Recovery is More Than Just Technology Part 1

I’ll be writing a series of articles about disaster recovery and what RPO/RTO/SLAs are and how they fit into the whole disaster recovery strategies. Before I dive into the “technology” part of the PPT ingredient for a successful HADR implementation, I will talk about the people and the process part first..

Read More >

Using UNPIVOT with CDC Functions to get Updated Columns List

Microsoft introduced Change Data Capture (CDC) technology in SQL Server 2008. This technology captures DML (insert/update/delete) changes to a table. After CDC is enabled for a database and a given table, one can use cdc.fn_cdc_get_all_changes_ function to query changes made to the table. The challenge was to produce a “log” table with columns like this…

Read More >

Log Buffer #207, A Carnival of the Vanities for DBAs

Winter has started and the holiday season is approaching fast. With the chillness of winter and festive mode induced by the holidays, bloggers across the planet are coming up with more and more exciting ideas. Let’s start with sizzling Log Buffer #207.

Read More >

Data Pump Monitoring

If there is no much useful information in v$session_longops and space for the segment is already allocated how to get the same “rows completed” value of worker status as in intercative mode but using sql script? With small modification of example from the documentation I came with the PL/SQL block to get value of one Data Pump Import worker status attributes…

Read More >

EBS DBA: WF Mailer Override Address and Cloning: How to

I just recently faced an issue on how to automate the Workflow Mailer override address for development and testing environments during the EBS cloning process. The problem is that the only official way to set the override address in the latest ATG releases is to go through the OAM portal and change the override email via the GUI interface. I came to this solution.

Read More >

Log Buffer #206, A Carnival of the Vanities for DBAs

Welcome to Log Buffer, the weekly news blog about blogs in the datasphere.

Read More >
Page 29 of 51« First Page...10...2728293031...40...Last Page »