Sites anglophones


Managing Database Code Quality in a Flyway Development

Publié le 1 juin 2022 sur sqlservercentral.com
 

The post Managing Database Code Quality in a Flyway Development appeared first on SQLServerCentral.

Combinations, permutations, and derangements

Publié le 1 juin 2022 sur sqlservercentral.com
 

The post Combinations, permutations, and derangements appeared first on SQLServerCentral.

 

The Job of a Technical Editor (as Louis sees it)

Publié le 30 mai 2022 sur simple-talk.com
 

One of the most essential parts of producing a great technical article, blog, or even a book, (referred to from now on generally as a work) is having someone who can check your writing and make sure it is right. You can do a mediocre job with grammar, …

 

Getting Started with Flyway and any RDBMS

Publié le 30 mai 2022 sur sqlservercentral.com
 

The post Getting Started with Flyway and any RDBMS appeared first on SQLServerCentral.

Search all String Columns in all SQL Server Tables or Views

Publié le 30 mai 2022 sur sqlservercentral.com
 

The post Search all String Columns in all SQL Server Tables or Views appeared first on SQLServerCentral.

 

Summarizing data using GROUP BY and HAVING clauses

Publié le 27 mai 2022 sur simple-talk.com
 

SQL Server provides the GROUP BY clause as a means to take a set of detailed values and summarize them into aggregated values. The detailed records can be aggregated based on one column, as well as expressions, which are specified in the GROUP BY claus …

 

 

Security in MySQL: Part Two

Publié le 27 mai 2022 sur simple-talk.com
 

Welcome back to this series about improving the security in your MySQL infrastructure. The first part of this series touched upon the reasons why should you consider securing your MySQL environment and walked you through some of the security basics. It …

 

Simple Reporting with Flyway and Database Models

Publié le 27 mai 2022 sur sqlservercentral.com
 

The post Simple Reporting with Flyway and Database Models appeared first on SQLServerCentral.

Memory profiling in Python with tracemalloc

Publié le 27 mai 2022 sur sqlservercentral.com
 

The post Memory profiling in Python with tracemalloc appeared first on SQLServerCentral.

I’m teaching Mastering Parameter Sniffing at the PASS Summit!

Publié le 26 mai 2022 sur brentozar.com
 

At the PASS Data Community Summit in Seattle on November 12th, I’m teaching a one-day pre-conference workshop. This year, the Summit is a hybrid event: you can either attend in-person in Seattle, or online via live streaming. If you attend online …

 

Datamarts and exploratory analysis using Power BI

Publié le 25 mai 2022 sur simple-talk.com
 

Power BI Datamarts is an important new feature announced during BUILD. This new feature expands Power BI possibilities in directions which may be unexpected to many Power BI users. Next, discover more about what this means for Power BI users and develo …

 

 

How to troubleshoot and fix PostgreSQL performance issues

Publié le 25 mai 2022 sur simple-talk.com
 

PostgreSQL is a popular database that is used by many applications. It’s been in active development for 30 years! PostgreSQL (or Postgres) is a powerful database management system (DBMS) that you can use and worry less about performance. Although …

 

Breaking News: SQL 2019 CU16 Changes Backup Formats, Can Break Log Shipping.

Publié le 25 mai 2022 sur brentozar.com
 

The newest Cumulative Update for SQL Server 2019 has this gem in the release notes: It’s not a known issue, it’s an improvement This is a massive problem if: You have databases encrypted with TDE You take backups WITH COMPRESSION (which has …

Sharing SQL Prompt Code Snippets and Styles via the Redgate Platform

Publié le 25 mai 2022 sur sqlservercentral.com
 

The post Sharing SQL Prompt Code Snippets and Styles via the Redgate Platform appeared first on SQLServerCentral.

Oracle optimizer removing or coalescing subqueries

Publié le 25 mai 2022 sur sqlservercentral.com
 

The post Oracle optimizer removing or coalescing subqueries appeared first on SQLServerCentral.


Pages :