Sites anglophones


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 …

CData Connect: Derived Views and Query Federation

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

Enterprise-scale data integration demands scalable tools to not only centralize and curate data at scale, but also efficiently explore and analyze data at large-scale. CData Connect solves the challenge of data exploration and discovery through vi …

Implementing Deduplication Logic in the Lakehouse using Synapse Analytics Mapping Data Flow

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

The post Implementing Deduplication Logic in the Lakehouse using Synapse Analytics Mapping Data Flow appeared first on SQLServerCentral.

Bulk Loading Data via a PowerShell Script in Flyway

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

The post Bulk Loading Data via a PowerShell Script in Flyway appeared first on SQLServerCentral.

The SQL Server Posts You Read the Most in 2021

Publié le 23 décembre 2021 sur brentozar.com
 

I think of my blog posts in a few different categories: Posts that will only be read at the moment they’re published (like upcoming webcasts, humorous stuff, and career advice) Posts that will show up in search history over time and continue to b …

[Video] Office Hours: SQL Server at Sunset

Publié le 22 décembre 2021 sur brentozar.com
 

Let’s kick back with a tasty beverage and go through your highest-upvoted questions from https://pollgab.com/room/brento on the beach: https://youtu.be/hwRAwhcgCGU Here’s what we covered: 00:00 Introductions 00:49 Alexander Speshilov: How t …


Pages :