“How do my peers do this?” The latest best practices for IT architects implementing a major business initiative
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.
What are Warehouses in Microsoft Fabric?
In this article, we look at using Microsoft Fabric to build a data warehouse and some things you should know about doing this.
You Never Know
I'm writing this sitting at the PASS Data Community Summit. It's been a fantastic event. I gave a community session on Azure DevOps. I was able to help Redgate launch a new product. I've received a bunch of hugs from VERY dear old friends. I've met a ton of people. It's been great. Allow me […]
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 […]
How to get your security team on board with your cloud migration
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.
Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points.
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.
How to join the free PASS Data Community Summit Livestream from around the world
Learn how you can watch the sessions livestreamed from the PASS Data Community Summit 2023.
Blogs
Denver Dev Day – Best Practices for Database Deployments Resources
By Steve Jones
I delivered a talk today on database deployment best practices at the Denver Dev...
A New Word: desanté
By Steve Jones
desanté – n. the brooding delirium of being sick, which makes time slow to...
What happens when we drop a column on a SQL Server table? Where's my space?
This article was initially posted on SQLServerCentral @ 2024-04-26. Short answer: The column is marked...
Forums
On Being an "Expert"
Comments posted to this topic are about the item On Being an "Expert"
Advice: how to script out existing Azure (logical) SQL Server logins
Advice on how to script out existing Azure (logical) SQL Server logins and mapped...
Abort Package after specified timeout project parameter
Hi I have a sequence container which contains an execute package task which loads...
Question of the Day
Adding Hints with Query Store
I have a query that is being tracked in the SQL Server 2022 Query Store. I want to add a hint to this query to ensure that the MAXDOP for this query is one. How can I do this with minimal code changes
See possible answers