When Should You Employ Snowflake Materialized Views?
I’ve used both Snowflake views and materialized views with varying degrees of success. Both have their place and it’s on us to determine when to use them based on what they offer. This guide will help you in understanding how views and materialized vie …
Feed SQL Server logs into SIEM
We sometimes complain that the Security Operations Center (SOC) doesn’t spot cyber-attacks on time, but maybe we’re not giving them critical information they need to do their job. SIEM stands for Security Information and Event Management; it encompasse …
Build a Streaming Data Architecture with Apache Kafka and Zookeeper
The post Build a Streaming Data Architecture with Apache Kafka and Zookeeper appeared first on SQLServerCentral.
PASS Summit is going on tour in 2025!
The post PASS Summit is going on tour in 2025! appeared first on SQLServerCentral.
Getting Started with the Data API Builder
Earlier this year I had a PM at Microsoft reach out and ask me what I thought about the Data API Builder. I hadn’t looked at it, so I made a note to check it out. I hadn’t done that by the time SQL Saturday Denver 2024 occurred, where I saw Jerry Nixon …
How to Use Github in SSMS v21
SQL Server Management Studio v21 added native Git support, making it easier to use source control natively inside SSMS. This feature is for developers who are already used to working with Github to manage specific object changes as they work, and who a …
TSQL Tuesday #181 – The first SQL Server Feature that made me go “Wow!”
First off, thank you to Kevin Chant for hosting TSQL Tuesday this month. And equally, thank you for not putting a time frame on your request! “My invitation to yourselves is to write about a Microsoft Data Platform announcement that you considere …
[Video] Office Hours in Zhengzhou, China
For the rest of December, I’m out vacationing in China and Japan. For this episode, I’m coming to you from the People’s Park in Zhengzhou, China, which is kinda like the Chicago of China. It’s in the middle of the US, bigger tha …
Aggregate Functions in Power BI including Running Total, Running Average and Max
The post Aggregate Functions in Power BI including Running Total, Running Average and Max appeared first on SQLServerCentral.
Virtualizing GCP data by using Fabric Shortcuts: Data Engineering with Fabric
Before the invention of shortcuts in Microsoft Fabric, big data engineers had to create pipelines to read data from external sources such as Google Cloud Platform (GCP) buckets and write into Azure Data Lake Storage. This duplication of data is at ris …
A gentle introduction to dbt
In a typical data warehouse project, data is loaded, transformed and stored into a data store using an ETL (extract – transform – load) process. Recently, there has been a shift to ELT processing, where data is first loaded into a data store (this can …
How to Send Email with SQL Server’s sp_send_dbmail
So you’re writing T-SQL code and you’ve decided that you want to send emails to customers, employees, or the general public. Perhaps you need to send order updates or low stock notifications. Stop right there. You don’t really wanna d …
T-SQL Tuesday #181: Query Store and its evolution
Query Store. This is my choice in relation to “What feature release made you say WOW!”, the subject of this SQL Tuesday. Query Store: The first release Query Store was first released in SQL Server 2016, it’s getting closer to 10 years old, but we barel …
The Paradox of NOLOCK: How Dirty Reads Can Sometimes Be Cleaner
Every SQL Server developer has heard it: « Don’t use NOLOCK in production! » But this common rule isn’t as simple as it seems. Sometimes, what seems like a bad practice can actually be the right choice. Let’s explain what NOLOCK really does in simple ter …
SQLBits is Coming Back to London in June 2025!
I used to feel bad saying that any one conference is “my favorite” because I worried that other database conference organizers might feel slighted. However, I’ve talked to many of ’em, and they feel the same way I do, hahaha, so …