Sites anglophones


SSRS is Still Around

Publié le 20 novembre 2019 sur simple-talk.com
 

The other day, a friend asked me if Microsoft is discontinuing SQL Server Reporting Services (SSRS) now that Power BI is the premier MS reporting and dashboarding tool. It seems like more organizations are finding fewer reasons to use SSRS due to the e …

How to Think Like the Engine: Index Column Order Matters a LOT.

Publié le 20 novembre 2019 sur brentozar.com
 

We’ve been working with the clustered index of the Users table, which is on the Identity column – starts at 1 and goes up to a bajillion: And in a recent episode, we added a wider nonclustered index on LastAccessDate, Id, DisplayName, and A …

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 …


Pages :