Sites anglophones


 

Microsoft Fabric: Data Warehouse Ingestion using T-SQL and more

Publié le 24 mai 2023 sur simple-talk.com
 

.In this blog I will illustrate how we can ingest data from a blog storage to a Microsoft Fabric Data Warehouse using T-SQL. Create a new workspace On the left ribbon, click Workspaces. Click the New Workspace button. Provide a name for the workspace. …

 

 

Data Intelligence on light speed: Microsoft Fabric

Publié le 24 mai 2023 sur simple-talk.com
 

This article is based on exciting information just released at Microsoft’s Build conference on May 23, 2023. What we have today When Synapse Analytics was created, technical sessions inspired me with some comparisons and explanations, and I repro …

 

Using Azure Data Studio to Deploy a SQL Server VM on Azure

Publié le 24 mai 2023 sur sqlservercentral.com
 

Introduction Sometimes we need to deploy many SQL Servers on Azure in the enterprise environment. Wwe can do this manually, but it is not a good solution as there are too many manual tasks and repetitive tasks. Today I will give you a showcase to deplo …

 

Self Review: Practical Graph Structures in SQL Server and Azure SQL

Publié le 23 mai 2023 sur simple-talk.com
 

I just finished writing this book a few weeks ago, and as I read it, I thought “why not review my own book?” Of course, the question that first comes to mind is “are you insane?” It seems like a no-win proposition. Anything less …

 

Microsoft Build 2023 Keynote Live Blog: Introducing Fabric

Publié le 23 mai 2023 sur brentozar.com
 

Goooood morning, party people! Today is the opening day of the annual Microsoft Build conference, an event focused on people like developers and power users who build things with Microsoft tools. I’ve never attended Build in person before because …

[Video] Office Hours: Azure & SQL Server Q&A

Publié le 23 mai 2023 sur brentozar.com
 

Y’all post questions at https://pollgab.com/room/brento, and I go through the top-voted ones on my Twitch channel streams.   Here’s what we covered today: 00:00 Start 01:56 Manoj: Where do you see artificial intelligence having the mos …

 

Optimizing MySQL: Adding Data to Tables

Publié le 22 mai 2023 sur simple-talk.com
 

Welcome back to the MySQL optimization series! In case you haven’t been following this series, in the past couple of articles we have discussed the basics of query optimization, and told you how to optimize SELECT queries for performance as well. …

 

How to Generate Images with AI and Store them in SQL Server using Python and DALL·E

Publié le 22 mai 2023 sur sqlservercentral.com
 

Introduction In this article, we will learn how to generate images with AI. This time we will work with DALL·E. DALL·E is an image generator using AI. You just need to provide a description and DALL·E will generate the image: In this article we will le …

PostgreSQL 101: The 10 key differences between SQL Server & PostgreSQL

Publié le 22 mai 2023 sur sqlservercentral.com
 

The post PostgreSQL 101: The 10 key differences between SQL Server & PostgreSQL appeared first on SQLServerCentral.

Cache SQL Server Data in a .NET Web Application

Publié le 22 mai 2023 sur sqlservercentral.com
 

The post Cache SQL Server Data in a .NET Web Application appeared first on SQLServerCentral.

Common Table Expression Basics

Publié le 19 mai 2023 sur sqlservercentral.com
 

Introduction Firstly, we need to understand what is a common table expression. Common table expressions, also abbreviated as CTE, are virtual tables which are formed by collecting and formatting data from one or multiple source table(s). These virtual …

The Journey to Team-based Development with Flyway

Publié le 19 mai 2023 sur sqlservercentral.com
 

The post The Journey to Team-based Development with Flyway appeared first on SQLServerCentral.

REPLACE versus TRANSLATE for SQL Server Text Data Manipulation

Publié le 19 mai 2023 sur sqlservercentral.com
 

The post REPLACE versus TRANSLATE for SQL Server Text Data Manipulation appeared first on SQLServerCentral.

 

PostgreSQL Basics: A Template for Managing Database Privileges

Publié le 18 mai 2023 sur simple-talk.com
 

In the first two articles of this series about PostgreSQL privileges, we reviewed how to create roles, grant them privileges to database objects, and how object ownership is an important aspect in managing access and control within the database. When i …

 

[Video] Office Hours: Professional Development & Training Questions

Publié le 18 mai 2023 sur brentozar.com
 

A lot of today’s questions from https://pollgab.com/room/brento have a common theme, but it’s just a coincidence: Here’s what we covered: 00:00 Start 07:40 Maciej: Hi Brent, when you are working on the course/training how do you know …


Pages :