Sites anglophones


 

Department of Redundancy Department

Publié le 18 mars 2024 sur simple-talk.com
 

Ever wonder all the reasons that we use databases instead of file systems? While we don’t think of it too much anymore, the first reason that databases came into existence was to remove redundancies. The first source of redundancy back in the dar …

 

Correct SQL Server Transactional Replication Issues with T-SQL and SSMS

Publié le 18 mars 2024 sur sqlservercentral.com
 

The post Correct SQL Server Transactional Replication Issues with T-SQL and SSMS appeared first on SQLServerCentral.

Find Unused or Backup Tables

Publié le 18 mars 2024 sur sqlservercentral.com
 

In this article, I am going to demonstrate how we can identify the unused tables of a given SQL database. As a database administrator, we must keep an audit of the database objects. You are administrating a database that has hundreds of tables and some …

The difference between BIN2 and Case-Sensitive collations in SQL

Publié le 15 mars 2024 sur sqlservercentral.com
 

A common question that arises in SQL Server collation discussions is whether a binary collation (BIN2) is functionally equivalent to a case-sensitive collation that is sensitive to all aspects of sensitivity (for instance, Latin1_General_100_CS_AS). In …

 

The Benefits of Volunteering at SQL Saturdays

Publié le 14 mars 2024 sur simple-talk.com
 

Editor note: The call for volunteer and speakers is open at on the Pass Data Community Summit 2024 site  for this year’s Summit coming up in Seattle November 4-8! Volunteering for local data events large and small is a great way to get into …

 

[Video] Office Hours: Speed Round

Publié le 14 mars 2024 sur brentozar.com
 

Not all of the questions y’all post at https://pollgab.com/room/brento require long-winded answers. Let’s conquer 22 questions in 15 minutes! Here’s what we discussed: 00:00 Start 01:05 JoseDBA: We just started monitoring our AlwaysOn …

SQL Server to PostgreSQL Database Schema Conversion

Publié le 13 mars 2024 sur sqlservercentral.com
 

The post SQL Server to PostgreSQL Database Schema Conversion appeared first on SQLServerCentral.

Option Recompile is a Magic Turbo Button That Actually Works.

Publié le 12 mars 2024 sur brentozar.com
 

I didn’t say that – Guy Glantser did. Guy Glantser is an Israeli SQL Server guru with a ton of great presentations on YouTube. I’ve had the privilege of hanging out with him in person a bunch of times over the year, and I’ll alw …

 

Transforming and Analyzing Data in PostgreSQL

Publié le 12 mars 2024 sur simple-talk.com
 

In our data hungry world, knowing how to effectively load and transform data from various sources is a highly valued skill. Over the last couple of years, I’ve learned how useful many of the data manipulation functions in PostgreSQL can superchar …

 

 

Get the most out of SQL Server Agent logs

Publié le 11 mars 2024 sur simple-talk.com
 

If you haven’t migrated your workloads to a managed database platform yet, you’re probably still relying on SQL Server Agent for various maintenance and other scheduled tasks. Most of the time, these processes just work. But when it’s …

 

Will AI end with SQL, Is this the end of SQL?

Publié le 11 mars 2024 sur sqlservercentral.com
 

Introduction to the End of SQL Will the AI end with SQL? That is the question. The AI is replacing many job positions, like content writers, designers, programmers, and more. For example, Buzzfeed laid off 15 % of its staff and replaced them with AI to …

Why Test-Driven Development? (Part 2)

Publié le 11 mars 2024 sur sqlservercentral.com
 

The post Why Test-Driven Development? (Part 2) appeared first on SQLServerCentral.

SSRS 2022 Install, Setup and Configuration

Publié le 8 mars 2024 sur sqlservercentral.com
 

The post SSRS 2022 Install, Setup and Configuration appeared first on SQLServerCentral.

Power BI Auto Detect Relationship Failure

Publié le 8 mars 2024 sur sqlservercentral.com
 

In this article, we will talk about how to manually create a relationship by identifying the primary and foreign keys if Power BI is unable to identify the correct auto-relationship between the tables after we import a dataset Sample Sales Data. Prepar …

What Happens When Multiple Queries Compile at Once?

Publié le 7 mars 2024 sur brentozar.com
 

An interesting question came in on PollGab. DBAmusing asked: If a query takes 5-7s to calculate the execution plan (then executes <500ms) if multiple SPIDS all submit that query (different param values) when there’s no plan at start, does each …


Pages :