Sites anglophones


 

SQL Server Row Level Security Deep Dive. Part 5 – RLS Attacks

Publié le 25 septembre 2023 sur simple-talk.com
 

As mentioned in previous sections, RLS is an addition to security and should not be used as the primary method to limit access to data. It is a supplementary layer, useful in specific scenarios. There are also instances where RLS can be defeated by an …

 

Restore With Standby; A Review and A Lesson Learned

Publié le 25 septembre 2023 sur sqlservercentral.com
 

There are features of SQL Server I use often and consider to understand reasonably well, features I know but rarely use, and probably a whole list of things I’ve only looked at or used once. Within the realm of things I know, sometimes I find that I ha …

AI-900: Microsoft Azure AI Fundamentals Certification Exam Tips and Tricks

Publié le 25 septembre 2023 sur sqlservercentral.com
 

The post AI-900: Microsoft Azure AI Fundamentals Certification Exam Tips and Tricks appeared first on SQLServerCentral.

 

MySQL joins

Publié le 25 septembre 2023 sur simple-talk.com
 

Tables in a MySQL database are commonly related to one another, often in multiple ways, and it is only by linking the tables together that you can derive meaningful information from the data. To connect these tables together, you can use the JOIN claus …

 

 

Analyze and Tune SQL Server Statistics

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

Over the years, SQL Server Statistics have been discussed in countless blog posts, articles, and presentations, and I believe that they will remain a core topic for a while when speaking about performance. Why is that? Well, if we were to consider the …

 

How Would You Design This: Scheduling Classes

Publié le 22 septembre 2023 sur sqlservercentral.com
 

One of the challenges for many database developers is coming up with a good design that not only meets the specifications but also performs well in queries. Relational databases often seek some level of normalization, which reduces the update load for …

New Amazon X2iedn High-Memory Instances

Publié le 21 septembre 2023 sur brentozar.com
 

Amazon just announced new X2iedn instance types for Amazon RDS SQL Server. They’re a sweet deal for people who want a high-performance managed database, with really fast cores and more memory per core than you can get in Azure’s managed SQL …

 

Microsoft Fabric: Checking and Fixing Tables V-Order Optimization

Publié le 20 septembre 2023 sur simple-talk.com
 

Download the notebook used on this blog I explained in a previous article how the Tables in a lakehouse are V-Order optimized. We noticed this configuration depends on our settings, which can be enabled or not. One question remains: How could we check …

 

[Video] Office Hours at Svínafellsjökull Glacier in Iceland

Publié le 20 septembre 2023 sur brentozar.com
 

Got Azure SQL DB and SQL Server questions? Post them at https://pollgab.com/room/brento and I’ll answer the top-voted ones. This episode comes to you from the most hike-friendly glacier in Iceland, one where you can park your car and step onto th …

How Effective Is Your Data Load Monitoring in SQL and Python?

Publié le 20 septembre 2023 sur sqlservercentral.com
 

As organizations load an increasing amount of data from different sources into their data warehouses, monitoring these data loads becomes ever more crucial. Traditional database monitoring happens at the level of the whole database. When a solution inc …

GPT Base, GPT-3.5 Turbo & GPT-4: What's the difference?

Publié le 20 septembre 2023 sur sqlservercentral.com
 

The post GPT Base, GPT-3.5 Turbo & GPT-4: What's the difference? appeared first on SQLServerCentral.

12 Office Hours Questions I Don’t Have Answers For

Publié le 19 septembre 2023 sur brentozar.com
 

Hey, you! You look smart. Here are highly-upvoted questions that fellow readers submitted at https://pollgab.com/room/brento that I don’t have answers for. If you’d like to jump into the comments, you can reference questions by number with …

Interactive Data Analytics With PowerShell, SQL, and ChatGPT (Sample Script)

Publié le 19 septembre 2023 sur sqlmag.com
 

Learn about the integration of PowerShell, SQL Server data, and ChatGPT for interactive data analytics.

 

Alternatives To SQL-2022 Built-in function GREATEST

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

If you haven’t already heard, SQL 2022 has introduced a new built-in system function called GREATEST. Simply put, it is to a set of columns, variables, expressions etc. what the MAX function is to a set of values (i.e., rows) of a single column o …

 

PostgreSQL 101: A guide to PostgreSQL documentation & useful resources

Publié le 18 septembre 2023 sur sqlservercentral.com
 

The post PostgreSQL 101: A guide to PostgreSQL documentation & useful resources appeared first on SQLServerCentral.


Pages :