SQL Cheat Sheet for Basic T-SQL Commands

In this article, we cover some basic T-SQL commands that show you how to interact with a SQL Server database table.

Friendship and Your Career

PASS Data Community Summit is coming up like an out of control freight train. Another couple of weeks and it'll be here. I'm excited about it every year and I really hope to see you there. Please, consider this a personal invite to say hi if you see me around. I'm bringing all this up […]

SQL Server Engineering Using Free Tools

You can master engineering for your SQL Server databases, on premises or in the cloud, with a FREE toolkit!

Using Time Wisely

Steve knows one of the most valuable assets we have is time.

Expert-led PASS Data Community Summit Pre-cons

Spaces are still available for next month's PASS Data Community Summit pre-conference sessions - but they’re booking up fast! Choose from 18 deep-dive full day pre-cons, featuring some of the best minds in the data industry, covering everything from technical processes to personal growth. Register now.

SQL Stored Procedure Input and Output Parameters, Types, Error Handling, Security and more

In this article, we look at various aspects of creating SQL Server stored procedures along with several examples of how to build a stored procedure.

Migrate the SSIS Catalog in Just a Few Clicks

This wizard migrates SSIS Catalog from one server to another in just a few clicks.

10 Considerations for a Database Migration to AWS RDS

This article includes 10 things that you should consider when migrating to the cloud, with an example using RDS that explains how these are applied to an actual database being created.

Cone of Uncertainty

Our design and modeling is often done with some level of uncertainty. Steve has a few guidelines today.

5 Database DevOps Trends Landing on your Shoulders

Are these challenges heading your way?

Join us on Nov 15th at PASS Data Summit to discuss key trends that impact Database DevOps, such as Containerization, and Cloud Build/CI systems. Reserve your place now.