21Jan 2011 by Grant Fritchey 63 Comments

A Friend of Red Gate No More

Misc
Don’t get me wrong. It’s been great. The beta tests. The advanced notices. The opportunity for feedback. It’s been a great relationship, a fantastic friendship. Look, it’s not you, it’s me. I want more. I want to take our relationship to the next level. That’s why I’m excited as can possibly be to announce that I’m no longer in the Friends of Red Gate program because I’m now a Red Gate employee. That’s right, I’m colored Red! This is an amazing opportunity to step up my game to a whole new level and I’m thrilled to be able to take advantage of it. I have a fascinating title: Product Evangelist. I’m going to be traveling around the country to various events, SQL Saturdays (Cleveland & Chicago already booked), SQL Rally,…
Read More
21Jan 2011 by Grant Fritchey 2 Comments

Deprecation, Trace and Execution Plans

SQL Server, T-SQL
As I’m sure you know, Microsoft occasionally changes it’s mind. Or, it makes bad decisions and then rectifies them. Or, it even reinforces bad decisions. Regardless of the purpose, the means by which these changes are implemented when they involve taking things away is deprecation. Usually in SQL Server the deprecation process is supposed to be over three releases. So while seeing something on the deprecation list can be cause for concern if it’s something you like, you certainly don’t need to panic. I’ve finally had a chance to start working with Denali and the place that concerned me most was in the areas of deprecation. I want to make sure that when I suggest a particular approach, that the approach isn’t going to disappear in a version or two.Which…
Read More
18Jan 2011 by Grant Fritchey 19 Comments

DBA 101: Why is my log file full?

SQL Server
This question comes up constantly in different venues. I see it sometimes 2-3 times a day on SQL Server Central. I know it pops up at least once a week on Ask SSC. I’m sure I’ve seen it on Twitter #sqlhelp. “Why is my log file growing?” and “Why is my log file full” are heard regularly. Or, the variation, “I ran a full backup but the log file is still full/growing.” occasionally comes up. The people asking these questions are frequently, even appropriately, frantic. I’m writing this blog post for two reasons. First, to try to add a little bit of weight to what must surely be one of the most searched for phrases on the internet when it comes to SQL Server. Second, just to have a shorthand…
Read More
14Jan 2011 by Grant Fritchey 11 Comments

Failed Blog Posts

Misc
Over the last week I've started and trashed two blog posts. Let me tell you, that's painful. You get some great idea and then it all goes south. For example, I was going to explain the difference between a table/heap scan and a clustered index scan. The problem was, I ran into gaps in my knowledge, some outright errors in my beliefs on how data was stored, and really faulty conclusions drawn from those facts and a less than thorough set of tests. I'm not even going to tell you what went wrong with the other notion. Luckily, all this was behind the scenes so I didn't post my ignorance for all to see.  Since I'm not offering you a chance to point & laugh (in this instance), you might…
Read More
11Jan 2011 by Grant Fritchey 5 Comments

TSQL Tuesday: Resolutions

Misc
Sounds like a good action adventure movie. The theme this month on TSQL Tuesday, thanks to our host, Jen McCown (blog|twitter) of SQLawesomesauce, is Resolutions. In particular, Techie Resolutions. I have to do this because Jen just received her MVP award, in case you’ve been under a rock since last week. I’m not a resolutions kind of guy. I tend to make plans. The plans might start on January 1st, or they might start as soon as they lawyers are done making up the contract. I’m not hung up on schedules except as they relate to due dates. For example, when submissions are due for the PASS Summit or something along those lines, then I’m date driven. In other words, I don’t sit down New Year’s Day or New Year’s…
Read More
05Jan 2011 by Grant Fritchey 4 Comments

Encryption and the Performance DMOs

T-SQL
Ever wonder what you can see in the performance oriented DMOs when stored procedures were encrypted? Me neither. But, I did get that question during my DMO presentation at the PASS Summit. I did not have an answer. I did get an answer from Johan Bijnens (twitter) from the audience, which I repeated without entirely knowing what I was saying. I decided that I ought to actually know the answer to that question, so here’s a little experiment. I'm going to create a simple stored procedure: CREATE PROCEDURE dbo.GetSalesDetails (@SalesOrderId INT) AS SELECT soh.AccountNumber, sod.LineTotal FROM Sales.SalesOrderHeader AS soh JOIN Sales.SalesOrderDetail AS sod ON soh.SalesOrderID = sod.SalesOrderID WHERE soh.SalesOrderID = @SalesOrderID When I create this procedure and run it, you can see the general performance of the query being run…
Read More
23Dec 2010 by Grant Fritchey 5 Comments

PASS Summit 2010 Survey Results

PASS
As I have done in previous years, I’m going to post the results from my sessions at the PASS Summit. Feedback is a gift. I received a great many gifts this year and I’m extremely happy about all of them. There are a set of questions with ratings, the higher the rating, the better you did. One exception to this rule is the question on time for the session. I think there, somewhat lower scores are better. There were 183 technical sessions rated during the Summit. I’m very honored to have been included in that list. Identifying and Fixing Performance Problems using Execution Plans: 286 Attendees, 172 Responses, Avg Score of 4.23, Placed 136th How would you rate the usefulness of the information presented in your day-to-day environment? 1 2…
Read More
20Dec 2010 by Grant Fritchey 12 Comments

The iPad/SQL Monitor Results

Misc
I ended up with 131 posts (1 late hit, sorry), not counting any duplicates with Brent or Steve. It was clear that people really took this thing seriously and put thought and effort into the posts. I wish I had about 60 iPad's to give away instead of only 10. But, decisions had to be made. The point system is utterly meaningless, but, points were awarded for pithiness (I warned you), for a well-turned phrase, and as much as I'm loathe to admit it, for poetry (just because of the work involved). Originally, I planned on just randomly picking the winner. But, I only had 131 entries, and you all worked so hard, I decided to read them all and work hard for you in return. This really was a…
Read More
15Dec 2010 by Grant Fritchey 8 Comments

The iPad, So Far

Misc
[caption id="attachment_1765" align="alignleft" width="300" caption="In the front yard, using the iPad & SQL Monitor"][/caption] After a great deal of unseemly begging, I managed to acquire an iPad. My intentions were to make it into a internet browser, email reader, blogging, and light writing machine. Additionally, I knew there'd be some time suck from games and I could set it up as a book reader, music player, movie viewer. I had hopes of possibly doing something resembling work with it. Illusions are easily shattered. Let's start with internet browsing. It's great. Really. As long as I stay away from Flash, which, for the most part, so far, I've been able to. +1 for the iPad. Email reading, it was easy to set up an email account, and there's a Google app,…
Read More
13Dec 2010 by Grant Fritchey 133 Comments

Life/Work Balance

SQL Server, Tools
Technology, especially information technology, is the greatest thing to ever happen to mankind, freeing us from toil and drudgery. Technology, especially information technology, is a pernicious evil taking over our lives forcing us to work harder and longer. Depending on the time of day, the day of the week, my mood, my wife’s mood, or the direction the wind is blowing, either of these statements could be true. The fact is, I love technology and I do have to wrestle with keeping it from taking over my life, but only because I have so much fun with the toys that technology brings. You want to know how much I love toys, ask me about my Droid sometime. Pull up a chair. We’re going to be here a while. The trick…
Read More