Sites anglophones


Recording What’s Changed when Running Oracle Migrations with Flyway

Publié le 15 mars 2023 sur sqlservercentral.com
 

The post Recording What’s Changed when Running Oracle Migrations with Flyway appeared first on SQLServerCentral.

[Video] Office Hours at Sea: Heading to Jamaica

Publié le 14 mars 2023 sur brentozar.com
 

I’m on a boat! I’m on a 10-day Panama Canal cruise, and I stopped (well, not the boat) off the coast of Florida to answer questions y’all posted at https://pollgab.com/room/brento. 00:00 Start 00:56 DBe: In several places I’ve w …

 

Are PostgreSQL memory parameters magic?

Publié le 13 mars 2023 sur simple-talk.com
 

Configuration parameters are the most mythical creatures in the world of PostgreSQL. Ordinary PostgreSQL users often do not know that PostgreSQL configuration parameters exist, let alone what they are and what they mean. There is a good reason for such …

 

Better Keep Up: More Free PowerShell Videos This Week.

Publié le 13 mars 2023 sur brentozar.com
 

We’re almost halfway through the month. How’s it coming? You keeping up? Or are you having a tough time because your work schedule is so busy and you can’t make 30 minutes of free time? Hey, maybe that’s because you’re a p …

How to Install the AdventureWorks Sample Database in Azure SQL Database

Publié le 13 mars 2023 sur sqlservercentral.com
 

The post How to Install the AdventureWorks Sample Database in Azure SQL Database appeared first on SQLServerCentral.

Find Invalid Objects in SQL Server

Publié le 13 mars 2023 sur sqlservercentral.com
 

One of the most important responsibilities of any database administrator is to maintain the integrity of the database, schema, and data stored in the underlying tables of any database. This article will teach us how to identify invalid or broken object …

On-Demand Webinar – Monitoring: The ROI of Build vs. Buy

Publié le 10 mars 2023 sur sqlservercentral.com
 

The post On-Demand Webinar – Monitoring: The ROI of Build vs. Buy appeared first on SQLServerCentral.

How to Implement CI/CD in Azure Data Factory (ADF)

Publié le 10 mars 2023 sur sqlservercentral.com
 

Continuous Integration and Continuous Deployment (CI/CD) are integral parts of the software development lifecycle. As a Data Engineer/ Data Professional when we build the ETL pipeline using Azure Data Factory (ADF), we need to move our code from a Deve …

SELECT DISTINCT SQL Command to Return a Unique List of Values

Publié le 10 mars 2023 sur sqlservercentral.com
 

The post SELECT DISTINCT SQL Command to Return a Unique List of Values appeared first on SQLServerCentral.

 

Build a Better WordPress Archives Page Using MySQL

Publié le 10 mars 2023 sur simple-talk.com
 

I recently wrote about a way to generate visual, interactive calendars in HTML by combining a calendar table with data from an events table (part 1 and part 2). This technique could be used to overlay any type of data onto calendars, but my specific go …

 

Do you need Trace Flag 460?

Publié le 9 mars 2023 sur sqlskills - jonathan kehayas
 

For most people that are reading this post, I’d venture to guess that you have no idea what Trace Flag 460 is or when you would use it. Well first off, let me tell you it’s a fully documented and supported trace flag, and it’s totally …

Who’s Hiring in the Microsoft Data Platform Community? March 2023 Edition

Publié le 8 mars 2023 sur brentozar.com
 

Is your company hiring for a database position as of March 2023? 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 incl …

Complex Production Database Deployments and Flyway

Publié le 8 mars 2023 sur sqlservercentral.com
 

The post Complex Production Database Deployments and Flyway appeared first on SQLServerCentral.

AWS Lambdas with C#

Publié le 8 mars 2023 sur sqlservercentral.com
 

The post AWS Lambdas with C# appeared first on SQLServerCentral.

 

Why a monitoring tool is an essential tool for growing server estates

Publié le 7 mars 2023 sur simple-talk.com
 

When I was a DBA involved with the management of a large number of database servers, I didn’t have many third-party tools to help me do my job. For the most part, I relied on scripts that I found or wrote. I enjoyed writing scripts to manage the …

 


Pages :