T-SQL Tuesday #31 – Logging

| 2 Comments

T-SQL Tuesday #31 - LoggingThis month’s T-SQL Tuesday is hosted by Aaron Nelson (@SQLvariant | Blog). The topic is about logging. Many will talk about their logging strategies with their SQL Server infrastructure. Many will show us ways they do their day-to-day logging. And many will offer tips and tricks to expert logging.

According to Aaron, we’re not constrained to talking about logging within just SQL Server. I am not the right person to talk about SQL Server logging; so, that rule encouraged me to participate in this month’s T-SQL Tuesday (my first).

I am tempted to write about all of the logging stuff I am doing in my personal life. If we take “logging” to mean making lists, tracking processes, and trailing work flows, my list will be in infinite loop.

Let me share how I track, or log, the blogs I want to read, or have read but want to keep for reference, in my quest to gain and improve my SQL Server DBA skills. I know I am far down the scale and reading is one of the best tools I can afford to catch up.

Chrome Bookmark

I have a main folder called “SQL Server” to hold all blog links related to SQL Server. These links are categorized into different topics with each topic placed in their own sub-folder. My folder structure looks something like this:

SQL Server
> SQL Fundamentals
> SQL Dev
>> SSRS
>> SSIS
> Backup & Recovery
> High Availability
>> Replication
>> Mirroring
>> Log Shipping
>> Failover Clustering
> Security
> Performance Tuning
> Monitoring
> Troubleshooting
> SQL Tutorials
> SQL 2012
>> AlwaysOn Availability Group
> SQL Azure
> SQL Tools

It’s not a perfect system but it works for what I need.

Twitter Favorites

I also track the interesting links I found on Twitter by marking them as Favorite. If the link is something that I can use now or in the future, it goes to my Chrome Bookmark. More often than not, I “favorite” something to just read it later

Old-school Notebook

I am on a mission. I am on a quest for that elusive SQL Server DBA job I have been longing to have. Aside from blog reading, I purchased a handful of SQL Server 2008/2012 paperbacks and I have a list of books I still need to buy! I have some SQL Server books on my Kindle, too. For me taking notes is better than highlighting sentences. Yes, I agree that searching through pages in physical notebooks is difficult but I am comfortable with that. Hey, I’m a Moleskine fan!

Hacker News

I have become a Hacker News (HN) fan only last year. It’s my source of daily geek news. Where do you think I’m finding those interesting (well, some of them are) links I am posting on my Twitter stream? Want to know latest movement in the tech world? Yes, go to HN. My upvoted links are stored in my “saved stories” and all the links I submitted are in my, well, “submission”.

I promise that I will post about real SQL Server logging next time.

Author: Marlon Ribunal

I'm passionate about SQL Server. But I feel like I haven't reached my full potential yet. So, this is my mission: My purpose is to help people in their pursuit of growth and development; and, thereby, help myself realize my full potential as a professional, husband, father, christian, and human being.

2 Comments

  1. This is where Microsoft OneNote really comes in handy if you have access to it in Office.  I use it heavily for note taking and archiving blogs that I come across that I think may be useful down the road (you won’t believe how many of these disappear over the course of a year or two and archiving them to OneNote has saved my butt more than once:) ).  I set tasks up in Outlook (which it integrates with nicely) to review certain content if I don’t have time initially to give it a thorough read. I also use it for my own documentation and I save all of my scripts to it.

    • I tried OneNote & EverNote, but for some reason I couldn’t make them work. I did a lot of GTD hacks on my SQL study but the only thing that seems to be working is doing it the old school way (bookmarking and physical note taking).

      I have tried many things as documented in my Productivity & GTD Hacks Blog – http://www.productivitybits.com/

Leave a Reply

Required fields are marked *.