Getting the talent to behave was the biggest challenge. The answer: sushi.
I posted a video chat this morning on Facebook.
It’s talking about my blog post, “It’s a Lock: Due Diligence, Schema Changes, and You” on BrentOzar.com.
Let me know what you think about the video. It could be the first of a series. (There will be more blog posts on locking for sure.)
SQL Server Pickup Lines Not Included
Next week the Professional Association for SQL Server will be providing 24 hours of free, online training on SQL Server.
Come get your learn on.
My talk will be next Tuesday, March 15 at 10 AM Pacific / 1 PM Eastern / 5 PM GMT.
It is Session 06: No More Bad Dates: Using Temporal Data Wisely.
Register for sessions here. There are many great sessions on Tuesday and Wednesday– pick what fits you, and you’ll receive a calendar invite with a link to the LiveMeeting for each one. (Timezones are listed in GMT, which can be confusing for the people of North America, particularly since Daylight Savings is coming to some of us this weekend. The calendar invites will help, I promise!)
My session is on best practices for choosing date and time types in schema, with lots of tips for writing queries working with dates and times.
I love the talk I’m giving on dates and times because I get to cut across different areas– I get to talk about data types, choices in schema design, and how to write T-SQL. I also get to talk about little-known features of SQL Server, and give lots of tips and tricks along the way.
Working on this presentation has been a really fun journey. It began when I noticed in Books Online that the datetime data type is officially no longer recommended for new development– and this has been the case for three years!
This is rarely discussed and, except for DATE, the new types are rarely used. So I began to ask the question: is it ever worth converting existing schemas to the new types? Is there any reason to still use older types, such as SMALLDATETIME? What do you sacrifice if you don’t use the new DATETIME2 type, and are there any issues if you start using it? What are the most common, but least known problems when working with dates?
It’s fun to give practical, useful advice. I recently gave this talk at SQL Saturday #65 in Vancouver, BC, and had a great audience. I asked them to share with me whether they learned anything new, or were surprised by what I covered.
I heard back from more than ten people in the audience in person or by email, and all but one said they learned something new. Everyone had worked with date and time types before. They were also great at letting me know which topics could use a little more detail and clarity.
Most people commented that they were surprised by the talk, and that things are trickier than they’d understood.
This month’s #tsql2sDay is hosted by Jen McCown ( blog | twitter ) and Jen’s question is “What techie resolutions have you been pondering, and why?”
And a quick congrats to Ms McCown on her new SQL Server MVP Award!
Last night I wondered, “How would I draw a picture of the Storage Engine?”
So that’s what I’m going to do this year. I’m going to draw the storage engine and all its friends, plus much more.
Not every blog post or presentation slide will have drawings, but there will be lots more than last year. (See that? That’s an achievably vague goal!)
mmmmmmmm
I think it helps share how I see the world.
But mostly I think it’s fun. I like to make my presentation slides colorful and interesting to look at.
I don’t think simple, creative art dumbs anything down. I think it just makes discussing complex concepts more fun, and having a playful image can make it easier to remember things.
I finally got a new drawing tablet, which I’ve wanted for ages. Unlike my old tiny tablet purchased long ago, this one has drivers that play nicely with my operating systems! I saved up my nickels and my family pitched in funds as my Christmas present, and now I have a lovely new Wacom Intuos tablet with which to create all sorts of madness.
I do all my drawing with The Gimp. I’ve used it for years and I love it. Thanks Gimp for being so awesome. And so free.
I knew you were going to ask that. So I asked it myself.
The optimizer is clearly an octopus with many pairs of eyeglasses.
Optimizeropus
What does it look like when an Octopus gets ahold of a bunch of cake? Keep reading this year to find out.
© 2012 LittleKendra.com. All Rights Reserved.
Powered by WordPress. Designed by 
Comments