Sites anglophones


I’m Coming to Boston for SQLSaturday!

Publié le 7 mars 2023 sur brentozar.com
 

I’m coming back to Boston for SQLSaturday this October 14th! On Friday the 13th (muhaha), before the event, I’m teaching a one-day pre-conference workshop on Mastering Query Tuning. You need to speed up a SQL Server app, and you’re allowed …

 

Synapse Serverless and Dedicated Pool: The differences no one told you about

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

The basic differences between Synapse Serverless and the Dedicated pool are obvious: While the serverless doesn’t store data, only access data from storage accounts and scale the MPP environment automatically, the dedicate SQL Pool keeps a static …

 

 

Optional Code in T-SQL Scripts using SQLCMD

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

When you are writing T-SQL scripts to save away, for example one to create a new database, there are often optional bits of code you need to run sometimes, and not others. In the creating a database script, there are quite a few parameters you will wan …

 

It’s Monday. Get Back to Learning PowerShell.

Publié le 6 mars 2023 sur brentozar.com
 

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… when you need …

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 …

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.

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 …


Pages :