Technical Considerations for Data Ingestion – Part 2
In part one of this series, we discussed how to prepare for the ingestion of data. In this second part of the Art of Data Ingestion, we’ll discuss technical considerations for ingesting data. Once you’ve worked through the questions of what data it i …
Understanding Windows Server Cluster Quorum Options
The post Understanding Windows Server Cluster Quorum Options appeared first on SQLServerCentral.
Manage Data Over Time with SQL Server MERGE Statement
This article is part of Greg Larsen’s continuing series on Learning T-SQL. To see all 8 items in the series, click here. The basic MERGE statement The MERGE statement was introduced with SQL Server 2008. It provides a single statement to perform UPDATE …
[Video] Office Hours: Back Live on Twitch Again
After I stopped selling live classes, I took some time off all live broadcasting period. It was a nice couple of months over the holidays, had a good time with the family, and now I’m starting to fire up my Twitch channel again. I’m not set …
Synapse Serverless: CETAS requires DFS to work
CETAS is the acronym for Create External Table As Select. This allow us to export the result of a select to an external table in different formats, such as PARQUET or CSV. We can also convert the format from one external table to another. The SELECT us …
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.