Learn TSQL for free online - starting today

Learn TSQL for free online - starting today

Thanks to the support of Redgate, I’ve launched a new course which teaches you the basics of TSQL. The course is totally free, no logins required – we don’t even ask for the email address. Check out the course on Redgate University The course is here: https://www.red-gate.com/hub/university/courses/t-sql/tsql-for-beginners Each week has an embedded video for the course, along with a link to the syllabus and scripts. The videos also have a timeline in case you wish to jump to a particular part of the discussion.
Make Database Code Reusable in SQL Source Control with Deployment Filters

Make Database Code Reusable in SQL Source Control with Deployment Filters

When I first began working with databases, I was lucky to land a job at a little start-up which had solid development and operations processes: all our code, including database code, was in version control. We had a strong database architect who instilled good coding practices into the way we managed database code as well: code was expected to be reusable whenever possible.

Connecting to the SQL Server Community Online: Uplifting Folks

Connecting to the SQL Server Community Online: Uplifting Folks

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 about other ways to improve remote work. While I worked remotely for nearly ten years until recently and have established practices which work well for me , moving to another country and the general chaos and uncertainty right now as the world tries to cope with a global pandemic have increased my feelings of worry and loneliness.
Announcing Redgate Streamed, April 1-3 2020

Announcing Redgate Streamed, April 1-3 2020

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 you a rundown of the event schedule and tells you why I’m excited about each session. For every registration that attends Redgate streamed, live or on-demand, we’ll donate $1 to the World Health Organization’s COVID-19 response fund (in addition to a separate donation we’ll be making.
Re-teaming is Good: Here's Why

Re-teaming is Good: Here's Why

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 supported more than a hundred developers who worked in an agile fashion. When I first joined the DBA team, we had a shared on-call rotation, but each DBA specialized in a certain area of the environment and regularly met with the development teams working on that area.
Altering an indexed view in SQL Server drops all indexes

Altering an indexed view in SQL Server drops all indexes

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 would have expected: ALTER VIEW can be applied to indexed views; however, ALTER VIEW unconditionally drops all indexes on the view. ALTER VIEW documentation When I first heard about this behavior, it sounded like a bug to me: why should an alteration like adding a column to a view remove all the indexes?
Come work with me! Be a Sales Engineer for Redgate

Come work with me! Be a Sales Engineer for Redgate

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 to transition to a customer-facing role and develop expertise in Redgate’s solutions for Compliant Database DevOps. Here are the listings and locations for three of these roles:

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

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

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 when a member of the community shared their story about being repeatedly mis-gendered and additionally feeling excluded, unwelcome, and hurt at a series of community events.

Controlling who commits code to a given database schema in Git with Azure DevOps

Controlling who commits code to a given database schema in Git with Azure DevOps

One of most the fun things about working as an Advocate at Redgate is getting to help clients determine their preferred workflow for database DevOps.

Teams often have unique requirements and are using different combinations of tooling, so figuring out the best way to accomplish what they need typically involves leveraging what I already know, collaborating with my coworkers and the client to generate ideas, researching and prototyping solutions, and then getting feedback from everyone.