Warehouse Load Patterns – Part 1 – Requirements and General ...
No matter the ETL tool used, there are some basic patterns to follow when transferring data between […]
Sites anglophones
Updates about Database Projects for Microsoft Fabric
comp A few weeks ago, I wrote a blog about Database Projects for Microsoft Fabric. It’s an […]
It’s Black Friday! Time to save big on SQL Server ...
My Annual Black Friday Sale is On! I’m running a giant Black Friday sale on my training courses! […]
Black Friday returns to SQLServerFast
The post Black Friday returns to SQLServerFast appeared first on SQLServerCentral.
Unpivoting Multiple Sets of Columns in SQL Server using CROSS ...
The post Unpivoting Multiple Sets of Columns in SQL Server using CROSS APPLY appeared first on SQLServerCentral.
[Video] Office Hours: Brent’s Cursed Technology Edition
I first answered these while standing at a harbor in Maine, but upon arriving home, I realized my […]
Source Control with GIT, Power BI and Microsoft Fabric
Source control is fundamental when dealing with projects and sharing code between multiple developers. Power BI present […]
What is Microsoft Fabric all about?
In this article, we will introduce Microsoft Fabric and how it relates to Power BI Premium Capacity […]
[Video] Office Hours in Camden Harbor
On an overcast morning in scenic Camden, Maine, I stood on the docks and took your top-voted questions […]
Advanced SQL Server installation using Powershell DSC
Introduction In the previous article, we learned how to install a SQL Server instance with basic parameters like […]
Azure DocumentDB: Working with Microsoft's NoSQL Database in the Cloud
The post Azure DocumentDB: Working with Microsoft's NoSQL Database in the Cloud appeared first on SQLServerCentral.
Back home from the PASS Data Community Summit
What a week it was. While it wasn’t my first in person conference this year, it felt […]
Why Haven’t You Disabled SA? Wrong Answers Only.
On social media, I asked folks, “Why haven’t you disabled the SA account in your SQL Servers? Wrong […]
Strategies for queries against bit columns
Recently someone posted a question where they couldn’t quite figure out how to construct a predicate based […]
“How do my peers do this?” The latest best practices ...
The post “How do my peers do this?” The latest best practices for IT architects implementing a major […]
What are Warehouses in Microsoft Fabric?
The post What are Warehouses in Microsoft Fabric? appeared first on SQLServerCentral.
PASS Summit 2023 – Community Keynote – AIOps and ChatGPT ...
Last but not least, the Community Keynote. Hang on to your hats, this is going to be […]
Is your organization using MongoDB? Help the Redgate Flyway team ...
The post Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points. appeared first […]
How to get your security team on board with your ...
The post How to get your security team on board with your cloud migration appeared first on SQLServerCentral.
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 […]
PASS Summit 2023 – Redgate Keynote – The New Database ...
Day 2 is here! Sitting here at the bloggers table waiting for the keynote to commence! <image […]
[Video] Office Hours at Megunticook Falls in Camden, Maine
While in historic and beautiful Camden to hang out with friends, I went to Megunticook Falls and answered […]
PASS Summit 2023 – Microsoft Keynote – Limitless growth, limitless ...
CEO of Redgate: Jakub Lemik: This year’s theme is Connect, Share, and Learn. Tomorrow will be People […]
Office Hours, Silent Film Edition
Hey, remember in yesterday’s video how I said I was having a really bad day? Well, here’s how […]
SQL Server Table Design Guidelines – Data Types, Designing for ...
The post SQL Server Table Design Guidelines – Data Types, Designing for Deletes and Primary Keys appeared first […]
How to join the free PASS Data Community Summit Livestream ...
There’s nothing quite like attending PASS Data Community Summit in person to reconnect with friends and make new professional connections […]
SQL Window Functions Series: RANK() and DENSE_RANK()
Welcome to the fascinating world of SQL Window functions! As we journey through the intricate labyrinths of databases […]
Autonomous Databases?
I was talking to some people today about the concept of Autonomous Databases. The idea is that […]
The Curious Case of… missing 832 errors during memory corruption
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post […]
The Black Friday Sale is Here: Save Big on Training ...
My Annual Black Friday Sale is On! I’m running a giant Black Friday sale on my training courses! […]
The Real Problem with SQL Server’s Licensing Costs
At least once a month, a client has The Postgres Conversation™ with me. It happens at the end […]
Getting Started with MongoDB
MongoDB is a scalable database management system that stores data as documents in a collection, rather than […]
It’s Probably Time to Upgrade Your Cloud VMs
The post It’s Probably Time to Upgrade Your Cloud VMs appeared first on SQLServerCentral.
Azure Data Studio – A First Look
Introduction Azure Data Studio is the next iteration in Microsoft’s development of a cross-platform client tool for developing […]
Security in the cloud: Whose responsibility is it?
The post Security in the cloud: Whose responsibility is it? appeared first on SQLServerCentral.
An editor’s biggest headache: Plagiarism
As an editor working with other people’s technical writing for many years, you might guess that either […]
Office Hours: “Read This” Edition
Sometimes when people post questions at https://pollgab.com/room/brento, the answer is just a link, nothing more, nothing less. It […]
Is your organization using MongoDB? Help the Redgate Flyway team ...
The post Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points appeared first […]
The PASS Data Community Summit First Timer Guide
Edwin Sarmiento has been producing a first-timer’s guide for the PASS Data Community Summit since 2016. He has […]
Time-Series Data Analysis with Apache Druid
In the era of data-driven decision-making, the ability to efficiently analyze and derive insights from time-series data is […]
[Video] Office Hours: Having a Bad Day Edition
The first day back after a long vacation is always rough, and today’s no exception. I took your […]
The NTILE Function
The SQL NTILE() is a window function that allows you to break a table into a specified […]
Fabric Data Warehouse News you need to know
Microsoft Fabric, including the Data Warehouse, evolves faster than we can analyze and write about it. Here […]
[Video] Office Hours: Yes, I’m In the Same Shirt
Why yes, I’m wearing the same shirt as the video from “yesterday”. Why do you ask? Stop paying […]
Timescale Launches Dynamic PostgreSQL, the Cost-Effective Alternative to Serverless and ...
NEW YORK – November 6, 2023 – Timescale, the cloud database company, has announced the launch of their […]
Free Webcast: How to Think Like the Engine, Live
You’re comfortable writing queries to get the data you need. But you’re uncomfortable if someone asks you how it […]
Who’s Hiring in the Microsoft Data Platform Community? November 2023 ...
Is your company hiring for a database position as of November 2023? Do you wanna work with the […]
Storm Ciaran Analysis with Microsoft Fabric
Always looking for Open Source data to highlight the capabilities of Microsoft Analytics solutions, I have: In […]
Analyse de la tempête Ciaran avec Microsoft Fabric
Toujours à la recherche de données Open Source afin de mettre en exergue les capacités des solutions […]
Moving SQL Server To The Cloud: Modernizing Stack Overflow for ...
Earlier this year, we migrated the entire Stack Overflow for Teams platform to Azure. This was a […]