Sites anglophones


New Class: Fundamentals of TempDB – Instant Replays Ready Now

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

Yesterday, I taught my first Fundamentals of TempDB class, and as always, you can watch the Instant Replays right after class completes. Here’s the abstract: You’ve been working with Microsoft SQL Server for a couple of years, and you know …

Boost performance of your SQL Server tables with a TURBO button

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

Introduction Performance, performance, performance. While performance in SQL Server can be achieved with code improvement and proper infrastructure maintenance, both tasks require an effort. Code reviews and deep index analysis would take time, but som …

Azure SQL Database TDE Customer Managed Keys

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

The post Azure SQL Database TDE Customer Managed Keys appeared first on SQLServerCentral.

SQL ConstantCare® Population Report: Fall 2020

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

Ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for SQL Server adoption rates, hardware sizes, or numbers of databases? Let’s find out in the summer 2020 version of our SQL Const …

Ten tips for attracting and retaining DevOps talent

Publié le 7 décembre 2020 sur simple-talk.com
 

DevOps can help organizations become more agile and responsive to their customers, but it’s only as effective as the individuals who participate on the DevOps teams. Getting the right people in place is paramount to a successful DevOps implementa …

Feature branches and pull requests with Git to manage conflicts

Publié le 7 décembre 2020 sur simple-talk.com
 

I’ve recently fielded two questions from different customers regarding how to best work as a team committing database changes to Git. While there are a wide variety of branching models which work well for databases with Git — Release Flow, …

Steps for Installing AlwaysOn Availability Groups – SQL 2019

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

With SQL Server 2012 Microsoft introduced the AlwaysOn Availability Group feature, and since then many changes and improvements have been made.  This article is an update to another article, and will cover the prerequisites and steps for installin …

Export SQL Server Data to Multiple Excel Worksheets with C#

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

The post Export SQL Server Data to Multiple Excel Worksheets with C# appeared first on SQLServerCentral.

Optimize SQL Server estate monitoring with Redgate’s SQL Monitor

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

The post Optimize SQL Server estate monitoring with Redgate’s SQL Monitor appeared first on SQLServerCentral.

Autoparameterized Trivial Queries May Not Get Partition Elimination

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

How’s that for a niche topic? You’re probably never going to know this, but since I had to figure it out the hard way, I’m writing this down so I don’t forget it: queries that get trivial optimization may not get partition elimi …

Rules in PostgreSQL

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

We sometimes need to perform a different/alternative actions during database queries. We need it for data protection or data abstraction. The PostgreSQL rule system allows to define an alternative action on insert, update or delete. A rule generates an …

Why you should include the database in your 2021 IT strategy

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

The post Why you should include the database in your 2021 IT strategy appeared first on SQLServerCentral.

Configure SQL Server Database Mail on Amazon RDS

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

The post Configure SQL Server Database Mail on Amazon RDS appeared first on SQLServerCentral.

Join us for this year’s final Redgate Summit

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

The post Join us for this year’s final Redgate Summit appeared first on SQLServerCentral.

How to Execute SSIS Packages from SQL Server Agent

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

The post How to Execute SSIS Packages from SQL Server Agent appeared first on SQLServerCentral.


Pages :