Sites anglophones


How to use Jupyter Notebook in VSCode

Publié le 22 juillet 2024 sur sqlservercentral.com
 

Introduction Visual Studio Code (VSCode) is a free code editor used by many programmers. In this article, we will show how to integrate VSCode with Jupyter Notebook. Also, we will learn how to use markdown code to comment on our code in VSCode. What is …

Using Query Store to Identify CPU Intensive SQL Queries and Creating Proper Indexes

Publié le 22 juillet 2024 sur sqlservercentral.com
 

The post Using Query Store to Identify CPU Intensive SQL Queries and Creating Proper Indexes appeared first on SQLServerCentral.

 

An Introduction to Frappe Framework: Features and Benefits

Publié le 19 juillet 2024 sur simple-talk.com
 

Frappe is a full-stack, battery-included web framework with MariaDB as the database, written in Python and JavaScript. Frappe is a “batteries included” framework because it equips developers with a comprehensive suite of features for buildi …

 

Today’s a Good Day to Talk to Your Manager About Disaster Recovery.

Publié le 19 juillet 2024 sur brentozar.com
 

Last night, two major IT disasters struck: Microsoft Azure’s Central region went down for about 4 hours. The official post-mortem isn’t out yet, but rumor has it that while decommissioning legacy storage services, the product group deleted …

Notebook Jobs in Azure Data Studio

Publié le 19 juillet 2024 sur sqlservercentral.com
 

Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles on how the tool works, and this one continues the series. In this article, I want to look at the way Notebook jobs can be created in Azure Data Studio …

[Video] Office Hours in My Backyard

Publié le 18 juillet 2024 sur brentozar.com
 

On a pleasantly mild morning, I sat down on the patio and took your top-voted questions from https://pollgab.com/room/brento.   Here’s what we covered: 00:00 Start 00:56 MyTeaGotCold: When going in to a database blind, do you worry at all ab …

Query Exercise: Fix This Computed Column.

Publié le 17 juillet 2024 sur brentozar.com
 

Take any size of the Stack Overflow database and check out the WebsiteUrl column of the Users table: Sometimes it’s null, sometimes it’s an empty string, sometimes it’s populated but the URL isn’t valid. Let’s say that alo …

 

Auditing SQL Server – Part 2 – Hardware Audit

Publié le 17 juillet 2024 sur simple-talk.com
 

This is the second part of my series on auditing SQL Server. In the first part, I discussed basic server discovery and documentation. It covered some items to check at the hardware level and configuration items, but this section gets into more detailed …

 

Configure Microsoft Fabric Database Mirroring for Snowflake

Publié le 17 juillet 2024 sur sqlservercentral.com
 

The post Configure Microsoft Fabric Database Mirroring for Snowflake appeared first on SQLServerCentral.

Four steps towards tackling the complexity of managing multiple database platforms

Publié le 17 juillet 2024 sur sqlservercentral.com
 

The post Four steps towards tackling the complexity of managing multiple database platforms appeared first on SQLServerCentral.

Updated, Larger Stack Overflow Demo Database

Publié le 16 juillet 2024 sur brentozar.com
 

Stack Overflow publishes a data dump with all user-contributed content, and it’s a fun set of data to use for demos. I took the 2024-April data dump, and imported it into a Microsoft SQL Server database. It’s an 31GB torrent (magnet) that e …

 

T-SQL Tuesday #176 Roundup of advice

Publié le 16 juillet 2024 sur simple-talk.com
 

There was a lot of great advice, and I really wonder how much of this I would have listened to myself back in the day. In no order other than the order I found them in my comments and then XTwitter. This was fun, and if you are just now hearing of T-SQ …

 

 

Making Temporal Databases Work. Part 2: Computing Aggregates Across Temporal Versions

Publié le 16 juillet 2024 sur simple-talk.com
 

The temporal database is a database that can keep information on time when the facts represented in the database were, are, or will be valid. We briefly described major concepts of temporal databases and discussed types of queries that such databases c …

 

Prompt+ EAP: your AI-powered database development partner in the making

Publié le 15 juillet 2024 sur sqlservercentral.com
 

The post Prompt+ EAP: your AI-powered database development partner in the making appeared first on SQLServerCentral.

Exploring Generative Adversarial Networks (GANs) for Butterfly Image Generation

Publié le 15 juillet 2024 sur sqlservercentral.com
 

Introduction In the realm of image generation, Generative Adversarial Networks (GANs) have emerged as powerful tools, capable of creating remarkably realistic visuals. For professionals with decades of experience, witnessing this transformation is akin …


Pages :