Archives: January 2012

S3OLV update and Reminder

by Jason Brimhall
Categories: News, Professional, SSC, SSSOLV
Tags: , , ,
Comments: No Comments
Published on: January 9, 2012

We are now just a few days away from our first meeting of 2012.  We have some good content lined up.  Check it out here.

I am looking forward to the presentation on XML and would really love to be able to bring Josh back to finish out the series.  Let’s show him a lot of support as he has put a lot of effort into making this presentation series.  I know because I have been hounding him about it.

In other news, we have received the PASS 2011 Summit DVDs.  There is a lot of cool content.  We plan on making these DVDs available to the group shortly.  These DVDs contain all of the main conference sessions.  They will prove to be an invaluable resource (much like every other year).

We have also talked in the past of getting a newsletter together.  As an interim step, we created the S3OLV Journal paper.li newsletter.  We are getting closer to having a mechanism in place to send out newsletters to the group.  Stay tuned – this should be happening in the near future.

Meme Monday January 2012

by Jason Brimhall
Categories: Meme Monday, News, Professional, SSC, SSSOLV
Tags: , ,
Comments: No Comments
Published on: January 9, 2012

Meme Monday was pushed back this month to the second Monday of the month.  That is a good thing or maybe a bad thing or maybe a non-discussion at all.  I guess it really depends on the person.  For me, I would have been rushing the post so I am fine with.  Oh wait, I sit here on the first Monday writing my post anyway.

Tom LaRock has asked us to write about what we plan to do for #sqlfamily in 2012.  I am somewhat prepared for this topic already.  I had been giving it some thought over the past couple of weeks.  I was even thinking of incorporating some of that into my Goals post for 2012 (assuming I get it done this year).

So, without further ado and without going to great detail, here is what I had been planning for the upcoming year and to describe in greater detail in my goals post.

1.  More SSRS and SSIS blog posts.  It seems that these have been somewhat popular in the past.  In addition, I have several posts lined up that I have been planning to write.  Some will be multi-part series, and others just a single post series.

2.  Present at least once per quarter throughout 2012.  I think this is attainable and I hope to add a few presentations to the bag.

3.  I really want to help organize an event.  This will take a lot more time and be a little more difficult based on event location relative to where I live – but I am hoping to get it done.

4.  I plan on maintaining the other activities such as UG help, forum help, twitter (when I can) help, articles, and blog posts.

 

That pretty much sums it up for what I hope to do for #sqlfamily in 2012.  What are you planning to do?

Daemon

by Jason Brimhall
Categories: Book Reviews, News, SSC
Tags: ,
Comments: 1 Comment
Published on: January 4, 2012

At the recommendation of Jorge Segarra (Blog | Twitter),  I got the book Daemon.  Well, I actually got that about a year ago as a gift – but it was on my list of books to read because Jorge recommended it.

I have finally finished reading it and will be starting Freedom very shortly.  I am glad I bought Freedom prior to finishing Daemon since the ending leaves to many open story lines.  I really hate to finish a book on a cliff hanger and then have to wait for the next book.

While reading the book, you sit there and wonder if your servers are patched.  You also wonder if the network has been properly secured against intrusion.  But in the end, you accept that it doesn’t matter how secure the network is because the most successful way to hack a network is via social engineering.

Reading the book from an IT perspective, you understand that much of it is plausible.  You also find yourself slobbering over some of the tech that is described.  I really want some of those security systems, at least two AutoM8s, and an omnipresence stereo system (for lack of a better term).  A Razorback would be interesting to own too. ;)

I really enjoyed the book.  There was plenty of talk of databases, data security, and data breaches.  There was also a nice mix of espionage, treason, and mystery.  The plot seems to continue to twist and turn – which kept me involved.  At many points, you are also greeted with cold hard reality with some of the decisions that must be made and with regards to how politics work.

Go get this book and read it.  I’m off to read Freedom now.  I find myself expecting a myriad of possible conclusions while hoping for a better conclusion.

«page 2 of 2
Calendar
January 2012
M T W T F S S
« Dec   Feb »
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
Follow me on Google+

In 0 people's circles

Add to circlesi
Content
Categories

Categories

Popular Posts

Popular Posts

Blogroll

Blogroll

Now Reading

Now Reading

Planned books:

Current books:

  • ChiRunning: A Revolutionary Approach to Effortless, Injury-Free Running

    ChiRunning: A Revolutionary Approach to Effortless, Injury-Free Running by Danny Dreyer, Katherine Dreyer

  • Advanced Marathoning – 2nd Edition

    Advanced Marathoning – 2nd Edition by Peter Pfitzinger, Scott Douglas

  • SQL Server MVP Deep Dives

    SQL Server MVP Deep Dives by Nielsen Paul, Delaney Kalen, Machanic Adam, Tripp Kimberly, Randal Paul, Low Greg

  • A World Without Heroes (Beyonders)

    A World Without Heroes (Beyonders) by Brandon Mull

