Category syndication

Would the Fastest Cloud Please Step Forward?

Not so fast, there, buddy.
CloudSleuth has released a new tool that allows users and customers to see how the different cloud providers stack up. As of 6:45 PM EST on August 1, Microsoft’s Azure services come out ahead by about 0.08 seconds.
0.08 seconds per what?
Turns out that it was the time to request and receive [...]

Finding Cross-Database Dependencies

Ever want to know how many queries are referring to other databases on a server? How about a different server?
Worry no more! I have a query that will help you answer these pesky questions:

SELECT DB_NAME() AS current_db_name,
OBJECT_NAME(referencing_id) AS o_name ,
[...]

Revisiting Lady MacBeth and Her Torturous Lies

A while back, I wrote up a genius piece of code that would automatically shrink my log files whenever they grew.
Kendra Little (blog | twitter) completely called me out for my horrible, sneaky, developer ways. Ostensibly, I had found a solution for my rampant log growth problem. Unfortunately, I had cured the symptom and not [...]

The Future of Databases

The Story So Far
I’ve been in love with data storage since I first opened up SQL*Plus and issued a select statement. The different ways to store data are fascinating. Even within a traditional OLTP database, there are a variety of design patterns that we can use to facilitate data access. We keep coming up with [...]

The Board of Directors and You

The deadline for nominations to the PASS Board of Directors is rapidly approaching. I figured that it would be great if I chimed in and mentioned what I’ve learned on the Board, what I think would be typical for a board member, and… I don’t know what else, but I really felt that this list [...]