Sites anglophones


SQL Automate – A DBA’s Time-Saving Toolkit

Publié le 6 juin 2025 sur sqlservercentral.com
 

Introduction Installing SQL Server can be a very boring and time consuming task, especially when you have to repeat the same steps across multiple servers. It not only takes your time, but doing the repetitive things makes it a tiresome activity for an …

Index Scans and Table Scans

Publié le 6 juin 2025 sur sqlservercentral.com
 

The post Index Scans and Table Scans appeared first on SQLServerCentral.

 

Oracle ASM: A Simple Solution or Another Complexity? (part 1)

Publié le 5 juin 2025 sur simple-talk.com
 

For highly performant Oracle databases, the storage must be scalable, resilient, and easy to manage—especially as infrastructure complexity grows with Real Application Cluster (RAC), virtualized infrastructure, and multi-tenant database architectures. …

 

[Video] Office Hours in the Detroit Airport

Publié le 5 juin 2025 sur brentozar.com
 

I’m in the Detroit airport today, en route home after a client gig. I’ve got some time to kill, so let’s go through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:39 SQLLearner: Hi Brent! I’m curio …

Query Exercise: Return Routes in the Right Order

Publié le 4 juin 2025 sur brentozar.com
 

I’mma be honest with you, dear reader: this query exercise stems from a client problem that I couldn’t figure out how to solve in the time constraints that I had, and it drove me crazy. I wanted to put hours into this to figure it out, and I was sure t …

Performing a Bulk Insert in SQL Server

Publié le 4 juin 2025 sur sqlmag.com
 

Learn how to use the BULK INSERT command to import large data sets into SQL Server.

Managing Fabric Lakehouse objects with the new CLI: Data Engineering with Fabric

Publié le 4 juin 2025 sur sqlservercentral.com
 

Microsoft Fabric has been evolving since its general availability in November 2023. Developers have asked for a command line interface (CLI) to manage the objects in Fabric. Microsoft has responded with the preview of the Fabric Command Line Interface …

Who’s Hiring in the Microsoft Database Community? June 2025 Edition

Publié le 3 juin 2025 sur brentozar.com
 

Is your company hiring for a database position as of June 2025? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must include the …

 

MySQL vs. PostgreSQL: Date and Time Data Types

Publié le 3 juin 2025 sur simple-talk.com
 

Date and time data types are important because they help track and manage time-based information in databases. This includes things like recording when orders are placed, scheduling events, or calculating the time between two activities. In this articl …

 

DMV Comparison for SQL Server 2019 vs Azure SQL Database

Publié le 2 juin 2025 sur sqlservercentral.com
 

The post DMV Comparison for SQL Server 2019 vs Azure SQL Database appeared first on SQLServerCentral.

Parameterize Connections in Microsoft Fabric Data Factory using Variable Libraries

Publié le 2 juin 2025 sur sqlservercentral.com
 

When you create a data pipeline in Microsoft Fabric, you typically use one or more connections. A connection points to a certain data source (such as Azure Blob Storage, a relational database, a Cosmos DB instance etc.) or to a destination in Fabric (O …

 

Moving from SQL to MongoDB’s MQL

Publié le 30 mai 2025 sur simple-talk.com
 

This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the items in the series, click here. People new to MongoDB often come to the platform with a background in relational database management systems (RDBMSs) such as MyS …

 

Power BI Mistakes to Avoid – Part 2

Publié le 30 mai 2025 sur sqlservercentral.com
 

The post Power BI Mistakes to Avoid – Part 2 appeared first on SQLServerCentral.

Sentiment Analysis & Key Phrase Detection

Publié le 30 mai 2025 sur sqlservercentral.com
 

Recently I worked on a neat little POC with Patrick Leblanc for a customer in Education who wished to perform sentiment analysis and key phrase extraction on surveys completed by students regarding classes and instructors, which brings me to this blog …

 

Using Parameters with DAX in Report Builder

Publié le 30 mai 2025 sur simple-talk.com
 

This is something we expect to be simple, but it has a lot of secrets. Using parameters in DAX queries is essential, as any other query: The parameter transfers the filtering to the server side instead of the report side and optimize the report perform …

 


Pages :