How to Patch SQL Server
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
The post Redgate Streamed: Embracing technology trends for database success appeared first on SQLServerCentral.
Mapping Data Flows in Azure Data Factory
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
The post The changing landscape of continuous database integration appeared first on SQLServerCentral.
Using Delta Schema Evolution in Azure Databricks
The post Using Delta Schema Evolution in Azure Databricks appeared first on SQLServerCentral.
Who’s Hiring in the Database Community? June 2021 Edition
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
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
The post The future of Database DevOps appeared first on SQLServerCentral.
CTE in SQL Server Examples
The post CTE in SQL Server Examples appeared first on SQLServerCentral.
Announcing My 2021/2022 Training Class Schedule
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
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
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
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
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
The post Constraints and declarative referential integrity appeared first on SQLServerCentral.