Friday Flyway Tips–Flyway Parameters

Flyway is a command line tool with lots of options and parameters. Working with those is a pain, but we’ve made this easier in Flyway Desktop 6.5+. In this...

How Would You Design This: Scheduling Classes

One of the challenges for many database developers is coming up with a good design that not only meets the specifications but also performs well in queries. Relational databases often seek some level of normalization, which reduces the update load for a system but might require more effort work from developers to write queries. Many […]

If You Build It, Will They Use Linux?

Microsoft built SQL Server on Linux. Are people coming to use it? Are you?

Flexing for the Cloud

The cloud requires new skills, but it's also using a lot of what you know. Ask questions, learn, and then help evaluate if it makes sense for your situation.

Opening Multiple Symmetric Keys

ADS Copilot Experiments with XML

I sent some code to a customer recently to help them decrypt some stored procedures. I sent a quick and dirty set of code, noting at the bottom that...

The Importance of Thick Clients

Steve prefers thick client tools for working with his databases.

The Last Price Bump for the Data Community Summit

This week the cost of the PASS Data Community Summit jumps up to full price, on Sep 21. This is your last chance to save big, so get someone...

The Upgraded Stored Procedure

Servicing SQL Server

I've been traveling in Europe this week, partially for holiday and partially for work. It's been a nice break, and it's always interesting to experience the world in different places, away from the United States where I've spent most of my life. I get to come often, and I enjoy the experience, but I'm sometimes […]