WIT Virtual Chapter – The Evolution of Database Development and Administration – Webinar Weds, March 25 –  8 am Pacific / 11 am Eastern / 4 pm GMT – Register

Redgate Streamed – a 3 day free community virtual conference on the Microsoft Data Platform – April 1 – 3 – Register here

  • If you can’t make it live, each day’s registration gets you a link that will work for recordings immediately after the event
  • Drop in live for sessions when you can, we’d love to interact with you!
  • We’re excited to donate $1 per virtual attendee (live or watching the stream after) to @WHO

Data Grillen 2020 – May 28, 29 –  Lingen, Germanythis event needed to be cancelled this year, hope to see you there in 2021

Data Ceili – July 10 – Dublin, Ireland – Free! Register – fingers crossed this in-person event will be able to go on, stay tuned

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? A colleague of mine at Redgate wondered: is the behavior the same with the new CREATE OR ALTER syntax as it is with just plain ALTER? (Spoiler: I tested and it is the same: CREATE OR ALTER also drops all indexes on the view.) One note: if you are using Redgate tooling to commit your database objects to version control, never fear: it handles this for you and…
Read More

Come work with me! Be a Sales Engineer for Redgate

No Comments
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: Sales Engineer – Cambridge, UK Pre-Sales Engineer – Pasadena, CA Sales Engineer – Austin, TX As a DevOps Advocate, the Sales Engineering team is one of my favorite groups to work with at Redgate. These folks get to learn all about database DevOps, and they get to show clients the possibilities for how they can better develop and deliver database changes, as well as how to better protect their data in the software development process. But the Sales Engineers aren’t only intelligent. Our Sales Engineering team is a group of kind, smart people who…
Read More

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

3 Comments
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. Historically the legacy SQL Server community has had quite visible support for Women in Technology, but has not shifted broadly/overall to a public focus on larger Diversity and Inclusion issues. There have been efforts to be more inclusive to people of color and members of the LGBTQ community, but these efforts have have not been nearly as visible or “popular” within the community as the efforts to support WIT. I don’t write this in an accusatory way, only to describe the state of things as I see them. I have not worked to change this,…
Read More

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

No Comments
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 collaborate well and there is a high level of trust, for a very simple reason: accidents happen easily! As a person who has accidentally destroyed quite a lot of things VERY RAPIDLY with automation😱, I am a fan of adding protection around production environments to lower risk for everyone, including myself. On the other hand, it’s also desirable to empower team members to be able to quickly build and experiment with automation in other environments. It’s best to not lock down more than you need to. In this post I’ll give a quick overview of three control points which help protect your production databases when working with Azure DevOps Server/Services (or legacy Team Foundation Services). The controls I’m discussing here apply…
Read More

High Availability options for SQL Server 2008 in an Azure VM – a #sqlhelp story

No Comments
I asked a question on Twitter yesterday: If running SQL Server 2008 in an Azure VM (no SQL upgrade possible, extended support in place), is the best option for high availability Database Mirroring? Or something else I am not thinking of? #sqlhelp— Kendra Little (@Kendra_Little) January 31, 2020 And check out the magic of the sqlhelp hash tag, I got loads of answers! So many that I’m actually selecting a few here for the purposes of keeping this post readable. First, John Morehouse , a smartie and a consultant who does a lot of great work in the cloud and on-prem helped me figure out what would be needed for clustering (which isn’t something you can do simply with this version in an Azure VM)… I belive you could also cluster it but you’ll need SIOS for the storage. I think. DisclaImer: I’ve never tried it. Mirroring should work as…
Read More

Do It Live! A First Look at Redgate’s Hybrid Model for SQL Source Control and SQL Change Automation (video)

No Comments
In this 70 minute livestream recording, I kick the tires of a fresh new Azure DevOps demo environment showing Redgate’s Hybrid Model for SQL Source Control and SQL Change Automation. I had just set up this whole demo environment and its pipelines, so the video shows me troubleshooting and fixing an option or two in Azure DevOps which I hasn’t configured quite correctly — which makes things all the more fun for a livestream. If you want to skip watching me installing ZoomIt in the new demo environment (which I’d completely forgotten– how could I??? I can’t show things without Zoomit!) then start at around 6 minutes.
Read More
Menu