Tag: Microsoft SQL Server

Backups in SQL Server 2005/2008, Part 1: The Basics

This is the first post in a series dedicated to exploring the backup and availability options in SQL Server 2005 and 2008. It is aimed at anyone unfamiliar with the database backup options in SQL Server 2005 and 2008. I’m not going to explore every single option or scenario, the goal is to give you the language and the tools to do deep dives where you need to.

Read More >

Running querys against multiple SQL Server AND Oracle instances

Before SQL Server 2008, there was no native support for running the same query against multiple instances using shipped tools, so it can be approached in one of these ways…I’ve used nearly all of them, but I have found that linked servers provide a higher degree of control on the target servers, error handling, and most important, the ability to use SQL server Encryption to store the credentials of source servers if some of the servers are using SQL authentication.

Read More >

Log Buffer #167: A Carnival of the Vanities for DBAs

Welcome to the 167th edition of Log Buffer, the weekly review of database blogs.

Read More >

Log Buffer #165: A Carnival of the Vanities for DBAs

Welcome to the 165th edition of Log Buffer, the weekly review of database blogs.

Read More >

Log Buffer #164: A Carnival of the Vanities for DBAs

Welcome to the 164th edition of Log Buffer, the weekly review of database blogs.

Read More >

Log Buffer #163: A Carnival of the Vanities for DBAs

Welcome, readers, to the 163rd edition of Log Buffer, the weekly review of database blogs, your sieve

Read More >

Log Buffer #162: A Carnival of the Vanities for DBAs

Welcome to the 162nd edition of Log Buffer, the weekly review of database blogs.

Read More >

Log Buffer #161: A Carnival of the Vanities for DBAs

Welcome to the 161st edition of Log Buffer, the weekly review of database blogs … and the first one under my penmanship.

Read More >

Oracle Exadata v2 — Truly Oracle (Sun) Hardware

The rumors are that Oracle Exadata v2 and Oracle Database Machine v2 are going to be announced within few weeks and my take is that it’s going to happen at the Oracle Open World. I don’t think it comes as a surprise to anyone that it will be configured with Oracle Database 11g Release 2. Moving on to predictions and speculations…

Read More >

Log Buffer #160: A Carnival of the Vanities for DBAs

Welcome to the 160th edition of Log Buffer, the weekly review of database blogs.

Read More >
Page 34 of 50« First Page...10...3233343536...40...Last Page »