Recent books:

View full Library

SQLHelp

SQLHelp


Recent Posts
  • Move the T-log file of the … by Jason Brimhall

    On more than one occasion, I have run into a case where a large database with a large transaction log was being mirrored.  Then a hiccup comes along – the transaction log on the primary server grows to a point where the transaction log on the secondary server fills the [...]

  • SQL 2012 has Launched by Jason Brimhall

    LAUNCH If you have been hiding under a rock, you have probably not heard that SQL 2012 has launched.  With it, some really cool features are now available to use in our SQL database environments. Some of these cool new features include some new DMVs, the AlwaysOn feature, and columnstore [...]

  • Seldom Used Indexes by Jason Brimhall

    On occasion you may ask yourself if there are any under used indexes in your database.  If not you, then possibly a manager or client.  Usually this comes up when evaluating for missing indexes or better indexes. SQL Server provides a means to find the information we seek.  We can [...]

  • Another Interesting Sort by Jason Brimhall

    In October of 2011, I shared an example of a peculiar set of sort requirements.  Today, I am going to share another similar set of requirements.  Based on prior experience, when I saw this request on a sort order, I was sure I could find a simpler solution.  Today, I [...]

  • Agent Jobs Using SSIS by Jason Brimhall

    This is a short script to help the DBA with documentation purposes.  This would come in handy especially in those cases where you are consulting or you have taken on a new job. Suppose you want/need to find out what SQL Agent jobs are running SSIS packages.  This script will [...]

  • Table Size and Missing FK Indexes by Jason Brimhall

    I am bringing an oldie back with another twist.  I recently ran into the need to correlate information between a couple of different queries that I like to use.  The two scripts returned different pieces of data about tables in a database.  This information was table size and missing foreign [...]

  • T-SQL Tuesday #028 – Jack o… by Jason Brimhall

    Another month and another opportunity to write about an interesting topic.  This month hosting TSQL Tuesday is Argenis Fernandez (Blog | Twitter). This month, Argenis has invited us to talk about demons from our past.  Ok, not necessarily demons but at least share why you might be a Jack of [...]

  • What is a Favicon? by Jason Brimhall

    If I were to show you the tabs in the following pic without a description, would you recognize the websites to which they belong? I would dare say that you would likely recognize them.  Not due to the labels on the tabs, but quite possibly due to the icon on [...]

  • Physical or Virtual by Jason Brimhall

    Today I get to share something that has been on my someday list for quite some time.  I have planned on getting a solution that involves TSQL to help determine if you are running SQL Server on a physical machine or if it happens to be a virtual machine.  Now, [...]

  • Views in Use? by Jason Brimhall

    Today, I am following up on a topic I mentioned in an earlier post.  In case you haven’t read the post on finding your linked servers, you can read it here. It is in that post that I spoke of altering a script I had just written for another client [...]

Categories
Recent Comments
  • Jason Brimhall about Move the T-log file of the …
    Thanks Robert.
  • Robert Pearl about Move the T-log file of the …
    Nice tip, Jason! Going to share it on DBA.Connect, and other Linkedin groups....
  • Ron Moses about Seldom Used Indexes
    Thanks Jason. I know for certain that none of our queries use hints, so that's a non-issue. But ...
  • Jason Brimhall about Seldom Used Indexes
    The script can certainly be changed to look at that. I did this script knowing that I only wanted ...
  • Ron Moses about Seldom Used Indexes
    Okay, bear with me because I might be a wee bit dense. I'm a bit of a n00b. "I want ...
  • Jason Brimhall about Seldom Used Indexes
    The purpose for that condition is to eliminate all indexes that have been used in some fashion. In this ...
  • Ron Moses about Seldom Used Indexes
    I do have a follow-up question, if you don't mind. What exactly is the purpose of this line: And (user_seeks ...
  • Jason Brimhall about Seldom Used Indexes
    Thanks. I am glad you said test. I can't stress enough the importance to research and test before ...
  • Ron Moses about Seldom Used Indexes
    One of my scheduled tasks for today was to work on a script to do exactly this. Thanks for ...
  • Jason Brimhall about T-SQL Tuesday #028 – Jack o…
    Muddy is an interesting way of stating it. Seems like something else is more fitting;)
Welcome , today is Thursday, May 17, 2012