Sites anglophones


How to Patch SQL Server

Publié le 8 juin 2021 sur brentozar.com
 

Microsoft releases SQL Server Cumulative Updates about every 60 days. This is a part of your job that you’re going to be doing a lot, so let’s get good at it! Here’s the strategy I like to use. Pick what patch you’re going to ap …

Redgate Streamed: Embracing technology trends for database success

Publié le 7 juin 2021 sur sqlservercentral.com
 

The post Redgate Streamed: Embracing technology trends for database success appeared first on SQLServerCentral.

Mapping Data Flows in Azure Data Factory

Publié le 4 juin 2021 sur sqlservercentral.com
 

Introduction In Azure Data Factory, a Data flow is an activity that can be added in a pipeline. The Data flow activity is used to transfer data from a source to destination after making some transformations on the data. Mapping data flows are the visua …

The changing landscape of continuous database integration

Publié le 4 juin 2021 sur sqlservercentral.com
 

The post The changing landscape of continuous database integration appeared first on SQLServerCentral.

Using Delta Schema Evolution in Azure Databricks

Publié le 4 juin 2021 sur sqlservercentral.com
 

The post Using Delta Schema Evolution in Azure Databricks appeared first on SQLServerCentral.

Who’s Hiring in the Database Community? June 2021 Edition

Publié le 3 juin 2021 sur brentozar.com
 

Is your company hiring for a database position? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must include the job …

Updated First Responder Kit and Consultant Toolkit for June 2021

Publié le 2 juin 2021 sur brentozar.com
 

If you want to quickly understand the top health and performance issues on your SQL Server, there’s no better, easier, free-er way to do it than the open source First Responder Kit. When you find a bug or want something changed, read the contribu …

The future of Database DevOps

Publié le 2 juin 2021 sur sqlservercentral.com
 

The post The future of Database DevOps appeared first on SQLServerCentral.

CTE in SQL Server Examples

Publié le 2 juin 2021 sur sqlservercentral.com
 

The post CTE in SQL Server Examples appeared first on SQLServerCentral.

Announcing My 2021/2022 Training Class Schedule

Publié le 1 juin 2021 sur brentozar.com
 

If you want to attend my live online classes, it’s really easy: just buy a Live Class Season Pass and you can drop in on any class that works for your schedule. I recommend attending ’em in this order: Fundamentals, required, in this o …

Managing Database Documentation during Flyway-based Development

Publié le 31 mai 2021 sur sqlservercentral.com
 

The post Managing Database Documentation during Flyway-based Development appeared first on SQLServerCentral.

Model Selection and Performance Boosting with k-Fold Cross Validation and XGBoost

Publié le 31 mai 2021 sur sqlservercentral.com
 

Summary Splitting the dataset into a Training set and Test set is one of the basic and essential steps when it comes to test how our machine learning model is performing on a dataset. This helps us determine if the model is able to predict the results …

Reading and Writing your Database’s Documentation using JSON

Publié le 28 mai 2021 sur sqlservercentral.com
 

One of the problems to which I keep returning is finding the best way to read and apply documentation for databases. As part of a series of articles I’m doing for Redgate’s Product Learning, I’ve been demonstrating how to maintain a single source of da …

 

SQL Server performance tuning: Nine best practices

Publié le 28 mai 2021 sur simple-talk.com
 

SQL Server is a powerful and feature-rich database management platform that can support a wide range of applications, but if queries are not performing well or workloads are running into deadlocks, latency issues, and other disruptions in service, no o …

 

Constraints and declarative referential integrity

Publié le 28 mai 2021 sur sqlservercentral.com
 

The post Constraints and declarative referential integrity appeared first on SQLServerCentral.


Pages :