Browsing articles tagged with " Speaking"

The Key to Keys: NTSSUG 17 March

Mar 17, 2016   //   by Karen Lopez   //    //  No Comments

Level: Intermediate

So many of us have learned database design approaches from working with one database or data technology. We may have used only one data modeling or development tool. That means our vocabularies around identifiers and keys tend to be product specific. Do you know the difference between a unique index and a unique key? What about the difference between RI, FK and AK? These concepts span data activities and it’s important that your team understand each other and where they, their tools and approaches need to support these features. We’ll look at the generic and proprietary terms for these concepts, as well as where they fit in the database design process. We’ll also look at implementation options in SQL Server and other DBMSs.

I’ll be speaking about keys: primary keys, surrogate keys, clustered keys, GUIDs, SEQUENCEs, alternate keys…well, there’s a lot to cover about such a simple topic.  The reason I put this presentation together is I see a lot of confusion about these topics. Some of it’s about terminology (“I can’t find anything about alternate keys in SQL Server…what the heck is that, anyway”), some of it is misunderstandings (“what do you mean IDENTITIES aren’t unique! of course they are…they are primary keys!”), some of it is just new (“Why the heck would anyone want to use a SEQUENCE?”).

SQL Server Konferenz

Feb 23, 2016   //   by Karen Lopez   //    //  No Comments

Karen will be presenting on Ticking Timebombs in Your Database with Thomas LaRock (@sqlrockstar) in Darmstadt, Germany.  Register at www.sqlkonferenz.de ,

TECHunplugged Austin 2016

Feb 2, 2016   //   by Karen Lopez   //    //  No Comments

On 2 February I’ll be speaking at TECHUnplugged Austin, Texas. This event, which has free registration, focuses on how technology innovation is changing business and IT.

TECHunplugged logo

TECHunplugged is a full day conference focused on cloud computing and IT infrastructure.

Its innovative formula combines three essential parts of the industry for an exceptional exchange of information, insights and education:

– A group of independent, insightful and well-recognized influencers
– Leading disruptive technology vendors,
– End users who manage rich technology environments.

The ultimate goal of TECHUnplugged Conference is to bring quality information to IT decision makers by bringing them together with independent influencers and industry vendors, to engage, debate and be informed through open discussions on topics such as IT infrastructure, virtualization, cloud computing and storage.

I’m going to be talking about how data has changed over the years and how data quality issues can become obstacles to business innovation.

If you are in IT and would like to attend, use the registration form below. If you use my special code, you’ll be entered to win a special prize of an Amazon Echo (I SO LOVE MINE!) at the event.

My promotional code is:

infoadvisors

Yes, all lowercase.

Hope to see you there!

Database Design Throwdown – Austin SQLSaturday

Jan 30, 2016   //   by Karen Lopez   //    //  No Comments

Database Design Throwdown

Speaker(s):  Karen Lopez Thomas LaRock

Duration: 60 minutes

Track: Application & Database Development

Everyone agrees that great database performance starts with a great database design. Unfortunately, not everyone agrees which design options are best. Data architects and DBAs have debated database design best practices for decades. Systems built to handle current workloads are unable to maintain performance as workloads increase.Attend this new and improved session and join the debate about the pros and cons of database design decisions. This debate includes topics such as logical design, data types, primary keys, indexes, refactoring, code-first generators, and even the cloud. Learn about the contentious issues that most affect your end users and how to avoid them.

SQLSaturdays are free to attend, usually with an option to pay for lunch if you’d like.

 

 

 

7 Databases in 170 Minutes: Workshop at NoSQLNow!

Jan 26, 2016   //   by Karen Lopez   //   Blog, Database, Database Design, DLBlog, Events, NoSQL, Speaking, Training  //  No Comments

image

