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 ,
[...]
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 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 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 [...]
How many of you are using Visual Studio 2010? How many of you are writing SSIS packages? How many of you are pissed off, irritated, or confused about how you’ll be able to write and version control your SSIS packages (VS 2008) once you’ve upgraded to TFS 2010?
Confused yet? Yeah, so am I.
Let’s backtrack: at [...]