microsoft sql
Upgrade SQL Server
One of the most difficult projects to undertake as a DBA is upgrading your SQL Server from one version to another. The biggest reason that it's so difficult is
Shannon Lowder
SQL102
World Backup Day
This past Saturday was World Backup Day, It's not an actual government recognized holiday, but as a DBA you should start celebrating it. Maybe celebrate isn't
sql203
SQL203 — Indexes can help|hurt
Yeah, I used a pipe in my title. That's because indexes can help some things, but hurt others. The brief of it is indexing helps reads, but comes at a cost:
microsoft sql
SQL 201 – APPLY
Let's finish up with the SQL 210 series today with the APPLY operator. After you learn how to create your own functions, you're going to want to use them in new
The Pipeline Isn't the Product
Last year I finished a project where we delivered a data warehouse with over forty SSIS packages, a dozen SQL Agent jobs, and about two hundred stored procedures. Each piece worked. The integration testing passed. We signed off and moved on. Three months later the client called. Someone had added
Your Hive Script Is Code: Why Data Teams Need to Learn Git
A client called me in January because their daily aggregation pipeline had broken over the weekend. The pipeline read from HDFS, ran three Hive transformations, and landed results in a reporting table the business reviewed every Monday morning. It had been working fine for months. Then it wasn't.
SQL 202
This is the second DBA course. As I add articles, they'll appear here.
SQL 101
After helping others learn SQL for several years now, I keep coming back to the same topics over and over. So, I decided to write down these SQL tutorials,
SQL 103
This is my SQL architecture and design course. In this series you'll get an idea of what kind of objects you can build, and what they're used for. Once you
SQL 301
Time to take your database development to the next level! As I add articles to this series, they will appear below.
SQL 102
This set of articles will be about Database Administration. As I add articles to the series, they'll appear below.
SQL 201
It’s that time again! Time to start up a new class and cover some more advanced topics in SQL Development. Before beginning these lessons, You need to be