Sites anglophones


Snowflake for SQL Server Developers – NULL Functions – Part 2

Publié le 6 mars 2023 sur sqlservercentral.com
 

The post Snowflake for SQL Server Developers – NULL Functions – Part 2 appeared first on SQLServerCentral.

ChatGPT in SQL Server – Practical examples

Publié le 6 mars 2023 sur sqlservercentral.com
 

Introduction ChatGPT in SQL Server In this article, we will learn some basic examples of ChatGPT in SQL Server. In a previous article, we had an interview with ChatGPT an AI chatbot developed by OpenAI. If you do not know how to use it yet, you can go …

Understanding Azure Synapse Analytics Pricing

Publié le 3 mars 2023 sur sqlservercentral.com
 

Introduction Azure Synapse Analytics combines data integration, enterprise data warehousing, and data analytics. It is a cloud-based limitless data integration and analytics platform. It provides a cloud platform to create data pipelines from various s …

How to Improve the Quality of Database Releases using Clones

Publié le 3 mars 2023 sur sqlservercentral.com
 

The post How to Improve the Quality of Database Releases using Clones appeared first on SQLServerCentral.

Creating Animated Line Plots with Python

Publié le 3 mars 2023 sur sqlservercentral.com
 

The post Creating Animated Line Plots with Python appeared first on SQLServerCentral.

 

Retrieving MySQL data from within Python

Publié le 2 mars 2023 sur simple-talk.com
 

Applications of all types commonly access MySQL to retrieve, add, update, or delete data. The applications might be written in Python, Java, C#, or another programming language. Most languages support multiple methods for working with a MySQL database …

 

I’m Coming to Gothenburg and Oslo This Fall!

Publié le 2 mars 2023 sur brentozar.com
 

Back in 2020 before the wheels came off the world, I’d scheduled visits to Gothenburg and Oslo for their annual SQL Server events. Now that things are back to normal, it’s back on! Data Saturday Gothenburg, Aug 26 & 28, 2023 – Mon …

Learn PowerShell in 30 Minutes a Day, Free, Starting Now.

Publié le 1 mars 2023 sur brentozar.com
 

The clock starts now! You’re a production database administrator responsible for the health, security, and uptime of many database servers. You’ve been pointing and clicking your way through SSMS for years, scripting out T-SQL to files, but …

Testing before coding: shifting farther left

Publié le 1 mars 2023 sur sqlservercentral.com
 

The post Testing before coding: shifting farther left appeared first on SQLServerCentral.

 

Getting Out of Character

Publié le 28 février 2023 sur simple-talk.com
 

Pre-Unicode Younger programmers have grown up with ASCII and Unicode as the only ways of representing character data in a computer. But in the dark ages, before we invented dirt and entered into the stone age, there were other contenders. The Control D …

 

Can You Nest Transactions in SQL Server?

Publié le 28 février 2023 sur brentozar.com
 

To find out, let’s set up a simple status log table:DROP TABLE IF EXISTS dbo.StatusLog; CREATE TABLE dbo.StatusLog (TimeItHappened DATETIME2 PRIMARY KEY CLUSTERED, Step VARCHAR(20)); GO And then let’s try a two-part transaction:BEGIN TRAN I …

Event exceeds the number of allowable bound actions

Publié le 27 février 2023 sur sqlskills - jonathan kehayas
 

Did you know that there is a limit to the number of actions you can add to a single event in Extended Events? While I was playing around with Trace Flag 9708 for my previous blog post, one of the things I wanted to try to see was whether it would be ea …

How to create a Sankey Chart in Power BI Desktop

Publié le 27 février 2023 sur sqlservercentral.com
 

The post How to create a Sankey Chart in Power BI Desktop appeared first on SQLServerCentral.

How to Forecast Data in Power BI

Publié le 27 février 2023 sur sqlservercentral.com
 

Introduction In this article, we will learn how to Forecast data in Power BI. Forecasting in Power BI will help us to predict the future based on our current information. You can easily forecast in Power BI by following some simple steps. Requirements …

The business value of frequent deployments

Publié le 27 février 2023 sur sqlservercentral.com
 

The post The business value of frequent deployments appeared first on SQLServerCentral.


Pages :