Database-Administration

Category: database-administration

Love and Hate for SSMS

Love and Hate for SSMS

on September 29, 2017

People have strong feelings about SQL Server Management Studio: they love it AND they hate it. In this week’s episode, I talk about why people have such conflicting feelings about SSMS, and how to work it all out.

Continue reading

New Free Webcasts for November and December 2017

New Free Webcasts for November and December 2017

By Kendra Little on September 28, 2017

I’ve Just Scheduled a Whole Batch o’ Free Webcasts!

Webcasts are held on Thursdays at 9 AM Pacific / noon Eastern / 4 pm UTC.

Here’s the upcoming slate of topics:

  • Oct 5 – RCSI and Snapshot Isolation
  • Oct 19 – Pressure Testing Memory
  • Oct 26 – What’s REALLY in That Index?
  • Nov 9 – Filtered Columnstore Indexes
  • Nov 16 – Defragging: Reorg or Rebuild?
  • Nov 30 – In-Memory Indexes & Isolation
  • Dec 7 – Indexing for Windowing Functions
  • Dec 14 – Serializable & Repeatable Read

I can’t wait to put together these presentations, and I hope to see you on Thursdays!

Continue reading

Do I Need to Master PowerShell?

Do I Need to Master PowerShell?

By Kendra Little on September 12, 2017

As a SQL Server DBA, do you need to be a master of PowerShell scripts?

In this 9 minute episode, I talk about how much you need to know about PowerShell, and examples of ways I personally use (and struggle with) PowerShell.

Continue reading

SQL PASS Summit 2017: Tips on Attending

SQL PASS Summit 2017: Tips on Attending

on September 7, 2017

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

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

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

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

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

on August 25, 2017

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