Scheduling SQL Agent Jobs on Alternating Weeks

Bi-week... semi-week... fortnight... "every two weeks" Recently on the SQL Community Slack group, someone asked if there was a way to schedule a backup to run on alternate weeks. I'm not exactly sure why (maybe they wanted to run full and differential backups on alternating weeks), but yes, we can do that. In part one […]

SQL Server Table Design Guidelines - Data Types, Designing for Deletes and Primary Keys

In this article, we look at three table design guidelines when building an SQL table including data types, designing for deletes, and primary keys

Don't (Always) Be a Hero

When we need to be heroes in IT on a regular basis, that's a problem for Steve.

Transform your Winning team into a Champion Team

Businesses worldwide now operate on a team basis, and a high-performing team is crucial for high-performing organizations. Winning teams are more focused and better than regular teams. They focus on synergies and achieving significant results. They are an extension of regular teams with a higher sense of commitment to objectives and mutual purpose. Winning teams have a clear mission and achievable performance goals for each member, aiming for extraordinary goals. They are more committed to the vision and have a passion for achieving the mission. Winning teams work collaboratively to discover new work approaches, principles, and practices, focusing on decision-making, creative problem-solving, industry standards, and effective communication. They establish processes from beginning to end to complete tasks effectively. The difference between winning team and a regular team is very clear. However, what makes a winning team a champion team. This paper aims to provide valuable insights into the differentiating factors of a champion team from a winning one.

Celebrate THEIR Accomplishments

I can't hide this in any way. I love it when I accomplish something. It's such a great feeling. Even more than that, I really do love getting some acknowledgement for it. Almost as good, is when I see others, especially friends and acquaintances, doing well. So many people I know, regularly just knock it […]

What Exactly Is a CTE in T-SQL? A Comprehensive Guide with 7 Examples

Learn how to use CTEs through the use of a number of examples.

Integrating Python with MongoDB

This article gives an overview of MongoDB and outlines steps to integrate python with MongoDB

Using SQLite with Flutter

Learn how you can build a basic Flutter application that interacts with a SQLite database.

Double Standby

Gentlest of Reminders, Don't Stop Learning

I was on the road for just over two weeks. I was able to travel around to a few places and present some sessions. But, better than that, thanks to SQL Konferenz, I was able to go to a couple of sessions and learn some stuff. I'm lucky/cursed in my position at Redgate. We have […]