My friend Joey D’Antoni ( @jdanton | blog ) and I will be giving a workshop at NoSQLNow! about new database and datastore technologies like Hadoop, Neo4j, Cassandra, Vertica, Document DB, and others.  This will be a fast-paced, demo-heavy, practical sessions for data professionals.  We’ll talk about where a modern data architecture would best use these technologies and why it’s not an either/or question for relational solutions in a successful enterprise. And, as always, our goal is to make the time we spend fun and interactive.   This session will be a great starting point for some other session on Monday that go into data modeling for NoSQL as well as for all the other in-depth, database-specific talks the rest of the week.

Sunday, April 17, 2016
Level:
Intermediate

imageWe’ve been busy keeping relational data consistent, high quality, and available. But over the last few years, new database and datastore technologies have come to the enterprise with different data stories. Do we need all our data to be consistent everywhere? What does data quality mean for analytics? Will we need relational database?

Learn how traditional and new database technologies fit in a modern data architecture. We will talk about the underlying concepts and terminology such as CAP, ACID and BASE and how they form the basis of evaluating each of the categories of databases. Learn about graph, Hadoop, relational, key value, document, columnar, and column family databases and how and when they should be considered. We’ll show you demos of each.

Finally, we will wrap up with 7+ tips for working with new hybrid data architectures: tools, techniques and standards.

 REGISTER

Use code “DATACHICK” to save:

$100 off for  Tutorials Only + Seminar Only Registration and $200 off for Full Event, Conference+Tutorials, Conference +Seminar, and Conference Only Registration.

Super early registration ends 29 January, so take advantage of both discounts now (yes, they stack!).

Database Design Throwdown, Texas Style

Jan 21, 2016   //   by Karen Lopez   //   Blog, Data, Data Modeling, Database, Database Design, DLBlog, Events, Fun, Snark, Speaking, SQL Server  //  3 Comments

SQLSaturday #461 - Austin 2016

It’s a new year and I’ve given Thomas LaRock (@@sqlrockstar | blog ) a few months to recover and ramp up his training since our last Throwdown.  The trophies from all my wins are really cluttering my office and I feel back that Tom has not yet had a chance to claim victory.  So we will battling again in just a few days.

I’ll be dishing out the knowledge along with a handkerchief for Tom to wipe up his tears at SQL Saturday #461 Austin, TX on 30 January 2016.  This full day community-driven event features real database professionals giving free presentations on SQL Server and Data Platform topics.  All you need to do is register (again, it’s free) before all the tickets are gone.

Database Design Throwdown

Speaker(s):  Karen Lopez Thomas LaRock

Duration: 60 minutes

Track: Application & Database Development

Everyone agrees that great database performance starts with a great database design. Unfortunately, not everyone agrees which design options are best. Data architects and DBAs have debated database design best practices for decades. Systems built to handle current workloads are unable to maintain performance as workloads increase.Attend this new and improved session and join the debate about the pros and cons of database design decisions. This debate includes topics such as logical design, data types, primary keys, indexes, refactoring, code-first generators, and even the cloud. Learn about the contentious issues that most affect your end users and how to avoid them.

One of the other great benefits of attending these events is that you get to network with other data professionals who are working on project just like yours…or ones you will likely work on at some point.

Join us an other data pros to talk about data, databases and projects. And make sure you give a #datahug to Tom after the Throwdown. He’s gonna need it.

PASS Summit 2014 Speaker Idol—Judging You, Part I

Nov 13, 2014   //   by Karen Lopez   //   Blog, DLBlog, Fun, Speaking, SQL Server  //  No Comments

PASS Summit Judges/Judgey Table Sign

This year we had a new item at the 2014 PASS Summit: Speaker Idol. Run by Denny Cherry ( blogs | @mrdenny ), this is a contest where people who have never been selected to speak at Summit get the opportunity to win a golden ticket (an automatic speaking slot) at Summit 2015. To win, speakers must put together a 5 minute lightning talk, then impress the judges more than any other speaker in the competition.

