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.
2023-11-20
Articles
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 […]
2023-11-17
2,439 reads
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.
2023-11-17
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.
2023-11-17
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.
2023-11-15
1,324 reads
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
2023-11-15
Azure Data Studio - A First Look
See a first look at Azure Data Studio from Kenneth Igiri and read about his impressions.
2023-11-13
4,130 reads
It’s Probably Time to Upgrade Your Cloud VMs
If you’ve been in Azure or Amazon for a few years, you’re probably on old, slow hardware.
2023-11-13
Security in the cloud: Whose responsibility is it?
While the cloud is recognized as more secure than on-premises servers and infrastructures, it does come with the often talked about shared responsibility model. Cloud providers are responsible for security ‘of’ the cloud, while their clients are responsible for security ‘in’ the cloud. Find out more in this Q&A with Dustin Dorsey
2023-11-13
The PASS Data Community Summit First Timer Guide
The 2023 First-Timer guide to the PASS Data Community Summit is available from Edwin Sarmiento
2023-11-10
627 reads
Blogs
AI and Data Engineering on the Edge: The Good, the Bad, and the Overhyped
Running AI and data pipelines on the edge instead of the cloud has gone...
UNION vs UNIONALL: #SQLNewBlogger
By Steve Jones
While writing another post I realized my UNION query didn’t work as one might...
Deciphering Data Architectures Is Now Available in Multiple Languages
By James Serra
Since the release of my book Deciphering Data Architectures: Choosing Between a Modern Data...
Forums
Secure Cached Plans
Comments posted to this topic are about the item Secure Cached Plans
Complex Data Processing with dbt Python Models: The Fabric Modern Data Platform
Comments posted to this topic are about the item Complex Data Processing with dbt...
Over or Under Provisioned
Comments posted to this topic are about the item Over or Under Provisioned
Question of the Day
Secure Cached Plans
The DMV, sys.dm_exec_cached_plans, contains rows for each cached plan on an instance. In Azure SQL Database, not every used has rights to every database, as there does exist an instance behind each database. How is security handled for this DMV in Azure?
See possible answers