Sites anglophones


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.

2020 review: the year by the numbers

Publié le 31 décembre 2020 sur sqlskills.com - paul randall
 

The last post of the year! It’s been a terrible year all round, as I’m sure you’ll all agree, and I’m very glad we’re rolling into 2021 in a few hours. Now it’s time for my traditional post counting down some of the …

2010s: the decade in books

Publié le 31 décembre 2020 sur sqlskills.com - paul randall
 

Back in 2009 I started posting a summary at the end of the year of what I read during the year and people have been enjoying it, so I’ve continued the tradition ever since. Until 2020. I do most of my reading while traveling, which I only did onc …

Your Ten Favorite Blog Posts from 2020

Publié le 31 décembre 2020 sur brentozar.com
 

The most popular posts this year were when I ran my Fundamentals classes for free throughout the year. I ran a different class per month, and posted signups and videos here on the blog. I’m setting those aside, though, because they’re not e …

SSRS Install, Setup and Configuration

Publié le 31 décembre 2020 sur sqlservercentral.com
 

The post SSRS Install, Setup and Configuration appeared first on SQLServerCentral.

PowerShell Day By Day: The Pipeline

Publié le 31 décembre 2020 sur sqlservercentral.com
 

In this article, I wanted to discuss the PowerShell (PoSh) pipeline, which was confusing to me at first and took some time to get used to working with. I had used one in Linux before, but the PoSh one is more powerful, but also slightly different. Hope …


Pages :