Sites anglophones


New Year’s Resolution: Lose Weight in Your Database

Publié le 5 janvier 2022 sur brentozar.com
 

Made a New Year’s resolution to lose weight this year? Forget taking it off your waistline – take it off your database instead with: sp_BlitzIndex @GetAllDatabases = 1, @Mode = 2, @SortOrder = ‘size’ Or: sp_BlitzIndex @GetAllDat …

Exploring Auto-fix in SQL Code Analysis

Publié le 5 janvier 2022 sur sqlservercentral.com
 

The post Exploring Auto-fix in SQL Code Analysis appeared first on SQLServerCentral.

How to return multiple sequence numbers with sp_sequence_get_range

Publié le 5 janvier 2022 sur sqlservercentral.com
 

The post How to return multiple sequence numbers with sp_sequence_get_range appeared first on SQLServerCentral.

Who’s Hiring in the Database Community? January 2022 Edition

Publié le 4 janvier 2022 sur brentozar.com
 

Last year, I started this series of “who’s hiring” blog posts because The Great Resignation was clearly a real thing. The pandemic is causing so many folks to rethink what they do for a living, where they do it, who they do it for, an …

Here Are The Results of the 2022 Data Professional Salary Survey.

Publié le 3 janvier 2022 sur brentozar.com
 

Every year, I run a salary survey for folks in the database industry. This year, I was especially curious to see the results to find out whether salaries went up. Anecdotally, I’ve seen a lot of people jumping ship to new companies due to the Gre …

How to (Somewhat) Increase SQL Server Security

Publié le 3 janvier 2022 sur sqlservercentral.com
 

Problem Some time ago Argenis Fernandez(@DBArgenis) found and described a vulnerability that allows you to get into SQL Server with ‘sa’ rights. This method does not require a restart of the SQL Server service or the whole machine, the condition is a l …

Adding Users to Azure SQL Databases

Publié le 3 janvier 2022 sur sqlservercentral.com
 

The post Adding Users to Azure SQL Databases appeared first on SQLServerCentral.

How to Create a FOR Loop in SQL Server

Publié le 31 décembre 2021 sur sqlservercentral.com
 

The post How to Create a FOR Loop in SQL Server appeared first on SQLServerCentral.

Run Queries Across Many Data Sources at Once with the CData Query Federation Driver

Publié le 31 décembre 2021 sur sqlservercentral.com
 

The CData Query Federation Driver, allows you to federate and aggregate data across drivers as a single database connection. You can combine the Query Federation Driver with other CData JDBC Drivers or CData ADO.NET Providers t …

Dealing with Failed SQL Migrations in MariaDB or MySQL

Publié le 31 décembre 2021 sur sqlservercentral.com
 

The post Dealing with Failed SQL Migrations in MariaDB or MySQL appeared first on SQLServerCentral.

A Day in the Life of a SQL Server Data Architect

Publié le 29 décembre 2021 sur sqlservercentral.com
 

The post A Day in the Life of a SQL Server Data Architect appeared first on SQLServerCentral.

DBAs at work #3: The finance company Manager DBA

Publié le 29 décembre 2021 sur sqlservercentral.com
 

The post DBAs at work #3: The finance company Manager DBA appeared first on SQLServerCentral.

Learn about SQL Joins on Multiple Columns

Publié le 27 décembre 2021 sur sqlservercentral.com
 

The post Learn about SQL Joins on Multiple Columns appeared first on SQLServerCentral.

Flyway with MariaDB for Those of a Nervous Disposition

Publié le 27 décembre 2021 sur sqlservercentral.com
 

The post Flyway with MariaDB for Those of a Nervous Disposition appeared first on SQLServerCentral.

Views in SQL Server 2019 with SSMS

Publié le 27 décembre 2021 sur sqlservercentral.com
 

In SQL Server, a view is a virtual table with contents that you define by means of a query. The structure of a view is similar to a table. The contents of a view comprise a set of named columns and rows of data, that are generated dynamically whenever …


Pages :