Sites anglophones


Why choose Oracle?

Publié le 28 septembre 2020 sur simple-talk.com
 

As an applications development professional, my career objectives are to do work that is fulfilling in the sense that it challenges my capabilities, keeps me on the cutting edge of technology, and pays me decently. I have established my career as an Or …

Building SQL ConstantCare®: Warning You About New Large Tables & Indexes

Publié le 28 septembre 2020 sur brentozar.com
 

When I’m doing a SQL Server health check, one of the things I like showing clients is a list of their top tables by size. Inevitably, there are a bunch of tables that: Tables whose names start with “temp” or “backup” or …

Solving the Provisioning Problem in Database Development using Clones

Publié le 28 septembre 2020 sur sqlservercentral.com
 

The post Solving the Provisioning Problem in Database Development using Clones appeared first on SQLServerCentral.

A Getting Started PostgreSQL Tutorial

Publié le 28 septembre 2020 sur sqlservercentral.com
 

Introduction to PostgreSQL PostgreSQL is a free and general purpose open source object-relational database system that uses and extends the SQL language. Though originally designed to run on UNIX platforms, PostgreSQL is eligible to run on various plat …

Database Development with GitHub

Publié le 25 septembre 2020 sur sqlservercentral.com
 

The post Database Development with GitHub appeared first on SQLServerCentral.

Searching and Finding a String Value in all Columns in a SQL Server Table

Publié le 25 septembre 2020 sur sqlservercentral.com
 

The post Searching and Finding a String Value in all Columns in a SQL Server Table appeared first on SQLServerCentral.

The 4 Presentations I’m Proudest Of, and What Inspired Them

Publié le 24 septembre 2020 sur brentozar.com
 

I was thinking back about the presentations I’ve been the most proud of over the years. I’ve written and performed a *lot* of stuff over time, but here are some of the free public presentations I’m the most proud of, and the stories o …

Why you Should Embed Monitoring Earlier in Your Database DevOps Cycle

Publié le 24 septembre 2020 sur sqlservercentral.com
 

The post Why you Should Embed Monitoring Earlier in Your Database DevOps Cycle appeared first on SQLServerCentral.

Incremental Data Loading using Azure Data Factory

Publié le 24 septembre 2020 sur sqlservercentral.com
 

Introduction In my last article, Loading data in Azure Synapse Analytics using Azure Data Factory, I discussed the step-by-step process for loading data from an Azure storage account to Azure Synapse SQL through Azure Data Factory (ADF). ADF basic …

I Would Love a “Cost Threshold for Recompile” Setting.

Publié le 23 septembre 2020 sur brentozar.com
 

I’m tired of sniffing your parameters. In environments where complex queries can get bad plans due to parameter sniffing, it would help to say that all queries with an estimated cost over X should be recompiled every time they run. For example, i …

Managing Azure Blueprints with PowerShell

Publié le 23 septembre 2020 sur sqlservercentral.com
 

The post Managing Azure Blueprints with PowerShell appeared first on SQLServerCentral.

SQL Server Synonyms

Publié le 22 septembre 2020 sur simple-talk.com
 

We all remember the English lesson we had in grammar school where we learned about synonyms. Just in case you don’t remember, a synonym is a noun that has a similar meaning as other words; just like intelligent has the same meaning as smart. SQL …

SQL Server Suddenly Frozen? You Might Be Snapshotting Too Many Databases.

Publié le 22 septembre 2020 sur brentozar.com
 

Snapshot backup tools like Azure Site Recovery and Veeam are great for sysadmins. They let you quickly replicate a virtual machine to somewhere else without knowing too much about the server’s contents. To pull it off, they use the Windows Volume …

Dear Past Me on My First Day as a DBA

Publié le 22 septembre 2020 sur sqlservercentral.com
 

I recently started a series on Simple Talk for those who want to be a DBA, and it made me think back to my first weeks on the job and what I would tell me “then”, knowing what I know now.  If you are just getting started as a database …

Data Masker with SQL Data Catalog Integration Automates Data Protection Process

Publié le 22 septembre 2020 sur sqlservercentral.com
 

The post Data Masker with SQL Data Catalog Integration Automates Data Protection Process appeared first on SQLServerCentral.


Pages :