Sites anglophones


How to Install SQL Server and the Stack Overflow Database on a Mac

Publié le 16 janvier 2023 sur brentozar.com
 

To follow along, you’ll need: An Apple Mac with an Apple Silicon processor (M1, M2, etc – not an Intel or AMD CPU) Azure Data Studio Docker Desktop 4.16.1 or newer An Internet connection In Docker Desktop, go into Settings, Features in Deve …

How to work with web information, maps, and images in Power BI

Publié le 16 janvier 2023 sur sqlservercentral.com
 

Introduction Sometimes, we need to work with images in Power BI. This tip will be about the FIFA 2022 World Cup. We will create a nice report about the World Cup’s best players. The report will have the name of the players with some statistics (goals, …

Bucket Sort Algorithm in Python to Sort a List of Array Values

Publié le 16 janvier 2023 sur sqlservercentral.com
 

The post Bucket Sort Algorithm in Python to Sort a List of Array Values appeared first on SQLServerCentral.

Database Sharding to help Improve Performance and Maintenance Tasks

Publié le 13 janvier 2023 sur sqlservercentral.com
 

The post Database Sharding to help Improve Performance and Maintenance Tasks appeared first on SQLServerCentral.

Using pre-commit to prevent simple mistakes

Publié le 13 janvier 2023 sur sqlservercentral.com
 

There is no level of experience or intelligence where we cease to make mistakes.  The simpler the mistake the harder we kick ourselves. The good news is that the simple mistakes often have  a simple means of ensuring that we do not make the same mistak …

How to Create a Box and Whisker Plot in Power BI Desktop

Publié le 13 janvier 2023 sur sqlservercentral.com
 

The post How to Create a Box and Whisker Plot in Power BI Desktop appeared first on SQLServerCentral.

[Video] Office Hours: Bad Hair Edition

Publié le 12 janvier 2023 sur brentozar.com
 

I am waaaay overdue for a haircut, but instead of being a responsible adult, I stopped to take your questions from https://pollgab.com/room/brento. 00:00 Start 00:43 Mike: We have 3 Dell PowerEdge R630 servers with SQL Server installed. Everything func …

Office Hours: Bad Questions Edition

Publié le 11 janvier 2023 sur brentozar.com
 

Normally, y’all post and upvote great questions at https://pollgab.com/room/brento, but in today’s episode, y’all upvoted some stinkers. Buckle up. 00:00 Start 00:47 SQLKB: Hi, according to sp_BlitzCache I usually have more than 260k …

Translate Text Data using Azure Cognitive Services

Publié le 11 janvier 2023 sur sqlservercentral.com
 

Executive Summary Microsoft Azure has several capabilities, including support for Machine Learning (ML) and Artificial Intelligence (AI). One of the AI and ML offerings that enable developers to build cognitive intelligence into applications is referre …

Useful Commands for Snowflake Transactions

Publié le 11 janvier 2023 sur sqlservercentral.com
 

The post Useful Commands for Snowflake Transactions appeared first on SQLServerCentral.

3 Ways to Debug T-SQL Code

Publié le 10 janvier 2023 sur brentozar.com
 

Writing new code = bugging. That part’s easy. Taking those bugs back out, that’s the hard part. Developers are used to their tools having built-in ways to show what line of code is running now, output the current content of variables, echo …

 

Index Types in PostgreSQL: Learning PostgreSQL with Grant

Publié le 9 janvier 2023 sur simple-talk.com
 

As with any other relational data management system (RDBMS), PostgreSQL uses indexes as a mechanism to improve data access. PostgreSQL has a number of different index types, supporting different behaviors and different types of data. In addition, again …

 

How to Create a Power BI report using MySQL data

Publié le 9 janvier 2023 sur sqlservercentral.com
 

Introduction In this article, we will learn to create a Power BI report using MySQL data. The article will teach us to use the MySQL Workbench (something like the SSMS, but for MySQL). We will do the following in this article. First, we will connect an …

Analyze Azure Cosmos DB data with Synapse Serverless SQL Pools

Publié le 9 janvier 2023 sur sqlservercentral.com
 

The post Analyze Azure Cosmos DB data with Synapse Serverless SQL Pools appeared first on SQLServerCentral.

Using sp_prepare and sp_execute to utilize prepared SQL statements

Publié le 6 janvier 2023 sur sqlservercentral.com
 

The post Using sp_prepare and sp_execute to utilize prepared SQL statements appeared first on SQLServerCentral.


Pages :