Sites anglophones


The Joy of Realistic Generated Fake Database Data

Publié le 8 janvier 2021 sur sqlservercentral.com
 

The post The Joy of Realistic Generated Fake Database Data appeared first on SQLServerCentral.

What is a Relational Database Management System

Publié le 7 janvier 2021 sur sqlservercentral.com
 

The post What is a Relational Database Management System appeared first on SQLServerCentral.

PostgreSQL DML Statements

Publié le 7 janvier 2021 sur sqlservercentral.com
 

DML, or Data Manipulation Language, statements are used to manipulate the data present in a database. The most important DML statements are INSERT, UPDATE & DELETE. This tutorial covers the various PostgreSQL DML statements and how we can use …

Want to Avoid Deployment Downtime? Replication Probably Isn’t the Answer.

Publié le 6 janvier 2021 sur brentozar.com
 

You’re tired of taking outages to deploy changes to your database schema. Wouldn’t it be cool to have two different SQL Servers so that you could: Point your customer traffic at ServerA Apply your deployment scripts to ServerB (which isn …

Database version control: Getting started with Flyway

Publié le 6 janvier 2021 sur simple-talk.com
 

“Database migrations made easy” and “Version control for your database” are a couple of headlines you will find on Flyway’s official website. And let me tell you this, those statements are absolutely correct. Flyway is a m …

Maintaining a Database Build Script with SQL Compare

Publié le 6 janvier 2021 sur sqlservercentral.com
 

The post Maintaining a Database Build Script with SQL Compare appeared first on SQLServerCentral.

SQL Server interview questions for experienced developers

Publié le 5 janvier 2021 sur simple-talk.com
 

This article defines ten SQL Server tech interview questions for senior SQL server developers and provides answers and examples. While there are hundreds of articles and blog posts related to SQL server interviews on the Internet, I have decided to sha …

Heaps in SQL Server: Part 4 PFS contention

Publié le 5 janvier 2021 sur simple-talk.com
 

The series so far: Heaps in SQL Server: Part 1 The Basics Heaps in SQL Server: Part 2 Optimizing Reads Heaps in SQL Server: Part 3 Nonclustered Indexes  Heaps in SQL Server: Part 4 PFS contention After looking at the internal structures and the se …

Spoofing Data Convincingly: Text Data

Publié le 5 janvier 2021 sur sqlservercentral.com
 

The most difficult data to fake or generate is convincing text. To mimic any commercial business process for an application that you are developing, you need to be able to generate text that looks right. Why would you need lots of data? Most experience …

What’s most important to you when dealing with database software?

Publié le 5 janvier 2021 sur sqlservercentral.com
 

The post What’s most important to you when dealing with database software? appeared first on SQLServerCentral.

Import Excel Data into SQL Server with PowerShell

Publié le 5 janvier 2021 sur sqlservercentral.com
 

The post Import Excel Data into SQL Server with PowerShell appeared first on SQLServerCentral.

DAX financial functions: Depreciation calculations

Publié le 4 janvier 2021 sur simple-talk.com
 

The series so far: DAX financial functions: Loan calculations DAX financial functions: Depreciation calculations This article continues the introduction to the DAX financial functions begun in DAX financial functions: Loan calculations. As noted there, …

Are You Underpaid? Find Out in the Data Professional Salary Survey Results.

Publié le 4 janvier 2021 sur brentozar.com
 

We asked what you make, and 1,747 of you in 69 countries answered. Altogether, you made $171,879,034 this year. Hubba hubba, there’s some earning power in this audience. Download the Data Professional Salary Survey results (XLSX). A few things to …

Do *not* place TEMPDB on a local disk in a SQL failover cluster

Publié le 4 janvier 2021 sur sqlservercentral.com
 

The Feature As of SQL Server 2012, using local disks for TEMPDB on a failover cluster is a fully supported feature. In the light of fast storage solutions (SSD / NVME) directly plugged into the mainboard of a system, this is a big step forward because …

SQL Server Management Studio Database Diagram Support Objects Cannot be Installed

Publié le 1 janvier 2021 sur sqlservercentral.com
 

The post SQL Server Management Studio Database Diagram Support Objects Cannot be Installed appeared first on SQLServerCentral.


Pages :