Sites anglophones


SQL SERVER – Improving Deployment Performance by SQL Server Monitoring

Publié le 20 novembre 2019 sur journey to sqlauthority
 

Why do organizations keep their entire team ready and available when any new deployment is about to happen? Well, the answer is pretty simple: there are many different variables that can go wrong when the new deployment happens. As a performance tuning …

Redgate’s journey to DevOps

Publié le 20 novembre 2019 sur sqlservercentral.com
 

The post Redgate’s journey to DevOps appeared first on SQLServerCentral.

SQL Server Function to Measure CPU Usage Per Database

Publié le 20 novembre 2019 sur sqlservercentral.com
 

The post SQL Server Function to Measure CPU Usage Per Database appeared first on SQLServerCentral.

New Pluralsight course: SQL Server: Using SentryOne Plan Explorer

Publié le 19 novembre 2019 sur sqlskills.com - paul randall
 

Jonathan’s latest Pluralsight course has been published: SQL Server: Using SentryOne Plan Explorer. It’s almost 3 hours long, and from the course description: Query plan analysis is both a science and an art, and the best too …

Writing Diagnostic Queries is Hard Because SQL Server Still Has (Tiny) Bugs.

Publié le 19 novembre 2019 sur brentozar.com
 

When I first got started working with SQL Server, I assumed it was flawless because it came in a sealed box from a ginormous corporation. I figured they’d tested every edge case, and that there was no way things were gonna go sideways. These days …

Guest Posts Invitation and Popular Award

Publié le 19 novembre 2019 sur journey to sqlauthority
 

I often get a request for the guest posts and I usually deny them as the purpose of this blog is to share what I am learning every day. However, whenever I travel to various conferences, lots of people share lots of ideas with me which they would love …

SQL Prompt 10: What’s New?

Publié le 19 novembre 2019 sur sqlservercentral.com
 

The post SQL Prompt 10: What’s New? appeared first on SQLServerCentral.

Understanding Outer Joins in SQL

Publié le 19 novembre 2019 sur sqlservercentral.com
 

Most of the time developers that need to get data will use a SELECT statement to retrieve the data. The query that a developer will use often will use a join between tables. In this article, we will look at how an outer join is different from an inner …

Associating Data Directly with SQL Server Database Objects.

Publié le 19 novembre 2019 sur sqlservercentral.com
 

The post Associating Data Directly with SQL Server Database Objects. appeared first on SQLServerCentral.

Announcing Weekend Versions of My Mastering Classes

Publié le 18 novembre 2019 sur brentozar.com
 

Last week, I noticed that an awful lot of you were buying my Level 2 and Level 3 Bundles with your own personal money (not company cards), so I wondered – if your company wasn’t paying for it, were they giving you time off? So I polled to a …

SQL SERVER – Simple Example of Batch Mode in RowStore

Publié le 18 novembre 2019 sur journey to sqlauthority
 

One of the reasons, I love my job is that I get to work with the latest technology and also get to speed up the client’s computer. Recently one of my clients upgraded their SQL Server to the latest version SQL Server 2019. After the upgrade, they …

Using Custom Deployment Scripts with SQL Compare or SQL Change Automation

Publié le 18 novembre 2019 sur sqlservercentral.com
 

The post Using Custom Deployment Scripts with SQL Compare or SQL Change Automation appeared first on SQLServerCentral.

Collections

Publié le 18 novembre 2019 sur sqlservercentral.com
 

Problem The usage of a collection of integers in some scenarios is considered to be optimal because of the overhead involved by the creation of another user table used just to store numbers, which is the most common solution. What are collections of in …

Merging tables in Power BI dataflows with PRO subscription

Publié le 18 novembre 2019 sur sqlservercentral.com
 

The post Merging tables in Power BI dataflows with PRO subscription appeared first on SQLServerCentral.

Glenn’s Tech Insights For November 17, 2019

Publié le 17 novembre 2019 sur sqlskills.com - glen berry
 

(Glenn’s Tech Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally releva …


Pages :