Verifying Trees
Introduction Employee lists in organizations are often maintained in spreadsheets or database tables which record each employee’s number, name, position and so on. As well, each employee has a Position Number and Parent Position (or something like tha …
PostgreSQL Basics: Roles and Privileges
Authentication Authorization Verify that the user is who they claim to be. This can be through password, trust, or some other federated login (like Kerberos) As an authenticated user, what am I permitted to do within the system? Before we get started, …
The 20th Anniversary of the SQL Slammer Worm
Twenty years ago this month (next Wednesday to be exact), sysadmins and database administrators started noticing extremely high network traffic related to problems with their SQL Servers. The SQL Slammer worm was infecting Microsoft SQL Servers. Micros …
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 …