Tag: syndicated

  • T-SQL Tuesday #80–Chris Yates’ Birthday

    tsqltuesdayIt’s the 80th version of T-SQL Tuesday. You can see all the parties from the past on my page, but feel free to jump in here or elsewhere. This is a monthly event, where anyone can write on a topic.

    This month’s invitation is from Chris Yates, with today being his birthday.

    Happy Birthday, Chris!

    The topic is open this month, so here we go.

    SQL Server Isn’t Easy Enough

    I think that SQL Server is a fairly easy system to work with. I first started working with SQL Server on OS/2 1.3, and had come from working with lots of Unix, DOS, and Netware command lines. Windows 3.1 was still new, and we thought all the various command line tools for SQL Server were great.

    Even as I continued on in my career, working with Oracle on multiple platforms, DB2, and other relational systems, SQL Server was the easiest to use.

    However, I still find some simple, easy things that aren’t easy to handle. I think there is work being done with some of these items in Redmond (nothing specific I know or can say, but just a feeling), but these items have been an issue for some time.

    Database and Log Backups

    One of the really simple things many SQL Server professionals know is that we need to schedule at least one full backup to run, and then regular log backups, at least by default. The alternative is to set the database to simple recovery (not the default).

    The problem is that for many installations, people don’t realize that they need to do this. While it’s easy to say they should learn this, it’s also silly. This could be easily handled with software setup. Create a default backup setup for each new database, as part of the database creation wizard.

    I’d really like to see these defined in the database themselves, and loaded into the instance from the database, and hopefully we’ll get there.

    Replication

    I don’t have specific complaints here, though I could come up with some. The real issue I see is that replication is very brittle. The way replication works, and it’s barely changed in a long time, is that it requires lots of setup, and isn’t tolerant of issues. Far, far too often the solution when deploying changes to the database, or troubleshooting issues is to drop replication and re-enable it.

    Most people running replication have been burned and end up scripting everything as soon as it’s set up.

    This shouldn’t be that hard, or at the very least, some work should be done to improve the robustness of replication.

    More

    There could be other things, but I’ll stop here, and see what else people say about SQL Server this month.

  • Using sp_executesql Parameters –#SQLNewBlogger

    Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

    I haven’t used sp_executesql much. Instead, my habitually way of executing dynamic SQL has been with EXEC(). There are a few differences between these commands, but I had to look at sp_executesql recently and realized I didn’t know much about it.

    One of the neat things with sp_executesql is that you can pass in parameters.  That’s pretty cool. I hadn’t ever bothered, but if you read the docs, you’ll see that if you execute the same code over and over, with different parameters, you might get the same execution plan. This can be a performance boost.

    NOTE: THIS IS NOT ALWAYS BETTER. It can be.

    I’m not going to delve into deep details, but Kimberly Tripp does so read her post (and then write your own thoughts).

    The Code

    Here’s some code to demonstrate. I have a simple table with 3 columns to insert. In this case, here’s my insert:

    INSERT EventLogger VALUES (@m, @d, @u)

    Now, I went to use this over and over, but with different values for the parameters. Obviously I can just do this:

    SET @m = ‘Error Message’

    INSERT EventLogger VALUES (@m, @d, @u)

    SET @m = ‘New Error Message’

    INSERT EventLogger VALUES (@m, @d, @u)

    However, imagine that I’m building this INSERT string dynamically because it’s more complex. How do I execute this over and over with new values? With EXEC(), I rebuild the string. With sp_executesql, I do this:

    DECLARE @cmd NVARCHAR(MAX)
    DECLARE @dt DATETIME = GETDATE();
    DECLARE @msg VARCHAR(200) = ‘An error occured’;
    DECLARE @usr VARCHAR(10) = ‘Steve’;
    DECLARE @p NVARCHAR(500);

    SELECT @cmd = N’INSERT EventLogger VALUES (@m, @d, @u)’

    SELECT @p = N’@m varchar(200), @d datetime, @u varchar(10)’

    EXEC sp_executesql @cmd, @p, @m = @msg, @d = @dt, @u = @usr;

    SELECT @dt = GETDATE()
         , @msg = ‘A new error occured’
         , @usr = ‘Bob’;

    EXEC sp_executesql @cmd, @p, @m = @msg, @d = @dt, @u = @usr;
    GO
    SELECT top 10
      *
    FROM dbo.EventLogger AS el

    Now, I check the table:
    2016-06-22 15_00_08-Settings

    I thought that was cool.

    SQLNewBlogger

    This isn’t a deep post. It’s a light look, with a little explanation. I’ll do more later. However, I’m hoping this serves as a way to show you how to start investigating a topic. I’ve spent a bit of time experimenting and learning. I’m fairly confident I could play and use sp_executesql more.

    You could do this as well, start digging into a topic and then show how you’re learning.

  • Choosing Content for the Summit

    This is a series of posts on the PASS Summit and SQL Saturdays. I’m outlining some thoughts here, sometimes for the first time, but on topics that I think make better events. These are opinions and thoughts, not mandates or demands. I’ve written on choosing speakers and debuting content.

    Update: added a comment from another set of feedback

    Tl;dr: We need to review and examine comments made on abstracts as a community and a professional organization. Ultimately the program committee has a tough job, but I think we can better prepare people to both critically review abstracts and choose great content that makes the Summit an incredible event.

    As the PASS Summit selections were released in June, a few of the speakers posted their submissions and the comments they received from the program committee. I think this is great, and I’d really encourage every speaker to do this. Whether you were selected or not, this is good data to better understand how the committee works and how sessions get evaluated.

    This will change year to year, as committee members change. It’s good to understand the viewpoints this year, along with the results. Debate and discussion is good here, and will help shape the views of new volunteers in the future, so I’d encourage it.

    In fact, if speakers want to publish on their blogs and send links, I’ll compile a list. Here’s what I’ve seen so far:

    Not a big list. I don’t have anything because I didn’t submit this year.

    But I’m getting distracted. What I wanted to talk about is…

    How Should We Choose Content?

    It’s always interested to hear various people involved in the process at events talk about this. For the most part it comes across like the strategy many business people employ. They think a little, make a guess, and hope it works well.

    If anyone tells you they know what people want to see, then go look at the rooms at the event and see how well the audience matches up with the size of the room. There are plenty of mistakes that showcase themselves with too few, or too many, people in a room.

    And how could they know? When the schedule is picked, no one really has much of an idea on who is actually attending. Most of the registrations will come as the event gets closer. In addition, we’re all fickle and subject to the changing requirements and demands of our jobs. We might think PowerBI is a joke (or incredibly necessary) right now, but our view could change 180 degrees by October.

    There isn’t a perfect system. And I’m not saying that I think the program committee did a bad job. On the contrary, it’s a hard, thankless job, and someone will always complain about the process. My intention isn’t to do that, but rather discuss what is good feedback and what isn’t.

    I hope the volunteers next year are better prepared and have some idea of how attendees and speakers view their thoughts. I also hope we publish better guidelines, both for reviewers to better choose sessions, but also for attendee comment. I’d like to know what attendees actually want to see or what they think is a good session.

    Lastly, for reviewers, you need to pick sessions for the attendees. I know  many of you are attendees, but there are many, many more attendees that you need to consider. It’s easy to get trapped into picking what you like, which may not make a great conference schedule.

    The reason I think this is important is that none of us necessarily has great skills as a critic, which is what reviewers do here. Many of us learned about how to examine writing in school and provide an analysis. Those skills wane, and should be both practiced and critiqued.

    Comments on Comments

    You can read the various posts above and look at comment, but I have a few thoughts on what items were added to the abstracts.

    Note, this section is long, and I’ve mixed up comments from the various people that published items above.

    Comments I Like

    “Goals align w/ abstract description. Demonstration of Brent Ozar tools is a must for all SQL Administrators. Topic: Interesting for attendees and would gain an audience. Title reflects content.Interesting session for those seeking performance solutions. Objective: Level and prerequisites match goals. Material matches subject and could be presented in 75 minutes.”Excellent feedback and detailed. I like the disclosure and notes about how the abstract/goals/title relate.

    “The outline seems well developed. The outline seems to clearly describe the contents of the presentation. The topic and goals should be compelling to attendees. The topic appears to be timely, new and relevant. There appears to be a reasonable amount of live demonstrations in relation to the topic being presented. The topic and goals appear to deliver an appropriate amount of material for the time allotted.” – Again, good feedback with detail that shows the reviewer thought through this and attempted to clarify what they saw.

    “Whilst I get why the title might have chartaphobia in it – it still didn’t sound right. It’s not an actual word. The abstract is good, it does tell me that I may have charts but they’re “hideous and disgusting”. This didn’t sound nice and might turn some audience members away. The topic of Power BI is a good topic, the delivery just needs some work for a 100 level – explain earlier in the abstract how Power BI will make the charts better or exist at all.” – I like this feedback. It’s detailed with pointers to why the reviewer drew conclusions.

    “Well written outline with clear goals and an outline that lets the attendee know exactly what will be achieved from the session. The topic is one that I think appeals to any data professional who has …” – This is good feedback. The goals match the abstract and inform the attendee. Why is the topic good? There’s more, but I left it off.

    “Basic and 300 don’t coincide. Need to decide is it an advanced topic or not.” – This is a good comment that explains why this abstract needs work.

    “I like the Shakespearean twist to the abstract, but I feel like it is really lacking in content to let an attendee know what they would really be coming into (outside of learning about whether to get certified or not).” – A good list of what is wrong. I agree. There isn’t quite enough to entice someone and let them know what’s coming. It’s not bad, but could be better.

    Comments I Don’t Like

    “…should be 200 level – the title sounds like a deep dive, not entry level.” – OK, so not entry level, but deep dive is 200? Levels are somewhat silly, but clearly we have a typo (meant 300/400) or a big mismatch in what 200 is. Maybe we need better guidelines on what 100/200/300/400/500 are?

    “detailed but not compelling” – I really dislike very general comments like this. Why isn’t this compelling? Is it that you don’t like the topic? You know it already? I’ve made comments like this (for abstracts and in VCS), and this is decidedly unhelpful. As a reviewer, stop and think about what you don’t like and express that. If you can’t, you need to work on that skill.

    Personally, I feel this is more suited to an SQL Saturday”What? I’ve given quite a few sessions at a SQL Saturday that I’ve delivered at PASS. Same for sessions I’ve seen. Who thinks we do better or worse sessions at one event or the other?

    “Also session has no indicated real examples!” – I thought this was funny because the abstract mentions volunteering, speaking, blogging, and organizing events. What “real” examples are needed?

    “Abstract is a bit rough but good enough to capture attention, describe the topic, and provides reasons why someone should attend.” – I like the detail, but what does “rough” mean? I have my impression, but I’d rather see this articulated as “difficult to read and understand the content” or “the formatting is offputting.” Note, this is why we should have some re-review and perhaps copy edit of sessions accepted. At least let the author fix things.

    “Very focused topic – great for a lightning talk. Very good prerequisites and goals. The abstract is entertaining yet clear.” – Good comments, but not great. What does “good” mean? The pre-reqs should match the goals, is that what happened?

    A two-fer here: These are two comments:

    • Well written abstract, but it doesn’t appear appealing with only 25% demo and no real examples
    • This seems like the right length to really kick start learning R.

    OK, is length the amount of material or something else? I don’t like that word, but we have two reviewers with what seems to be opposite views. I tend to agree with the first one, there need to be examples and for this, 25% seems low. But I think we should debate when comments are vastly different and someone should perhaps think about more training or declining a repeat volunteer request.

    A seven-fer:

    • Sounds like it could be a good session but the abstract seemed all over the place. Hard to follow.
    • abstract seems to ramble. grammatical anomalies. punctuation misuse.
    • Fantastic topic, and extremely well-constructed abstract!
    • Well written abstract, sold me in easily. Seems to be on level. Clear goals.
    • Nice abstract with clear goals and outlines.
    • Abstract OK. Learning goals a bit roughly defined – could be more precise in this narrow topic.
    • Good abstract. Could be an interesting session to attendees.

    This means that we don’t have reviewers that are on similar pages. I am unclear how people could view this so vastly differently. The group of people that wrote these comments need to have a root cause analysis of what happened here. Or this needs to be a case study for next year’s reviewers.

    Note, I’ll say that I think the abstract did get off track and a little unfocused in explaining what will be covered. A few grammar mistakes I forgive, but it also needs some tightening with fewer words and more focus on what’s covered.

    “Only issue is the second sentence reads a little oddly.” – I agree with this one, but if you’re going to make this comment, expand. Why? Help someone better understand this tangled mess of a language we call English.

    “Abstract targeted at Mgr/Team Lead. Unfortunately this is not the typical audience at PASS Summit.”What’s the typical audience? Do we not look to have some atypical or niche sessions. This is a place that I wish reviewers would remember that not everyone goes to every session. There will be 15 or so sessions at any given time. Niche topics are OK.

    “level too low” – For a 100 jumpstart session with no pre-reqs. Again, why?

    “If there is a prerequisite, the session level should be 200 (instead of 100).” – OK, if this is a guideline for speakers, fine, but reviewers don’t get to make things up. I couldn’t find anything about this on the PASS site. The rest of the comment did ask for more details, which I do like.

    “Abstract is ok, with a few wording and grammar choices that could be improved/changed to make reading easier” –  I’m torn here. I think writing and grammar are important, and if the speaker makes mistakes here, they may do so in their Powerpoint and distract from the presentation. However, this process is also competitive and time sensitive, so minor issues I’d overlook and perhaps even have the speaker (or committee) correct for the event.

    Old topic for BIML. Need to add some new features.” – Stop this. What you learned isn’t what others know. We have people at all levels, so don’t program for your level. At worst, there should be guidelines about how many topics at a level for each area. Without that, don’t make these comments. This person, in my opinion, is a poor reviewer and critic.

    “Demo percentage seems low for such a topic but, overall, looks like a good session” – Do we have guidelines for how much demo per topic or type of session? If not, then DO NOT use this as your evaluation criteria. If we do, where is it?

    “topic is interesting but not really “hot” or “latest”.” – The rest of the comment is good, but here I’m confused. What does hot or latest matter? Are we trying to be hot or latest with all sessions? If not, and I’d say not, then why the comment?

    “goals not compelling” – Again, why not. What makes something compelling? Or at least describe what isn’t compelling to you, or for the audience.

    “can this really be covered in 10 minutes?” – First, who are you that you question the speaker’s ability here. Especially if you don’t know if this is Joe Developer or Stacia Misner. Don’t make these comments if you haven’t seen the session. If you have, disclose that. If you think there is too much content for the time, note that, but I think this is too subjective a comment. Your (the reviewer’s) learning or teaching ability is not being evaluated here.

    “Abstract: not compelling attendees. Topic: goals are very low, I don’t think this session is interesting” – I realize that reviewers might be rushed, but this is poor. Not compelling attendees? What does that mean? It’s a comment that doesn’t help, and by the way, I disagree. The second part of this also isn’t detailed. What is too low? I’d disagree. The goals list things that are specific, and certainly not what I’d call too basic. The last item shows the reviewer’s thoughts, which should be low weighted. This is about what a percentage of the attendees will want. Not all of them, some of them.

    “This is more related to dba track rather than prodev. Also is survival really career development? Many would say that working 15 years as a lone dba could equate to failure in some peoples eye’s and I would struggle to want to see this session based upon info provided.” – I’m surprised this got through the review process from Lance and Mindy. I know they read a lot of comments, but this one is unprofessional and rude. The first part and the last partial sentence are fair. Those are opinions, though I think this is easily a pro-dev topic. The second sentence shows how many reviewers see the world very narrowly. I think the abstract was on balancing workload and life, which is professional development. My opinion here. However noting the someone is a failure for working the same job 15 years is ridiculous. The lone DBA is a company decision, not an individual one, but apart from the grammar errors, this one shows a person that is quite myopic on what a successful career looks like. I wouldn’t have this person back reviewing abstracts.

    “Dinking the abstract rating for identifying information.” – I. Hate. This.

    Honestly, I think this is a jealousy or pet peeve for a few people over, well, I’ll say it, Brent Ozar’s marketing. He does it well, better than most people and this comment/attitude is crap. Go look at all the marketing for all conferences. They mention the speaker’s names. Speakers attract attendees. If we don’t care about the speakers, why do we have this page? If you want a speaker independent review, then blank out the names, but don’t ding abstracts for this.

     

     

    Final Thoughts

    This is a subjective process. I am glad at least three people review the abstracts because any one person might not like the topic/speaker, have a bad day, not be interested in the topic, etc.

    For the record, I’m no better and have to constantly remind myself as I choose content and edit articles that it’s not my opinion. I have to think more broadly and put myself in the position of the beginner, the intermediate person, the expert DBA that’s getting into R, the person that wants to delve deeply into a topic.

    Really I want this to be discussed and debated on a few levels. What guidelines should reviewers use, and what feedback helps speakers. I would like to see a better program that helps build a better event overall. Again, we all could use skills in evaluating sessions better, so make this more public and let’s ensure those that volunteer have better guidelines on how to examine abstracts.

    Lastly, I think judging based on levels is silly. We can’t agree on this, so if you think the level is too high or low, that can be adjusted. Make a comment this should be XX and let’s have speakers edit this before the schedule is released.The same thing for minor spelling or grammar, or phrasing. Let’s remember we have a lot of non-English speakers, and correct some of these items rather than just saying a native English speaker would deliver a better session.

    Let’s remember, writing != speaking.

  • Long Term Pebble Classic Review

    I got a Pebble Classic watch for Christmas a few years ago, in Dec 2014 to be clear. That’s (as of now) about 18 months of use. I haven’t used it every day, but I’ve used it often, and here are a few things that I wanted to put down as a long term look at this device.

    This is the first smartwatch I’ve owned. I’ve been a Timex Ironman (or some variation) person for most of my life. I went about two years with just my cell phone when my last watch died and decided I didn’t like that, so I got the Pebble.

    tl;dr – I have really enjoyed the watch, but I’m not sure I want a (nother) device that lasts a year or two.

    Current Status

    The watch still works, though I have found that I need to charge it every 3-4 days. This seems in contrast to when I originally got it and the battery would last 6-7 days. In fact, early on I forgot my cord and went to the UK. I left Monday, returned Saturday, and the Pebble made it.

    The big issue, for me, is that I have screen tearing. There are times I can’t read anything, though changing watch faces usually corrects things. However, when you’re doing something and want to check the time and can’t see it, you don’t always want to do this. For example, I’ve been out working in the field, with dirty hands, and I couldn’t get the time without getting grease all over the watch.

    Looking Back at First Impressions

    I wrote about the watch when I got it. For the most part, things still work for me. I use the watch to change music when I’m traveling, and I get text messages on it. However, sometimes I get too many messages, and need to go through menus to turn off notifications from the phone. It’s annoying, but that’s somehow what happens with apps that notify you.

    I haven’t done much with timing on the watch, but I’ve usually found the phone to be more useful here.

    In terms of running, I wasn’t running a ton when I got the watch, but I run daily now. Perhaps that’s why the battery doesn’t last. Each time to flick your wrist, the backlight comes on, which is a lot when I run. I’ve noticed it on the treadmill. Perhaps the backlight doesn’t happen outside? Hard to tell.

    I do love the MapMyRun integration to see my time/pace. I use the audio coaching for motivation, but it’s nice to glance down and see my pace as I go. I wish this allowed me to change music and go back to the tracking, but I haven’t seen that work.

    Alarms

    One thing I’ve done a few times is use the alarms on the Pebble to wake me. The vibration is quieter and better when I need to get up at 5am for a flight, and this doesn’t wake my wife. It’s kind of nice. It’s also a great second alarm in hotels.

    However. I do forget to turn it off and the default is to repeat the alarm the next day. Good when I travel, bad when I come home and set it on the nightstand to charge. The vibration on wood is loud enough to wake my wife.

    Annoyances

    There are a few things that bug me. I have the phone sync sometimes fail, and I’ve struggled to get my Pebble reconnected without forgetting the device and doing a new phone pairing. It’s been simple sometimes, frustrating other times.

    The screen tearing is really annoying, as is the lack of battery life. It’s still better than daily charging for something like an Apple Watch or Samsung Watch.

    There isn’t good support for step tracking unless I have an app on the phone all the time. Not what I want and I miss this a bit since my Fitbit was lost.

    The band isn’t great, though that’s on me. I should get an aftermarket band that I like.

    How Long Should This Last?

    That’s a good question. The Pebble warranty is one year. I’m obviously past that. As a comparison, Timex provides a year as well. 30 days replacement online, then warranty replacement.

    However, I’ve usually had Timex watches last for 4-5 years. This seemed flaky at 14 months, which feels a bit like too short a period.

    What would I want? If this lasted two years, do I think that’s OK?  I think crossing a year mark has psychological significance. Now it feels like a one year old watch, but if it made it to December, that would be two.

    Ultimately I’m not sure. I know some people have had these last a couple years, so maybe that was just my luck.

    The Verdict

    The Pebble does most of what I need and want, and it’s been a good watch. I’m disappointed in the screen tearing, but it’s not unusable at this point. I can’t think of much more I’d want other than constant step tracking.

    I’ll need a replacement this year, I’m guessing. There is a Kickstarter for the newer Pebble 2, which will have heart rate monitoring. That interests me, as does the Core. The idea of not needing a phone and just carrying the Core is nice.

    I’m not into color or a lot of other features, and don’t like charging. The Apple Watch is out for that reason (and likely other Android wear). Pebble 2 is interesting, as is the Microsoft Band, but I’ll have to think a bit. Maybe I’ll go steel and see if that’s more durable?

    At the end of the day, I think Pebble is a good device for your wrist, if you want one.