Azure Functions and Managed Identity: More Secrets
I wrote about Managed Identity Secrets a few weeks ago, but since that article was published I made new interesting discoveries to add more to these secrets. The combination of possibilities is considerable, and I faced two new situations I hadn’ …
How to Import Data in Power BI Using R
Introduction In this article, we will learn how to import data in Power BI using R. R and Python are standard tools used in Power BI. In a previous article, we learned how to import data in Power BI using Python. This time we will learn to use R. The a …
A Version Control Strategy for Database DevOps
The post A Version Control Strategy for Database DevOps appeared first on SQLServerCentral.
SQL Server Function Examples with JSON Files
The post SQL Server Function Examples with JSON Files appeared first on SQLServerCentral.
SQL Server point in time recovery
The post SQL Server point in time recovery appeared first on SQLServerCentral.
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, …