Warehouse Load Patterns – Part 2 – Load Patterns
This continues and finishes my two-part series on warehouse load patterns. There are many methods to transfer […]
Archives de l’année : 2023
[Video] Office Hours: Holiday Speed Round Edition
Most of the https://pollgab.com/room/brento questions from this episode had really short and sweet answers. Let’s take a break […]
The Profiler Extension in Azure Data Studio (ADS)
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles […]
Updated First Responder Kit and Consultant Toolkit for December 2023
New this month: more work on letting sp_Blitz run with limited permissions, nicer Markdown output, sp_BlitzLock compatibility with […]
Comment utiliser les rapports SSMSInfoReports
Pour comprendre à quoi servent mes rapports custom pour SSMS (SSMSInfoReports), comment les installer et les utiliser : […]
Eager Aggregation in SQL queries
Aggregation is a widely used way to summarize the content of a database. It is usually expressed […]
[Video] Working on First Responder Kit Pull Requests
For this month’s First Responder Kit releases, I worked through most of the pull requests live on my […]
Understanding Maximum Server Memory in SQL SERVER
Editor: For SQL developers looking to optimize their SQL Server’s performance, one crucial aspect to understand and implement […]
Most Overlooked Features in Power BI
The post Most Overlooked Features in Power BI appeared first on SQLServerCentral.
Introducing the MongoDB Document
MongoDB is a document database. As such, the data is stored as individual documents. A document is […]
The Annual Data Professional Salary Survey Closes This Week!
Take the Data Professional Salary Survey now. The 2020s have been tough: a pandemic, a recession, layoffs, and […]
Building Reports with Power BI vs Tableau from SQL Server ...
The post Building Reports with Power BI vs Tableau from SQL Server Data appeared first on SQLServerCentral.
Docker Security Principles Overview
The post Docker Security Principles Overview appeared first on SQLServerCentral.
Creating a Hyperscale Database in Azure Using the Azure Portal
Data is the lifeblood of contemporary enterprises in the digital age. Managing and growing databases to fulfill these […]
[Video] Office Hours: 21 Good Questions
This one is a 3-part episode: I take 21 questions from https://pollgab.com/room/brento and then later, work on First […]
Counting more efficiently
Nearly a decade ago, I wrote a post called “Bad habits : Counting rows the hard way.” […]
[Video] Office Hours: Wrong Side of the Bed Edition
I woke up on the wrong side of the bed after a nap. How does that even happen?!? […]
Sending resource alerts on Managed Instance using db_mail
The post Sending resource alerts on Managed Instance using db_mail appeared first on SQLServerCentral.
Why Don't You Upgrade in Place?
Ask a senior-level SQL Server or Windows administrator about doing in-place upgrades and you’ll likely get a negative […]
Interesting Aurora MySQL Feature: The Buffer Pool Survives Restarts
“Documentation! Hey, look at that.” Lemme start this off by saying this is probably irrelevant to you. (It’s […]
Le DataOps pour Power BI et Microsoft Fabric
Petit article de retour sur un événement communautaire du Club Power BI Les communautés sont des groupes […]
Using a SQL Tokenizer
Imagine this: you have several directories full of SQL script files, and you need to know where […]
Configuring an SSIS ForEach Loop for Multiple File Types
The Problem The SSIS Foreach Loop component has a limitation when it comes to selecting different sets of […]
Using Spark Jobs for Multiple Lakehouse Maintenance in Microsoft Fabric
I have published videos and articles before about Lakehouse maintenance. In this article I want to address […]
Cumulative Update #24 for SQL Server 2019 RTM
The 24th cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft […]
Searching an Encrypted Column
When encrypting a database column, equality searching can be preserved by using a deterministic encryption algorithm. A deterministic […]
Running Azure CosmosDB queries from SQL Server using ODBC driver
The post Running Azure CosmosDB queries from SQL Server using ODBC driver appeared first on SQLServerCentral.
MySQL Error Log Management in DevOps Operations
When it comes to the development and operations (DevOps), one thing stands out as a critical aspect […]
[Video] Office Hours: Sunshine Edition
You know how this works: you posta the questions at https://pollgab.com/room/brento, and I giva the answers: Here’s what […]
Fabric Notebooks and Deployment Pipelines
On my article about Fabric source control extended features, I explained how Microsoft included the notebooks on […]
[Video] Office Hours: Really Good Questions Edition
Y’all were on fire in this one! You posted great questions at https://pollgab.com/room/brento and I worked through ’em: […]
Arc enabled Azure migration & modernization journey
As business demands evolve, applications must be modernized or replaced. To maximize business value, organizations are leveraging cloud […]
SQL GROUP BY Alias – An Oracle feature that would ...
The post SQL GROUP BY Alias – An Oracle feature that would be great in SQL Server appeared […]
What Would You Ask Your Predecessor? Get Answers with ChatGPT.
So many times in my career, I’ve come across a questionable query, table design, or server configuration decision, […]
Exploring PostgreSQL Indexes
In this blog, we continue our exploration on PostgreSQL indexes which we started here. In that article, […]
What is subsetting, what are the advantages, and how does ...
The post What is subsetting, what are the advantages, and how does it make test data management easier? […]
Identify log write limits on Azure SQL Managed Instance using ...
The post Identify log write limits on Azure SQL Managed Instance using QPI library appeared first on SQLServerCentral.
SQL Window Functions Series: LAG() and LEAD()
In the realm of data analysis, being able to understand the relationships between sequential data points is paramount. […]
Window Function Basics – PARTITION BY
One of the things that I’ve done over the last year to improve my T-SQL skills is learn […]
How using a database monitoring tool helps DBAs create value ...
The post How using a database monitoring tool helps DBAs create value for the whole organization appeared first […]
Learn Spark SQL Date and Time Functions
The post Learn Spark SQL Date and Time Functions appeared first on SQLServerCentral.
SQL Server: Optimize for Ad Hoc Workloads – use or ...
I used to believe this option was something almost absolute: it should be enabled as best practice. […]
How Has Inflation Affected Your Salary? Let’s Find Out Together.
The 2020s have been tough: a pandemic, a recession, layoffs, and inflation. Inflation makes things particularly tricky because […]
Microsoft dévoile les mises à jour apportées à SQL Server ...
Microsoft dévoile les mises à jour apportées à SQL Server Data Tools 17.8 dans Visual Studio 2022, […]
Plansplaining, part 20. SQL Graph (part 1)
The post Plansplaining, part 20. SQL Graph (part 1) appeared first on SQLServerCentral.
Always on Availability Groups for SQL Server containers on Kubernetes ...
Recently, I had the privilege of presenting with OJ Ngo from DH2i, our partners who offer the cluster […]
Who’s Hiring in the Microsoft Data Platform Community? December 2023 ...
Is your company hiring for a database position as of December 2023? Do you wanna work with the […]
Understanding SQL Join Types
Understanding how to join the data in one table to another is crucial for any data analyst […]
GitHub Copilot – Our Best Ally to for T-SQL
Introduction Previously, we wrote about Copilot and showed how to install and work with it. A GitHub copilot […]
Championing DevOps: A Panel Webinar
The post Championing DevOps: A Panel Webinar appeared first on SQLServerCentral.