How do other architects solve the common problems they encounter when tasked with implementing a major new business initiative? We asked 9 of your fellow IT architects to tell us how they approach the most common challenges.
The post “How do my peers do this?” The latest best practices for IT architects implementing a major business initiative appeared first on SQLServerCentral.

In this article, we look at using Microsoft Fabric to build a data warehouse and some things you should know about doing this.
The post What are Warehouses in Microsoft Fabric? appeared first on SQLServerCentral.

Is MongoDB in use within your organization? The Flyway development team is adding MongoDB support into Flyway and would like to better understand the current pain points. If you are able help, or are interested in finding out more, please participate in our 5-minute survey.
The post Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points. appeared first on SQLServerCentral.

In this second part of the Q&A with Dustin Dorsey, we asked him about how to get buy-in from security teams who are cautious by nature, how to encourage the wider IT team to accept their recommendations, and what additional challenges highly regulated sectors like healthcare and finance face.
The post How to get your security team on board with your cloud migration appeared first on SQLServerCentral.

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 […]
The post Scheduling SQL Agent Jobs on Alternating Weeks appeared first on SQLServerCentral.

In this article, we look at three table design guidelines when building an SQL table including data types, designing for deletes, and primary keys
The post SQL Server Table Design Guidelines - Data Types, Designing for Deletes and Primary Keys appeared first on SQLServerCentral.

Learn how you can watch the sessions livestreamed from the PASS Data Community Summit 2023.
The post How to join the free PASS Data Community Summit Livestream from around the world appeared first on SQLServerCentral.

Welcome to the fascinating world of SQL window functions! Today, we'll explore in detail: RANK() and DENSE_RANK().
The post SQL Window Functions Series: RANK() and DENSE_RANK() appeared first on SQLServerCentral.