Sites anglophones


Updated First Responder Kit and Consultant Toolkit for June 2023

Publié le 21 juin 2023 sur brentozar.com
 

This one’s a pretty quiet release: just bug fixes in sp_Blitz, sp_BlitzLock, and sp_DatabaseRestore. Wanna watch me use it? Take the class. To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First …

How to Avoid N+1 Queries: Comprehensive Guide and Python Code Examples

Publié le 21 juin 2023 sur sqlservercentral.com
 

Introduction N+1 queries are a prevalent performance issue in software applications that involve retrieving data from databases. The N+1 query problem occurs when an application retrieves a collection of records and their associated data by making a se …

The Best Career Advice I Ever Got (#TSQL2sday)

Publié le 20 juin 2023 sur brentozar.com
 

Steve Jobs. Photo by Matthew Yohe. I have been absurdly lucky to be around so many amazing and inspirational managers. Almost everything I know was taught to me by someone else. Over my life, I’ve learned so much about careers, marketing, busines …

 

Snowflake: A Cloud Warehouse Solution for Analytics

Publié le 19 juin 2023 sur simple-talk.com
 

This article explains what Snowflake data warehouse is and how it is different from other traditional data warehouses. This article will cover how to create virtual warehouses and different types of tables, how to handle semi-structured data, how to pr …

 

ISJSON enhancements in SQL Server for valid JSON format for a Value, Array or Object

Publié le 19 juin 2023 sur sqlservercentral.com
 

The post ISJSON enhancements in SQL Server for valid JSON format for a Value, Array or Object appeared first on SQLServerCentral.

Advantages of Kappa architecture in the Modern Data Stack

Publié le 19 juin 2023 sur sqlservercentral.com
 

Introduction In the big data era, organizations require real-time processing to make well-informed decisions and extract valuable insights from vast amounts of data. Initially, Lambda architecture emerged to address these needs. While it successfully p …

Understanding Power BI Security Options – Row-Level, Column-Level and Object-Level Security

Publié le 19 juin 2023 sur sqlservercentral.com
 

The post Understanding Power BI Security Options – Row-Level, Column-Level and Object-Level Security appeared first on SQLServerCentral.

Horizontal Trees

Publié le 16 juin 2023 sur sqlservercentral.com
 

Introduction The sp_HorizontalTree procedure introduced here may be used to audit tables with dependent columns. A column is dependent on another if the meaning of the first column depends on the meaning of the second. For example, in a table containin …

How to Visualize Timeseries Data with the Plotly Python Library

Publié le 16 juin 2023 sur sqlservercentral.com
 

The post How to Visualize Timeseries Data with the Plotly Python Library appeared first on SQLServerCentral.

Using Windows Security and Encryption with Flyway

Publié le 16 juin 2023 sur sqlservercentral.com
 

The post Using Windows Security and Encryption with Flyway appeared first on SQLServerCentral.

 

Working with MySQL transactions

Publié le 15 juin 2023 sur simple-talk.com
 

MySQL transactions provide an effective method for executing multiple statements as a single unit, making it possible to safely modify data, while preventing concurrent users from updating the same data or overwriting changed data. If any statements wi …

 

Why Are Y’all Changing the Compat Levels on Master?

Publié le 15 juin 2023 sur brentozar.com
 

One of the things I love about SQL ConstantCare® (which happens to be free this month, by the way) is that I can keep in touch with what y’all are actually doing on your production servers. Today’s lesson was a complete shocker to me: some …

 

Unmasking SQL Server Dynamic Data Masking, Part 3, Security Concerns

Publié le 14 juin 2023 sur simple-talk.com
 

This is the third part of a series on SQL Server Dynamic Data Masking. The first part in the series was a brief introduction to dynamic data masking, completing solutions, and use cases. The second part covered setting up masking and some examples. Thi …

 

[Video] Office Hours: Almost Back in San Francisco

Publié le 14 juin 2023 sur brentozar.com
 

It’s back to lighter fog-friendly clothes as the ship pulls into San Francisco and I answer your questions from https://pollgab.com/room/brento. Here’s what we discussed: 00:00 Start 01:16 Pozzolan: Hey Brent, My companies budget for SQL li …

Calculating Prime Numbers With One Query

Publié le 14 juin 2023 sur sqlservercentral.com
 

Introduction I want to share the solution to the problem of searching for prime numbers using T-SQL. The problem was proposed on a reputable educational web resource. The problem is defined as follows: write all prime numbers less than or equal to 1000 …


Pages :