Analyze and Tune SQL Server Statistics
Over the years, SQL Server Statistics have been discussed in countless blog posts, articles, and presentations, and […]
Sites anglophones
How Would You Design This: Scheduling Classes
One of the challenges for many database developers is coming up with a good design that not only […]
New Amazon X2iedn High-Memory Instances
Amazon just announced new X2iedn instance types for Amazon RDS SQL Server. They’re a sweet deal for people […]
Microsoft Fabric: Checking and Fixing Tables V-Order Optimization
Download the notebook used on this blog I explained in a previous article how the Tables in […]
[Video] Office Hours at Svínafellsjökull Glacier in Iceland
Got Azure SQL DB and SQL Server questions? Post them at https://pollgab.com/room/brento and I’ll answer the top-voted ones. […]
How Effective Is Your Data Load Monitoring in SQL and ...
As organizations load an increasing amount of data from different sources into their data warehouses, monitoring these data […]
GPT Base, GPT-3.5 Turbo & GPT-4: What's the difference?
The post GPT Base, GPT-3.5 Turbo & GPT-4: What's the difference? appeared first on SQLServerCentral.
12 Office Hours Questions I Don’t Have Answers For
Hey, you! You look smart. Here are highly-upvoted questions that fellow readers submitted at https://pollgab.com/room/brento that I don’t […]
Interactive Data Analytics With PowerShell, SQL, and ChatGPT (Sample Script)
Learn about the integration of PowerShell, SQL Server data, and ChatGPT for interactive data analytics.
Alternatives To SQL-2022 Built-in function GREATEST
If you haven’t already heard, SQL 2022 has introduced a new built-in system function called GREATEST. Simply […]
PostgreSQL 101: A guide to PostgreSQL documentation & useful resources
The post PostgreSQL 101: A guide to PostgreSQL documentation & useful resources appeared first on SQLServerCentral.
GENERATE_SERIES() Breaks Minimal Logging
tl;dr The title says it all. Prologue One of the keys to my personal learning is that, very […]
SQL Server Execution Plan Issues when using TOP Clause and ...
The post SQL Server Execution Plan Issues when using TOP Clause and Various Parameters appeared first on SQLServerCentral.
SQL Server Row Level Security Deep Dive. Part 4 – ...
One of the primary reasons to implement RLS is to facilitate reporting and ease the administrative burden. […]
How To Filter SQL Server Data in Windows PowerShell
Explore techniques for filtering SQL Server data using both PowerShell and SQL queries.
Backup and Restore SQL Database to Azure Blob Storage
SQL databases are crucial for businesses, so it’s critical to back them up. A dependable and affordable option […]
Generate Test Data Sets for Testing SQL Server Database Applications
The post Generate Test Data Sets for Testing SQL Server Database Applications appeared first on SQLServerCentral.
Announcing SQLBits 2024: 19-23 March, Near London
I hate picking favorites, but I gotta be honest: SQLBits is my favorite conference. Sure, like any conference, […]
Microsoft Fabric: Using notebooks and table partitioning to convert files ...
When Microsoft Fabric was born, the only method to convert files to tables was using notebooks. Nowadays […]
[Video] Office Hours at Breiðamerkursandur, Diamond Beach
Post your Azure SQL DB and SQL Server questions at https://pollgab.com/room/brento and upvote the ones you’d like to […]
“Oops, I Lost My Indexes in Azure SQL DB.”
I got an interesting request for consulting, and I’m going to paraphrase it: We were using Azure SQL […]
How To Visualize SQL Server Data in PowerShell (With Sample ...
Learn how to use data from a SQL Server database to create graphs and charts in PowerShell. A […]
What’s Faster: IN or OR? Columnstore Edition
Pinal Dave recently ignited a storm of controversy when he quizzed readers about which one of these would […]
Webinar: The Impact of the Cloud on Databases
The post Webinar: The Impact of the Cloud on Databases appeared first on SQLServerCentral.
How to create a SQL Server presentation in 5 minutes ...
Introduction This SQLServerCentral article shows how to create a SQL Server presentation in 5 minutes using AI. AI […]
Working with NULL Values in SQL
The post Working with NULL Values in SQL appeared first on SQLServerCentral.
SQL Server Row Level Security Deep Dive. Part 3 – ...
Previous sections gave a brief introduction to RLS, including some common use cases. They also showed how […]
How to Use SQL to Analyze the Bitcoin Blockchain
Background The Bitcoin blockchain is a vast and complex database. It contains over 100 million blocks, each of […]
Decision Tree – Credit Card Fraud Detection
Credit card fraud detection is an important application of machine learning techniques, including Decision Trees. The goal is […]
SQL Unit Testing reference guide for beginners
The post SQL Unit Testing reference guide for beginners appeared first on SQLServerCentral.
Working with MySQL constraints
MySQL provides a set of constraints that you can include in your table definitions to help ensure […]
[Video] Office Hours at Jökulsárlón Glacial Lagoon
Post your Azure SQL DB and SQL Server questions at https://pollgab.com/room/brento and upvote the ones you’d like to […]
How To Connect to SQL Server Database From PowerShell
PowerShell can be a valuable tool for data analytics and data orchestration, especially when dealing with SQL Server […]
Microsoft Fabric: Lakehouse and Data Factory in Power BI environment
Microsoft is merging Data Factory and Power BI Dataflows in one single ETL solution. It’s not a […]
[Video] Office Hours at the Blue Lagoon
Road trip time! I’m recovering from jet lag after flying over to Iceland, so I went through your […]
Quickstart: Connect SQL Server machines to Azure Arc
The post Quickstart: Connect SQL Server machines to Azure Arc appeared first on SQLServerCentral.
Who’s Hiring in the Microsoft Data Platform Community? September 2023 ...
Is your company hiring for a database position as of September 2023? Do you wanna work with the […]
Orchestrating a MySQL Container on Kubernetes
If you’ve been using MySQL for a while and want to learn how to orchestrate MySQL containers, […]
Why Australian Azure SQL DBs Went Down for 8+ Hours
On August 30, Azure’s Australia East data center had a big problem, affecting customers like Bank of Queensland […]
Optimized Plan Forcing with Query Store in SQL Server 2022
In this article, we will delve into the world of Query Store and explore how to use Optimized […]
How To Use Flyway for Database Migration in Spring Boot
The post How To Use Flyway for Database Migration in Spring Boot appeared first on SQLServerCentral.
SQL Server Row Level Security Deep Dive. Part 2 – ...
The previous section in this series was an introduction to Row Level Security (RLS) and some use […]
Setting up Drill Through in the New Power BI Report ...
The post Setting up Drill Through in the New Power BI Report User Interface appeared first on SQLServerCentral.
Export and Import SSISDB in just a few clicks
From SQL Server 2012 onwards, Microsoft introduced a new deployment model in SSIS called the project deployment model. […]
[Video] Office Hours: Overly Caffeinated Edition
After consuming waaaay too much coffee, I went through your top-voted questions from https://pollgab.com/room/brento: Here’s what we covered: […]
[Video] Office Hours: All About Miles Edition
Today’s webcast featured an awful lot of questions from one particular person who was super-active at https://pollgab.com/room/brento: Here’s […]
Let’s talk about Artificial Intelligence, ChatGPT and Gobbledegook
The post Let’s talk about Artificial Intelligence, ChatGPT and Gobbledegook appeared first on SQLServerCentral.
Free Webcast: Avoiding Deadlocks by Tuning Queries
You’ve been getting more and more deadlock errors, and users are starting to complain. You’re wondering if your […]
Microsoft Fabric: Loading On-Premises and External Data
Loading On-Premises and external data is a fundamental need for a Data Platform such as Microsoft Fabric. […]
How to export data to SQL Server using Bard (Google ...
The article will explain how to export data to SQL Server with Bard can be challenging. Previously, we […]