Sites anglophones


[Video] Office Hours with a Surprise Special Guest

Publié le 12 octobre 2023 sur brentozar.com
 

I have a special guest star on today’s episode: Pinal Dave dropped by the house! We went through a few of the top-voted questions from https://pollgab.com/room/brento. 00:00 Start 00:15 What happened to you? Did you spend too much time in the sun …

[Video] Office Hours at the Northernmost Town in the World

Publié le 11 octobre 2023 sur brentozar.com
 

Despite its location, Hammerfest, Norway attracts countless tourists eager to see the festival celebrating one of the world’s favorite rappers. Did I get that right? I’m not sure I got that right. There’s also fierce competition for t …

Parsing a Pairs of Values in a String While Preserving Order

Publié le 11 octobre 2023 sur sqlservercentral.com
 

Introduction In a project I’m currently working on, I need to modify a stored procedure that returns a list of items based on criteria set by the procedure parameters. The new requirement is as follows: the stored procedure must be able to retrieve the …

Well, I’m Not Doing SQLBits After All.

Publié le 10 octobre 2023 sur brentozar.com
 

I was so excited when SQLBits announced their 2024 dates & location, and I told y’all that I was blocking out my calendar and I’d be there. Unfortunately, not gonna happen. This year, SQLBits dramatically cut payments for speakers. We u …

 

PostgreSQL Indexes: What They Are and How They Help

Publié le 9 octobre 2023 sur simple-talk.com
 

In the previous blog in this series, we learned how to produce, read and interpret execution plans. We learned that an execution plan provides information about access methods, which PostgreSQL use to select records from a database. Specifically, we ob …

 

Alternatives To SQL Server 2022 Built-in function GREATEST

Publié le 9 octobre 2023 sur sqlservercentral.com
 

The post Alternatives To SQL Server 2022 Built-in function GREATEST appeared first on SQLServerCentral.

SQL Athena Introduction – How it works, Use Cases and Advantages

Publié le 9 octobre 2023 sur sqlservercentral.com
 

The post SQL Athena Introduction – How it works, Use Cases and Advantages appeared first on SQLServerCentral.

The Basics of Using GENERATE_SERIES()

Publié le 9 octobre 2023 sur sqlservercentral.com
 

First, SQL Server 2022 has many interesting new features for both DBAs and database developers. GENERATE_SERIES is one of the new additions, and will likely please a lot of database developers and administrators. This function allows us to create a tab …

Using SQLite with Flutter

Publié le 6 octobre 2023 sur sqlservercentral.com
 

Storing, retrieving, and modifying data are common tasks in many applications. In a cross-platform application, it is important to have a lightweight storage mechanism, as opposed to a heavy database software. This article explores how to use SQLite in …

Power BI Workspace Permissions and Roles

Publié le 6 octobre 2023 sur sqlservercentral.com
 

The post Power BI Workspace Permissions and Roles appeared first on SQLServerCentral.

Different Ways to Populate the List of Tables

Publié le 6 octobre 2023 sur sqlservercentral.com
 

A database administrator has various tasks and responsibilities. Managing and keeping track of the database  is one of them. Whether you are new or an experienced database administrator, you must know how to get the list of tables because of following …

 

First Normal Form Gets No Respect

Publié le 5 octobre 2023 sur simple-talk.com
 

Dr. Codd first described the relational model in a paper in Communications of the ACM (CACM 13 No 6; June 1970). Some more work followed up after that by other people, giving us normal forms and other things we have taken for granted for 50+ years. …

 

[Video] Office Hours at the Arctic Circle

Publié le 5 octobre 2023 sur brentozar.com
 

Just after passing the Arctic Circle marker and celebrating with a glass of champagne, I took your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:13 TheEveryDayDBA: Does it matter on what column y …

 

Fabric: My Content compilation

Publié le 4 octobre 2023 sur simple-talk.com
 

Microsoft Fabric was first announced during Microsoft BUILD. Since then, I’m publishing content about Microsoft Fabric, creating an interesting sequence of content. In this blog, I’m summarizing the content I published about Fabric, helping …

 

[Video] Office Hours Off the Coast of Norway

Publié le 4 octobre 2023 sur brentozar.com
 

Come join me in my cabin aboard the Hurtigruten Nordlys, sailing up the coast of Norway, and we’ll cover your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered today: 00:00 Start 00:57 Accidental DBA: What are …


Pages :