Tag: Microsoft SQL Server

NoCOUG SQL Challenge – thinking outside the padded box

Seems that our André Araujo has already spilled the beans and revealed his solution to the second edition of the NoCOUG SQL Challenge.
Now, I can’t let him have all the fun, can I?

Read More >

NoCOUG SQL Challenge Entry

Once again the great Wizards of Northern California have reached out to the community, pleading for help in the deciphering of one more challenging riddle. The second edition of the NoCOUG SQL Challenge has been published and is open for submissions! This time Iggy and his ensemble came up not only with a SQL challenge but also with a brain-bender riddle that must be resolved before you can start coding your solution. Very nice!

Read More >

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 >
Page 28 of 50« First Page...10...2627282930...40...Last Page »