Upcoming Events

SQL PASS Summit – Nov 4-8, Seattle, WApricing

Recent Recordings

Redgate Evangelist YouTube Channel: Tutorials on Database DevOps -New videos each week – Watch

Fast and Reliable Development with Redgate Solutions for SQL Server – Watch

Implementing Data Masking for NIST Compliance – 1 hour – Watch

How Developers and DBAs Collaborate in a DevOps World – 40 minutes – Watch

How DevOps Keeps DBAs Safe from Being Automated Out of a Job – 1 hour – Watch

DevOps: What, who, why and how? – 1 hour – Watch

Can This Team Succeed at DevOps? Panel discussion – 1 hour – Watch

Why to Avoid Using the Current Database Name in Object Definitions in SQL Server

I’ve recently published an article, “Why You Shouldn’t Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures,” over on Simple Talk. Hello, my name is FINE In the article, I discuss: Why referencing the current database name creates a dependencyWhat ‘deferred name resolution’ is, and why the dependency may be more noticeable in views and some functions (rather than stored procedures)Which activities are most likely to break if you place dependencies on the current database name Read the full article here.
Read More

PASS Summit 2019 Call for Speakers is Open – How I Sketch Out My Submission Ideas

Are you interested in speaking at the Professional Association for SQL Server’s annual Summit conference? The call for speakers is now open, and you may submit up to three sessions between now and March 31, 2019. I’m currently in the process of sketching out my ideas for what sessions that I’d like to submit, and I thought I’d share my process here. Generating ideas: what am I interested in spending six months thinking about? I’m a bit selfish when it comes to topic selection, and I think that’s fine: it needs to be something that I’m interested in thinking about for more than half a year. That does NOT mean that it needs to be super-advanced rocket science content. Figuring out how to present introductory level content clearly, in an easy-to-understand way takes a lot of time. The topic simply needs to compelling enough for me to stay interested. A…
Read More

Contest: Tell Your Database Development Disaster Story (5 winners get $150 USD or more each)

Redgate is building a library of real-world stories about database development disasters. Your mission: Tell us a true story in 500 words or less about a time when you were involved in an Agile or DevOps project that went full steam ahead in speeding up delivery of application code, but didn’t modernize database development practices. Did trouble follow? Check out the prizes and give us the scoop here before March 20, 2019. Enter today, time’s almost up! Share your story using the form hereThe story must be true – but never fear, we will anonymize all stories and the names of the winnersEnter as often as you’d like (but each person may only win once) Need inspiration? Grant’s sample entry (the short version) “Our organization built a new application using an Object Relational Mapping (ORM) tool. The team worked without any DBAs or database developers for speed. We ended up…
Read More

Watch: Kendra Breaks and Fixes SQL Source Control (9 minutes)

I love breaking technology. Well, I love breaking technology on purpose, in a place where it’s not going to slow anyone else down. It’s a great way to learn more about how everything works and what your options are to fix the situation when things go sideways. In this 9 minute video, I ignore SQL Source Control’s valiant attempts to keep me out of trouble, and put the database code in my local git repository into an inconsistent state. Can I fix it? (Spoiler: yes I can.)
Read More

New Free Videos on SQL Prompt, SQL Compare, and SQL Doc with Redgate’s SQL Change Automation

No Comments
I’m excited to have just clicked ‘publish’ on four new videos in the brand new Evangelist Tutorials playlist on Redgate’s YouTube channel. These videos step through setting up and working with a project in one of my favorite Redgate tools: SQL Change Automation. The awesome thing about SQL Change Automation is that it gives you two things: Fine-grained control to tune and order the execution of changes to your database with a migrations-first approach to source controlling your codeA view of the state of your database, which is crucial for code reviews, controlling environment drift, and communicating about changes between developers and database administrators The tricky thing is that there’s a lot to learn when starting out with SQL Change Automation if you haven’t used a migrations-first approach in the past, or aren’t used to working in Visual Studio. That’s where these videos come in: you can follow along with…
Read More
Bust of Developocritus, the Forgotten Greek Philosopher

State vs Migration for Database Source Control – decide based on one question

Bust of Developocritus, the Forgotten Greek Philosopher One controversial topic in database development is how to properly store and deploy database changes. This is generally described as choosing between two options, which are approximately as easy to understand as Greek philosophy: State based – A Platonic view of the database as a snapshot of a set of forms in a given state at a point in timeMigrations – An Aristotelian view of the database defined as a series of scripts which generate change over time Yeah, I never really liked arguing about philosophers, either. Scratch all that. There’s a simple question that you can use to decide whether a state-based or migrations-based approach is right for a given database. Here’s that question: Do you want at least 95% of your database changes to deploy using auto-generated code? There you go, that’s it. Look back on your life-long experience with Clippy,…
Read More