How to Install SQL Server and the Stack Overflow Database on a Mac
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
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
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
The post Database Sharding to help Improve Performance and Maintenance Tasks appeared first on SQLServerCentral.
Using pre-commit to prevent simple mistakes
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
The post How to Create a Box and Whisker Plot in Power BI Desktop appeared first on SQLServerCentral.
[Video] Office Hours: Bad Hair Edition
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
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
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
The post Useful Commands for Snowflake Transactions appeared first on SQLServerCentral.
3 Ways to Debug T-SQL Code
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
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
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
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
The post Using sp_prepare and sp_execute to utilize prepared SQL statements appeared first on SQLServerCentral.