Cloud-based services and applications must still be monitored just like the on-premise ones. You still need most of your data center activities that ensure that your planning, budgeting, security and service-level obligations are met wherever the data and services are actually hosted. There is much to be said for an integrated approach to providing a unified view of entire application workloads on-premise. hybrid and cloud using the same tools wherever possible.

Hiring Heterogeneously

by Steve Jones

SQLServerCentral.com

Editorial

Hiring a diverse group of people can make your team work better. Steve Jones has a few thoughts today.

Using Database Master Keys in SQL Server

by Steve Jones

SQLServerCentral.com

Encryption

Learn the basics of Database Master Keys and how you can use them in SQL Server.

Let’s Corrupt a Database Together, Part 3: Detecting Corruption

by Additional Articles

Brent Ozar Blog

Corruption

Having already shown how to corrupt a database, and then how nonclustered indexes can be corrupted independently, in this post Brent Ozar explains how you can detect corruption.

Hiring Guitarists

by Steve Jones

SQLServerCentral.com

Editorial

Hiring senior people is hard, but Steve Jones stumbled upon an idea that compares hiring technology people to hiring a senior level technology expert.

The art of getting it right

by Phil Factor

SQLServerCentral.com

Editorial

Phil Factor advocates paying attention when it doesn't matter to prepare for when it does.

SQL Server function to check dynamic SQL syntax

by Additional Articles

MSSQLTips.com

Dynamic Code Analysis

Although most of what you read tells you to stay away from dynamic SQL, the reality is there are places where writing T-SQL code dynamically just makes sense. The one downside to dynamic SQL is that if it is not written correctly the code will fail. Eli Leiba shares a function that he created to help determine if the dynamic code is OK prior to execution.

The ABCs of Database Creation

by Brandie Tarvin

SQLServerCentral.com

Database Design

Creating SQL Server databases is easier than the internet may lead us to believe.

What's in your CLR?

by Jeff Moden

SQLServerCentral.com

Editorial

For today's Friday poll we have a guest editorial from Jeff Moden. The head of the anti-RBAR alliance has spent a lot of time trying to help others write better T-SQL and solve their problems with code that performs well. However this Friday Jeff asks about the CLR and how you are using it, or not using it, in the real world.

Introduction to Azure SQL Data Sync

by Additional Articles

Database Journal

Azure

The majority of Azure SQL Database related features reach their General Availability (GA) stage relatively quickly. There are however, some exceptions. The most prominent example in this category is likely Azure SQL Data Sync, which has remained in Preview since its introduction 7 years ago. Fortunately, there are signs that this service might be finally reaching production-ready state. In thius article, Martin Policht will introduce its main characteristics.

Monitoring Azure Cloud and Hybrid Environments

Hiring Heterogeneously

Using Database Master Keys in SQL Server

Let’s Corrupt a Database Together, Part 3: Detecting Corruption

Hiring Guitarists

The art of getting it right

SQL Server function to check dynamic SQL syntax

The ABCs of Database Creation

What's in your CLR?

Introduction to Azure SQL Data Sync

Blogs

VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”

Future IT Roles – Agentic Architect and AI Boom!!

Free Webinar about Columnstore Indexes

Forums

There's Too Much to Learn

How to Calculate Distance Between Coordinates in SQL Server

SSoL Support on the OS

Question of the Day

SSoL Support on the OS