Blogs

SSMS Shortcuts & Secrets - Live Webcast Edition (video)

SSMS Shortcuts & Secrets - Live Webcast Edition (video)

on September 11, 2017 • 1 min read

Category: ssms , sql-server
Tags: ssms

Last week, I had a great time giving a webcast for the terrific DBA Fundamentals Virtual Chapter. If you like free online training, check them out and sign up for future events.

Continue reading

SQL PASS Summit 2017: Tips on Attending

SQL PASS Summit 2017: Tips on Attending

on September 7, 2017 • 16 min read

I’ll be attending and presenting at the SQL PASS Summit in Seattle Washington this year from Oct 31-Nov 3. In this week’s 19 minute episode, I share why I’m excited about going and why I’ve purchased a seat for a pre-conference session. I also give my tips on how to get the most value out of a big conference like the PASS Summit.

Continue reading

Shortcut Update: Toggling Intellisense in SSMS

Shortcut Update: Toggling Intellisense in SSMS

By Kendra Little on September 6, 2017 • 1 min read

I like to use the keyboard whenever I can in SQL Server Management Studio. It’s not always easy to remember every shortcut though– especially when those shortcuts change!

Since around the SQL Server 2012 era, you’ve been able to switch Intellisense on or  off on SSMS with the shortcut chord: CTRL + Q, CTRL + I. I remembered this as “Control Quacky Intellisense.”

Continue reading

How Do You Stay Motivated? (Dear SQL DBA Episode 47)

How Do You Stay Motivated? (Dear SQL DBA Episode 47)

on September 1, 2017 • 13 min read

Over the years, readers have asked me: “How do you stay motivated?” Sticking with a learning plan, blogging, or becoming a public speaker isn’t easy.

In this 15 minute episode, I share how I think about motivation and what keeps me going.

Continue reading

Why Did My Clever Index Change Backfire? (free video)

Why Did My Clever Index Change Backfire? (free video)

on August 30, 2017 • 1 min read

I had a great time giving a session recently for the 24 Hours of PASS - Summit Preview Edition.

Continue reading

You faked your resume... now what? (video with transcript)

You faked your resume... now what? (video with transcript)

on August 25, 2017 • 12 min read

This week’s question from a reader: “How do I deal with interview questions asking about real-world scenarios when I’ve faked three years of experience on my resume?”

Hear my answer in this 14 minute video.

Continue reading

sp_query_store_flush_db, Query Store, and Backups

sp_query_store_flush_db, Query Store, and Backups

on August 23, 2017 • 2 min read

One of the cool things about Query Store is that you can back it up with the database.

This isn’t perfect for every situation, because you must back up the whole database. If you’ve got a multi-terabyte database, your Query Store isn’t super portable! But still, it’s great to have an option.

Continue reading