Big Data or Small Data
Today Steve talks about big data sets and whether we really need them, or even enjoy working with them.
2024-12-18
146 reads
Big Data
Revolutionizing Real-Time Data Management with SQL Server, Kafka, and Informatica
This article examines how one can structure a pipeline for processing real-time data using Kafka and Informatica.
2023-04-26
4,670 reads
Big Data Downsides
Too much data, especially for some data analysis isn't good for diversity of any product domain.
2023-04-12
159 reads
The Danger of Sharing Data
When a company assembles a lot of data to draw conclusions, that's great. However, when that one company sells data to a number of competitors, that can be a problem.
2023-02-22
182 reads
Data lakes take on big data
A data lake is a scalable data storage repository that can ingest large amounts of raw data and make it available on-demand. Robert Sheldon explains the benefits and challenges of data lakes.
2022-02-04
Create a SQL Server PolyBase Scale-out Group Using Amazon Web Services
In this article we look at how to create a scale-out SQL Server PolyBase solution on AWS
2021-12-08
Do You Have Big Data?
Data sizes are always growing. Stats on world data are astounding, as are the stats many of us experience in our lives. Plenty of us have moved from MB management to GBs, and I see plenty of people dealing with TB storage at home. Most of that data is likely from images and video, but […]
2020-09-09
152 reads
Data Orchestration
Steve talks data virtualization in the age of growing data sets and larger workloads
2020-02-27
326 reads
SQL Server Integrates Hadoop and Spark out-of-the box: The Why?
Why has Microsoft added new capabilities in SQL Server to connect to other types of data sources? Read on to learn more.
2021-05-14 (first published: 2019-09-09)
10,591 reads
Reduce costs by adding a data lake to your cloud data warehouse
When it comes to data warehouse modernization, we’re big fans of moving to the cloud. ...
2019-04-17
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers