Your team can’t stop writing crappy code. Will Intelligent Query Processing fix it?

• by administrator

• LittleKendra

People have been writing about how evil scalar functions are in SQL Server for ten years. But people still use scalar functions in their code all the time. And...

2020-03-24

3 reads

Connecting to the SQL Server Community Online: Uplifting Folks

• by administrator

• LittleKendra

We’ve got a session coming up in the free Redgate Streamed virtual conference on, “How database DevOps levels up remote work.” When thinking about that session I began thinking...

2020-03-23

Outlining My Session: Index Tuning in an Agile World

• by administrator

• LittleKendra

I’m giving a session on index tuning at the upcoming Redgate Streamed free online conference. The conference will be held April 1-3 2020, register here and join us! I...

2020-03-20

Announcing Redgate Streamed, April 1-3 2020

• by administrator

• LittleKendra

We’re thrilled to announce Redgate Streamed: a 3 day online virtual community conference, to be held April 1-3, 2020. Register at Redgate.com/RedgateStreamed In this 9 minute livestream, I give...

2020-03-19

The Learner’s Guide to SQL Server Performance Triage

• by administrator

• LittleKendra

I’m introducing a series of “learner’s guides” — overviews of a given topic, chock full of links and references. For this first post, the information is based on what...

2020-03-19

1 reads

Re-teaming is Good: Here’s Why

• by administrator

• LittleKendra

Note: This post is based on an editorial I originally published over at SQL Server Central Years ago, I worked on a fabulous team of eight database administrators We...

2020-03-13

Altering an indexed view in SQL Server drops all indexes

• by administrator

• LittleKendra

I learned an interesting thing about ALTER VIEW behavior in SQL Server when applied to indexed views. This is covered in the product documentation, but it’s not something I...

2020-03-02

Come work with me! Be a Sales Engineer for Redgate

• by administrator

• LittleKendra

Redgate is growing, and we have some fresh, new open positions around the world which would be a great fit for SQL Server developers or DBAs who would like...

2020-02-21

I can do better; we can do better; let’s do better

• by administrator

• LittleKendra

In the past week or so, the Microsoft Data Platform community has begun having a discussion about inclusivity, both on Twitter and across community blog posts. This conversation began...

2020-02-13

Protect Your Prod Databases in Azure DevOps / TFS: Three Control Points

• by administrator

• LittleKendra

When implementing any kind of automation for database deployments, it’s important to implement safeguards for your production environment. This is needed even in the best conditions when team members...

2020-02-05