Tag: Microsoft SQL Server

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

Database Servers are humming along, and the people who manage them, interact with them or are just in awe of them are busy in blogging about them. This inspires our next Log Buffer, Log Buffer #214.

Read More >

NoCOUG (My)SQL Challenge entry #2

A few days ago I learned about this year’s NoCOUG SQL Challenge and decided to to put the gray matter between my ears to work. I’ve been teaching a MySQL course this week and my first impulse was to use my MySQL VM to test my solution attempts. However, I eventually decided to use Recursive Subquery Factoring to solve the proposed problem and had to switch to an Oracle 11gR2, since it’s the only database that implements this feature that I know how to use (are there any others?). I was happy with my solution, but frustrated that I couldn’t run it on MySQL. So I decided to try to make it somehow work on MySQL.

Read More >

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