Tag: Microsoft SQL Server

Easier SQL Server Database Restores

Have you ever been asked to restore a database and wondered which backup files were available? And if many were available, which ones you should use, and in which order? Okay, this is not a difficult thing to do, but when you do it over and over again, it becomes tedious, and the automation bug in you starts to look for a better and quicker way to handle it. The bug in me found the following answer.

Read More >

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

This is the 159th edition of Log Buffer, the weekly review of database blogs. Welcome.

Read More >

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

This is the 158th edition of Log Buffer, the weekly review of database blogs.

Read More >

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

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

Read More >

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

This is the 155th edition of Log Buffer, the weekly review of database blogs.

Read More >

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

Welcome to the 154th edition of Log Buffer, the weekly review of database blogs. Let’s dive right in, shall we?

Read More >

Database Analyst Steals Credit Card Data

This blog post was inspired by a recent report of a Database Analyst at American Express stealing Credit Card data. It’s amazing how many companies still follow a mainly “perimeter security” approach when it comes to controlling access to sensitive information—their focus is on network security using firewalls, advanced authentication options, and so on. Even with such measures, it’s very common to setup strong barriers to the outside world but very little by way of internal limits; most internal people have some level of access to servers that store and process sensitive data.

Read More >

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

This is the 153rd edition of Log Buffer, the weekly review of database blogs.

Read More >

Connecting to Oracle with SQL Server 2005 x64

Using OLE DB to get SQL Server to connect to Oracle servers can be done quite easily, but there are a few little tricks you should know to make it go smoothly. Once it’s working it seems to work quite well. I hope this blog post will save you a few headaches.

Read More >

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

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

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