I competed in a similar contest at TechEd two years ago. The difficult part about this is there are no criteria for which you can prepare. You don’t know what the judges think are good habits or what topics they might enjoy. They might even give conflicting advice. It takes a lot of courage to stand up in front of a crowd, give your presentation, then be critiqued by others in front of a crowd.

A few of us judges are blogging today about the things we commented on to the presenters:

Denny Cherry discusses the overall process used to put it all together

Joey D’Antoni focused mostly on physical presence while speaking

If others blog, I’ll update this post with links.

Today I’m going to continue on with Joey’s theme of physical presence.

Move, But Don’t Wander

It’s really difficult when you are stressed or nervous to get the timing and location of moving around right. Some people hug the lectern as if they are on flight experiencing extreme turbulence. Others pace back and forth like a caged animal hungry for fresh meat. At some conferences at Summit, this is compounded by a speaker set up where there’s a table, a lectern and several chairs. The AV equipment is often taped or strapped down so that your laptop must be located on the lectern. I find this annoying because presenting isn’t the same as giving a speech. Presenting and training involve more discussions with the audience and need more engagement than just speaking at a group of people.

The raised podium effect also means that moving around can lead to falling off the stage. Not a good thing.

Joey gave advice to stand with your feet together. I usually give other advice: stand with your feet shoulder’s width apart, then move your feet about 3 inches further apart. This sort of forces you to stay put for a while because it feels slightly off, but not enough to make it feel awkward. It’s harder to move out of that stance and it tends to be a more powerful, competent looking to the audience. Move around to ensure you aren’t blocking the same audience members for your whole presentation. Move to show that you and the audience are working together to learn.

Remember: pacing back and forth is bad, but taking a few steps in a variety of directions can help you engage different members of the audience. Have a purpose when you move.

A Mic Changes Everything

Most speakers would prefer not to use a microphone. A hand mic plus a remote means both our hands are tied up. A lavaliere mic (one that clips on your shirt and has a pack that has to be stuck in a pocket or worn in the back) means everything you do or say is being amplified. But when sessions are recorded, broadcast or in large rooms, audio equipment is mandatory.

One of the more common mistakes the speakers made was leaning forward then turning their heads to read the slides on the screen. This meant that as they were talking, they were talking away from the mic. We judges were in the front row and I had a hard time hearing what was said.

The trick is to turn your whole body when you are mic-ed up. Do this even when you are turning to speak to an audience member and to highlight something on the screen.

Remember: The audio portion of your presentation is just as important as the visuals. Probably even more important.

Don’t Read Your Slides to the Audience

This is a tough habit to break, especially if you are running short on time. It’s the most common feedback I hear from people who are attending sessions and are frustrated by the speaker. This is especially common with lightning talks because time is so limited. If you read your slides to the audience, you are basically showing them that you don’t really need to be there speaking. You could just email blast out your slides and be sitting in the bar enjoying a conference-themed beverage.

One of the ways to break this habit is to have fewer words on your slides. More on this later.

Another way is to have speaker notes that you can see when you are presenting. These should have different words/bullet points and that will force you to explain things in different words. PowerPoint shows these notes when you are in presentation mode.

The best way to break this habit, though, is to not look at your slides when you speak. Look at the audience. Engage with them. Offer insights into what is on the slides, but do that while having a conversation with the audience.

Remember: You are there to give insights and to engage with the audience. Your slides are there to support that, not the other way around.

More…

One of the more interesting things about being a judge is that we all talked about how we are also guilty of many of these speaker vices.  We recognized that while we were giving all this advice, we all needed to take care when we presented, too.  I’m sure it was difficult for the contestants to be judged in public.  It was difficult for us doing that as well.

I’ve blogged about what to do when something goes wrong during your presentation, but I’ll be blogging about those things and more as part of this series.  I’ll be talking about equipment, preparation and delivery. Plus being judge-y Smile.

Subscribe via E-mail

Use the link below to receive posts via e-mail. Unsubscribe at any time. Subscribe to www.datamodel.com by Email


Categories

Archive

UA-52726617-1